Changeset: 3579870c8071 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3579870c8071
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.sql
Branch: Oct2020
Log Message:
Query with wrong results
diffs (25 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.sql
b/sql/test/SQLancer/Tests/sqlancer11.sql
--- a/sql/test/SQLancer/Tests/sqlancer11.sql
+++ b/sql/test/SQLancer/Tests/sqlancer11.sql
@@ -70,3 +70,21 @@ SELECT 4 = ANY(SELECT t2.c2 FROM t2) FRO
-- True
-- True
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" REAL,"c1" BOOLEAN,"c3" DOUBLE PRECISION);
+INSERT INTO "t0" VALUES (NULL, false, NULL);
+CREATE TABLE "t1" ("c0" REAL);
+INSERT INTO "t1" VALUES
(2),(2),(2),(2),(2),(2),(2),(0.27167553),(0.67248166),(0.7818908),(-9.1086214e+08),(-0.9899925);
+CREATE TABLE "t2" ("c0" REAL,"c1" BOOLEAN);
+INSERT INTO "t2" VALUES (-1.2357439e+08, false), (0.16160075, false), (NULL,
true);
+
+SELECT t0.c3 FROM t2, t0 WHERE FALSE BETWEEN t0.c3 = ANY(SELECT t0.c0 FROM t0
WHERE t0.c1) AND TRUE;
+ -- NULL
+ -- NULL
+ -- NULL
+SELECT FALSE BETWEEN t0.c3 = ANY(SELECT t0.c0 FROM t0 WHERE t0.c1) AND TRUE
FROM t2, t0;
+ -- True
+ -- True
+ -- True
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
