Changeset: 942d62f010e3 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/942d62f010e3
Modified Files:
sql/test/SQLancer/Tests/sqlancer18.test
Branch: default
Log Message:
Queries with wrong results. Enough bugs for now
diffs (58 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer18.test
b/sql/test/SQLancer/Tests/sqlancer18.test
--- a/sql/test/SQLancer/Tests/sqlancer18.test
+++ b/sql/test/SQLancer/Tests/sqlancer18.test
@@ -517,6 +517,54 @@ statement ok
DROP TABLE t0
statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c0" INTERVAL DAY, "c1" BIGINT, "c2" DOUBLE PRECISION)
+
+statement ok rowcount 10
+INSERT INTO "t0" VALUES (INTERVAL '86400' SECOND, 5, 0.6077910886691952),
+(INTERVAL '259200' SECOND, NULL, NULL),(INTERVAL '691200' SECOND, NULL,
0.6933931143731273),
+(INTERVAL '172800' SECOND, NULL, NULL),(NULL, NULL, 0.6456379173577576),(NULL,
NULL, 0.025213044370619664),
+(NULL, NULL, 0.11141332470963072),(NULL, NULL, 0.6456379173577576),(NULL,
NULL, 62351393),(NULL, 5, NULL)
+
+statement ok
+create view v100(vc0) as (select 1.000 from t0)
+
+query T nosort
+SELECT EXISTS (SELECT vc0 = ANY(SELECT vc0) FROM v100 WHERE FALSE)
+----
+False
+
+query T nosort
+SELECT EXISTS (SELECT vc0 = ANY(SELECT vc0) FROM v100 WHERE FALSE) FROM t0
+----
+False
+False
+False
+False
+False
+False
+False
+False
+False
+False
+
+query T nosort
+SELECT t0.c0 FROM t0 WHERE EXISTS (SELECT tv0l1n0.vc0 < ANY(SELECT tv0l1n0.vc0
FROM v100 WHERE FALSE) FROM v100 AS tv0l1n0
+WHERE 1 NOT BETWEEN SYMMETRIC 6 AND 0)
+----
+
+query I nosort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(EXISTS (SELECT tv0l1n0.vc0
< ANY(SELECT tv0l1n0.vc0 FROM v100 WHERE FALSE)
+FROM v100 AS tv0l1n0 WHERE 1 NOT BETWEEN SYMMETRIC 6 AND 0) AS INT) as count
FROM t0) as res
+----
+0
+
+statement ok
+ROLLBACK
+
+statement ok
CREATE TABLE "t0" ("c0" TIME,"c1" DOUBLE PRECISION)
statement ok
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
