Changeset: d2a96a4d9141 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d2a96a4d9141
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
Another query with wrong results
diffs (36 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -417,3 +417,32 @@ SELECT t1.c0 > COALESCE((SELECT INTERVAL
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST((t1.c0) NOT BETWEEN
ASYMMETRIC (COALESCE((SELECT DISTINCT INTERVAL '1584712456' SECOND FROM t2),
(SELECT t1.c0 FROM t2, t1, t0))) AND (t1.c0) AS INT) as count FROM t1) as res;
-- 1
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" TIME,"c1" TIMESTAMP NOT NULL,CONSTRAINT "t0_c1_pkey"
PRIMARY KEY ("c1"));
+INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-06 16:28:55.000000');
+INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-18 19:02:05.000000');
+INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-09 14:51:19.000000');
+INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-25 19:25:31.000000');
+INSERT INTO "t0" VALUES (TIME '15:23:49', TIMESTAMP '1970-01-13
01:58:15.000000');
+CREATE TABLE "t1" ("c1" TIMESTAMP NOT NULL,CONSTRAINT "t1_c1_pkey" PRIMARY KEY
("c1"));
+INSERT INTO "t1" VALUES (TIMESTAMP '1970-01-16 14:51:17.000000');
+INSERT INTO "t1" VALUES (TIMESTAMP '1970-01-14 12:10:12.000000');
+INSERT INTO "t1" VALUES (TIMESTAMP '1970-01-02 08:05:41.000000');
+CREATE TABLE "t2" ("c1" TIMESTAMP NOT NULL,CONSTRAINT "t2_c1_pkey" PRIMARY KEY
("c1"));
+
+SELECT t1.c1 FROM t1 WHERE COALESCE(NOT (SELECT FALSE FROM t2), true);
+ -- 1970-01-16 14:51:17
+ -- 1970-01-14 12:10:12
+ -- 1970-01-02 08:05:41
+SELECT t1.c1 FROM t1 WHERE COALESCE(NOT (SELECT FALSE FROM t2), false);
+ -- empty
+SELECT t1.c1 FROM t1 WHERE COALESCE(NOT ((SELECT DISTINCT FALSE FROM t1, t0,
t2)), COALESCE((FALSE) = FALSE, ((t1.c1)<(t1.c1)), (t1.c1) NOT BETWEEN
SYMMETRIC (TIMESTAMP '1970-01-02 00:34:29')
+AND (t1.c1), (FALSE) = FALSE, (DATE '1970-01-01') NOT IN (DATE '1970-01-02',
DATE '1970-01-02')), FALSE);
+ -- 1970-01-16 14:51:17
+ -- 1970-01-14 12:10:12
+ -- 1970-01-02 08:05:41
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(COALESCE(NOT ((SELECT
DISTINCT FALSE FROM t1, t0, t2)), COALESCE((FALSE) = FALSE, ((t1.c1)<(t1.c1)),
(t1.c1) NOT BETWEEN SYMMETRIC (TIMESTAMP '1970-01-02 00:34:29')
+AND (t1.c1), (FALSE) = FALSE, (DATE '1970-01-01') NOT IN (DATE '1970-01-02',
DATE '1970-01-02')), FALSE) AS INT) as count FROM t1) as res;
+ -- 3
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
