NOT x LIKE triggers "too many nested operators"

[monetdb-team]

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:

Added test for Bug #3871

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.