Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ILIKE clauses don't work on certain characters #6633

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

ILIKE clauses don't work on certain characters #6633

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2018-08-01 16:57:09 +0200
From: @PedroTadim
To: SQL devs <>
Version: -- development

Last updated: 2018-08-31 13:23:25 +0200

Comment 26579

Date: 2018-08-01 16:57:09 +0200
From: @PedroTadim

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

Ilike doesn't work properly on characters such as ä,ö,ü.

Reproducible: Always

Steps to Reproduce:

  1. CREATE TABLE debugme (acol CLOB);
  2. INSERT INTO debugme VALUES ('aa'), ('aä'), ('aÄ');
  3. SELECT acol FROM debugme WHERE acol ILIKE '%ä%';

Actual Results:

+------+
| acol |
+======+
| aä |
+------+

Expected Results:

+------+
| acol |
+======+
| aä |
| aÄ |
+------+

This works on MonetDBLite because we had to remove the PCRE dependency ;)

Comment 26580

Date: 2018-08-01 17:28:45 +0200
From: MonetDB Mercurial Repository <>

Changeset e565656ecb74 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=e565656ecb74

Changeset description:

Added test for bug #6633.

Comment 26586

Date: 2018-08-03 12:40:14 +0200
From: MonetDB Mercurial Repository <>

Changeset fccfa2ae186e made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

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

Changeset description:

Don't use strcasecmp and strcasestr since they work byte-for-byte.
This fixes bug #6633.

Comment 26587

Date: 2018-08-03 12:55:46 +0200
From: @sjoerdmullender

It turns out you can't use strcasecmp usefully on UTF-8-encoded strings.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants