Changeset: 9ee656c8da55 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ee656c8da55
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.test
Branch: default
Log Message:
Query with wrong results
diffs (57 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.test
b/sql/test/SQLancer/Tests/sqlancer11.test
--- a/sql/test/SQLancer/Tests/sqlancer11.test
+++ b/sql/test/SQLancer/Tests/sqlancer11.test
@@ -727,3 +727,53 @@ SELECT 1 FROM t0 GROUP BY t0.c1 HAVING m
statement ok
ROLLBACK
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c0" INTEGER,"c1" DOUBLE PRECISION,CONSTRAINT
"t0_c0_unique" UNIQUE ("c0"))
+
+statement ok
+INSERT INTO "t0" VALUES (7, NULL),(NULL, NULL),(9, NULL),(-793549595,
NULL),(6, NULL),(233979498, NULL),(0, NULL),
+(1748037394, -1),(4, NULL),(-270118799, NULL),(-24786483, NULL),(NULL,
NULL),(798507700, 4),(1415564245, 0.8530306516131312)
+
+statement ok
+CREATE TABLE "t1" ("c0" INTEGER,"c2" UUID)
+
+statement ok
+INSERT INTO "t1" VALUES (1212396328, NULL),(-4, NULL),(-270118799, NULL),(1,
NULL),(2, '5a6cad30-d7a2-e40b-b55b-aba3ac86aadd')
+
+statement ok
+CREATE TABLE "t2" ("c0" INTEGER NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY KEY
("c0"))
+
+statement ok
+INSERT INTO "t2" VALUES (4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(0)
+
+query I rowsort
+SELECT 1 FROM t0, t2 RIGHT OUTER JOIN (VALUES (((SELECT '1') INTERSECT ALL
(SELECT DISTINCT '3' FROM t2 AS l1t2 WHERE FALSE)))) AS sub0 ON ('6' LIKE
(SELECT DISTINCT 'e' FROM t1 AS l2t1)) GROUP BY t0.c1;
+----
+1
+1
+1
+1
+
+query I rowsort
+SELECT 1 FROM t0, t2 RIGHT OUTER JOIN (VALUES (((SELECT '1') INTERSECT ALL
(SELECT DISTINCT '3' FROM t2 AS l1t2 WHERE FALSE)))) AS sub0 ON ('6' LIKE
(SELECT DISTINCT 'e' FROM t1 AS l2t1)) GROUP BY t0.c1 HAVING count(*) <> 0;
+----
+1
+1
+1
+1
+
+query I rowsort
+SELECT 1 FROM t0, t2 RIGHT OUTER JOIN (VALUES (((SELECT '1') INTERSECT ALL
(SELECT DISTINCT '3' FROM t2 AS l1t2 WHERE FALSE)))) AS sub0 ON ('6' LIKE
(SELECT DISTINCT 'e' FROM t1 AS l2t1)) GROUP BY t0.c1 HAVING NOT (count(*) <>
0);
+----
+
+
+query I rowsort
+SELECT 1 FROM t0, t2 RIGHT OUTER JOIN (VALUES (((SELECT '1') INTERSECT ALL
(SELECT DISTINCT '3' FROM t2 AS l1t2 WHERE FALSE)))) AS sub0 ON ('6' LIKE
(SELECT DISTINCT 'e' FROM t1 AS l2t1)) GROUP BY t0.c1 HAVING (count(*) <> 0) IS
NULL;
+----
+
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
