Date: 2020-06-10 14:05:07 +0200
From: @PedroTadim
To: SQL devs <>
Version: 11.37.7 (Jun2020)

Last updated: 2020-07-27 09:30:14 +0200

Comment 27815

Date: 2020-06-10 14:05:07 +0200
From: @PedroTadim

User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36
Build Identifier:

Run the query below for an assertion failure.

Reproducible: Always

Steps to Reproduce:

1. insert into integers(i) values(((length(reverse('8 \rcr੧[bp1eMY쫺4j5s뮯!<Rn4*}')))>>(((- (- (528640982)))&(ascii('528640982'))))));

Actual Results:

mserver5: ../../../../src/monetdb5/modules/atoms/str.c:2924: UTF8_assert: Assertion `0' failed.

Expected Results:

I'm not sure, but the shift should be too large, so a runtime error should be thrown.

Comment 27816

Date: 2020-06-10 14:57:04 +0200
From: MonetDB Mercurial Repository <>

Changeset e4cb5e4c3341 made by Pedro Ferreira pedro.ferreira@monetdbsolutions.com in the MonetDB repo, refers to this bug.

For complete details, see https//devmonetdborg/hg/MonetDB?cmd=changeset;node=e4cb5e4c3341

Changeset description:

Fix for bug #6885. Added support for UTF-8 strings at reverse(string) function