(I)LIKE with multiple % doen't find matches #6864
Milestone
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
{{ message }}
Date: 2020-05-20 10:13:42 +0200
From: @sjoerdmullender
To: SQL devs <>
Version: 11.35.19 (Nov2019-SP3)
CC: aabadi
Last updated: 2020-06-03 16:58:53 +0200
Comment 27720
Date: 2020-05-20 10:13:42 +0200
From: @sjoerdmullender
In certain cases, (I)LIKE doesn't match strings that should match.
With these strings and using ILIKE:
Guatemala
Guatemala-Mobile
Guatemala-Mobile Comcel
Guatemala-Mobile Movistar
Guatemala-Mobile PCS
Guatemala-Telgua
Guatemala-Telefonica
the pattern '%guate%mo%com%' should match one value, but it matches none.
The pattern '%guate%com%' does match the one value it should.
Comment 27721
Date: 2020-05-20 10:14:12 +0200
From: MonetDB Mercurial Repository <>
Changeset 6ee8bd513f65 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=6ee8bd513f65
Changeset description:
Comment 27722
Date: 2020-05-20 11:36:44 +0200
From: MonetDB Mercurial Repository <>
Changeset 619c4a6d52ba 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=619c4a6d52ba
Changeset description:
Comment 27725
Date: 2020-05-20 22:11:12 +0200
From: @sjoerdmullender
*** Bug #6865 has been marked as a duplicate of this bug. ***
The text was updated successfully, but these errors were encountered: