Changeset: 4556ffde6ee7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4556ffde6ee7
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
SQLancer query with wrong results
diffs (30 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
@@ -376,3 +376,26 @@ SELECT t2.c0 FROM t2 RIGHT OUTER JOIN t0
SELECT CAST(((t0.c0)<(COALESCE((SELECT DISTINCT t0.c0 FROM t0, t2, t1), t0.c0,
t2.c0))) AS INT) FROM t2 RIGHT OUTER JOIN t0 ON t2.c0 = ANY(SELECT t1.c0 FROM
t1, t2);
-- more than one row returned
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" TIME NOT NULL,"c1" INTERVAL SECOND,"c2"
TIME,CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"));
+INSERT INTO "t0" VALUES (TIME '03:34:11', INTERVAL '1713881698' SECOND, NULL);
+CREATE TABLE "t1" ("c0" TIME,"c2" TIME);
+INSERT INTO "t1" VALUES (TIME '20:46:35', NULL);
+INSERT INTO "t1" VALUES (TIME '21:28:54', NULL);
+INSERT INTO "t1" VALUES (TIME '08:15:08', TIME '20:32:11');
+CREATE TABLE "t2" ("c0" BOOLEAN NOT NULL,"c1" BOOLEAN,CONSTRAINT "t2_c0_pkey"
PRIMARY KEY ("c0"),CONSTRAINT "t2_c0_unique" UNIQUE ("c0"),CONSTRAINT
"t2_c1_unique" UNIQUE ("c1"));
+
+SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON (t2.c1) WHERE (SELECT t1.c2 FROM
t1) = ALL(SELECT t0.c2 FROM t0, t2);
+ -- NULL
+ -- NULL
+ -- 20:32:11
+SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON NOT (t2.c1) WHERE
(((((((0.9842272043385978) NOT IN (1721458345))OR(t2.c0)))AND((t2.c0) BETWEEN
ASYMMETRIC (t2.c0) AND
+((SELECT ALL t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT t1.c2 FROM t1, t2) =
ALL(SELECT ALL t0.c2 FROM t0, t1, t2)));
+ -- NULL
+ -- NULL
+ -- 20:32:11
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((((((0.9842272043385978)
NOT IN (1721458345))OR(t2.c0)))AND((t2.c0) BETWEEN ASYMMETRIC (t2.c0) AND
+((SELECT t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT ALL t1.c2 FROM t1, t2) =
ALL(SELECT t0.c2 FROM t0, t1, t2))) AS INT) as count FROM t2 RIGHT OUTER JOIN
t1 ON NOT (t2.c1)) as res;
+ -- 3
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
