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
Date: 2014-06-27 17:22:18 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.17 (Jan2014-SP2)
CC: @njnes
Last updated: 2014-10-31 14:15:01 +0100
Comment 19858
Date: 2014-06-27 17:22:18 +0200
From: Martin van Dinther <<martin.van.dinther>>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
Build Identifier:
SQL statements with syntax
fail to execute
SELECT '' AS "Not False" WHERE f1 = NOT FALSE;
SELECT '' AS "Not True" WHERE f1 = NOT TRUE;
Reproducible: Always
Steps to Reproduce:
CREATE TABLE BOOLTBL1 (f1 bool);
INSERT INTO BOOLTBL1 (f1) VALUES (cast('true' AS boolean));
INSERT INTO BOOLTBL1 (f1) VALUES ('true');
INSERT INTO BOOLTBL1 (f1) VALUES ('false');
-- next two queries fail with a syntax error:
SELECT f1 FROM BOOLTBL1 WHERE f1 = NOT FALSE;
SELECT f1 FROM BOOLTBL1 WHERE f1 = NOT TRUE;
-- next similar queries run fine:
SELECT f1 FROM BOOLTBL1 WHERE f1 = (NOT FALSE);
SELECT f1 FROM BOOLTBL1 WHERE NOT FALSE = f1;
SELECT f1 FROM BOOLTBL1 WHERE NOT f1 = FALSE;
SELECT f1 FROM BOOLTBL1 WHERE f1 = (NOT TRUE);
SELECT f1 FROM BOOLTBL1 WHERE NOT TRUE = f1;
SELECT f1 FROM BOOLTBL1 WHERE NOT f1 = TRUE;
something is wrong with the order of execution of an = NOT expression
Actual Results:
Error: syntax error, unexpected NOT in: "select f1 from booltbl1 where f1 = not"
Expected Results:
no syntax error and query result output
These tests are already included in sql/test/pg_regress/Test/boolean.sql
together with corrected stable.out and stable.err files.
So once this bug is resolved that test should report OK instead of current MAJOR
Date: 2014-06-27 17:22:18 +0200
From: Martin van Dinther <<martin.van.dinther>>
To: SQL devs <>
Version: 11.17.17 (Jan2014-SP2)
CC: @njnes
Last updated: 2014-10-31 14:15:01 +0100
Comment 19858
Date: 2014-06-27 17:22:18 +0200
From: Martin van Dinther <<martin.van.dinther>>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:30.0) Gecko/20100101 Firefox/30.0
Build Identifier:
SQL statements with syntax
fail to execute
SELECT '' AS "Not False" WHERE f1 = NOT FALSE;
SELECT '' AS "Not True" WHERE f1 = NOT TRUE;
Reproducible: Always
Steps to Reproduce:
CREATE TABLE BOOLTBL1 (f1 bool);
INSERT INTO BOOLTBL1 (f1) VALUES (cast('true' AS boolean));
INSERT INTO BOOLTBL1 (f1) VALUES ('true');
INSERT INTO BOOLTBL1 (f1) VALUES ('false');
-- next two queries fail with a syntax error:
SELECT f1 FROM BOOLTBL1 WHERE f1 = NOT FALSE;
SELECT f1 FROM BOOLTBL1 WHERE f1 = NOT TRUE;
-- next similar queries run fine:
SELECT f1 FROM BOOLTBL1 WHERE f1 = (NOT FALSE);
SELECT f1 FROM BOOLTBL1 WHERE NOT FALSE = f1;
SELECT f1 FROM BOOLTBL1 WHERE NOT f1 = FALSE;
SELECT f1 FROM BOOLTBL1 WHERE f1 = (NOT TRUE);
SELECT f1 FROM BOOLTBL1 WHERE NOT TRUE = f1;
SELECT f1 FROM BOOLTBL1 WHERE NOT f1 = TRUE;
something is wrong with the order of execution of an = NOT expression
Actual Results:
Error: syntax error, unexpected NOT in: "select f1 from booltbl1 where f1 = not"
Expected Results:
no syntax error and query result output
These tests are already included in sql/test/pg_regress/Test/boolean.sql
together with corrected stable.out and stable.err files.
So once this bug is resolved that test should report OK instead of current MAJOR
Comment 19887
Date: 2014-07-09 10:47:46 +0200
From: MonetDB Mercurial Repository <>
Changeset be17bc388a09 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=be17bc388a09
Changeset description:
Comment 19982
Date: 2014-08-06 19:06:53 +0200
From: @njnes
fixed handling of bool with not.
Comment 19987
Date: 2014-08-06 19:12:37 +0200
From: MonetDB Mercurial Repository <>
Changeset 516d270cbe32 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=516d270cbe32
Changeset description:
Comment 20402
Date: 2014-10-31 14:15:01 +0100
From: @sjoerdmullender
Oct2014 has been released.
The text was updated successfully, but these errors were encountered: