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
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:41.0) Gecko/20100101 Firefox/41.0
Build Identifier:
This bug is similar, but not the same as bug #3851. In the query below a comparison is used "15 > 1". The outcome of the comparison should not matter as the whole expression should evaluate to FALSE regardless, but the presence of the comparison makes it evaluate to TRUE. The bug does not seem to occur if anything else than a comparison with a variable is put here, including "15 > 1" or "TRUE".
This was tested in a version that already fixed bug #3851.
Reproducible: Always
Steps to Reproduce:
Run the following commands in mclient:
CREATE TABLE test (id INTEGER, foo INTEGER);
INSERT INTO test VALUES (1, 1);
SELECT t.id, t.foo FROM test t
WHERE FALSE
AND (TRUE OR TRUE)
AND ((FALSE AND (TRUE OR FALSE))
OR (15 > t.foo)
);
Date: 2015-11-09 11:26:50 +0100
From: @rkoopmanschap
To: SQL devs <>
Version: 11.21.11 (Jul2015-SP1)
CC: @njnes
Last updated: 2016-01-15 11:37:57 +0100
Comment 21486
Date: 2015-11-09 11:26:50 +0100
From: @rkoopmanschap
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:41.0) Gecko/20100101 Firefox/41.0
Build Identifier:
This bug is similar, but not the same as bug #3851. In the query below a comparison is used "15 > 1". The outcome of the comparison should not matter as the whole expression should evaluate to FALSE regardless, but the presence of the comparison makes it evaluate to TRUE. The bug does not seem to occur if anything else than a comparison with a variable is put here, including "15 > 1" or "TRUE".
This was tested in a version that already fixed bug #3851.
Reproducible: Always
Steps to Reproduce:
Run the following commands in mclient:
CREATE TABLE test (id INTEGER, foo INTEGER);
INSERT INTO test VALUES (1, 1);
SELECT t.id, t.foo FROM test t
WHERE FALSE
AND (TRUE OR TRUE)
AND ((FALSE AND (TRUE OR FALSE))
OR (15 > t.foo)
);
Actual Results:
+------+------+
| id | foo |
+======+======+
| 1 | 1 |
+------+------+
Expected Results:
+----+-----+
| id | foo |
+====+=====+
+----+-----+
This is a bug report from our client CHS.
Comment 21487
Date: 2015-11-09 11:36:19 +0100
From: MonetDB Mercurial Repository <>
Changeset a84afe3cb9fc made by Richard Koopmanschap richard.koopmanschap@monetdbsolutions.com in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=a84afe3cb9fc
Changeset description:
Comment 21488
Date: 2015-11-09 13:47:14 +0100
From: @njnes
fixed. The sql select push down lost one of the boolean expressions. This is fixed now..
Comment 21489
Date: 2015-11-09 15:25:35 +0100
From: MonetDB Mercurial Repository <>
Changeset 3e237ae16358 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=3e237ae16358
Changeset description:
The text was updated successfully, but these errors were encountered: