Changeset: fe01876fcba1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fe01876fcba1
Modified Files:
sql/test/SQLancer/Tests/sqlancer14.test
Branch: default
Log Message:
Queries with wrong results.
Now back to the weekend
diffs (34 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer14.test
b/sql/test/SQLancer/Tests/sqlancer14.test
--- a/sql/test/SQLancer/Tests/sqlancer14.test
+++ b/sql/test/SQLancer/Tests/sqlancer14.test
@@ -686,3 +686,30 @@ 8
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t1" ("c0" VARCHAR(64) NOT NULL,"c1" INT NOT NULL,"c3" REAL NOT
NULL,"c5" REAL)
+
+statement ok
+INSERT INTO "t1" VALUES ('-1065519696', 0, 0.035891276, 0.15286948)
+
+query T rowsort
+SELECT t1.c5 FROM t1 WHERE (SELECT 0.0 GROUP BY 9) <> ALL(SELECT 1.2 WHERE
FALSE)
+----
+0.15286948
+
+query T rowsort
+SELECT (SELECT 1 FROM t1) <> ALL(SELECT 2 WHERE FALSE) FROM t1;
+----
+True
+
+query T rowsort
+SELECT (SELECT 1 GROUP BY 3) <> ALL(SELECT 2 WHERE FALSE) FROM t1;
+----
+True
+
+statement ok
+ROLLBACK
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
