You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
There are two ways of combining NOT and LIKE: NOT x LIKE y and x NOT LIKE y. The first case was not properly dealt with, which results in an infinite recursion when processing logical value expressions. The recursion ends in a "Too many nested operators" error.
This bug is fixed by Changeset: 9d0956084854 Also, the combination: NOT x NOT LIKE y should work now.
The text was updated successfully, but these errors were encountered:
Date: 2015-11-18 12:57:04 +0100
From: @yzchang
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @yzchang
Last updated: 2016-01-15 11:37:35 +0100
Comment 21550
Date: 2015-11-18 12:57:04 +0100
From: @yzchang
The following query triggers a "too many nested operators" error:
CREATE TABLE foo (col CHAR(8));
INSERT INTO foo VALUES ('bee');
SELECT * FROM foo WHERE NOT col LIKE 'b%';
Comment 21551
Date: 2015-11-18 13:04:26 +0100
From: MonetDB Mercurial Repository <>
Changeset 2995f557a12f made by Jennie Zhang y.zhang@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=2995f557a12f
Changeset description:
Comment 21552
Date: 2015-11-18 13:12:14 +0100
From: @yzchang
There are two ways of combining NOT and LIKE: NOT x LIKE y and x NOT LIKE y. The first case was not properly dealt with, which results in an infinite recursion when processing logical value expressions. The recursion ends in a "Too many nested operators" error.
This bug is fixed by Changeset: 9d0956084854 Also, the combination: NOT x NOT LIKE y should work now.
The text was updated successfully, but these errors were encountered: