Changeset: 9211bcd25c35 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9211bcd25c35
Modified Files:
sql/test/SQLancer/Tests/sqlancer15.test
Branch: Jul2021
Log Message:
More wrong results
diffs (44 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer15.test
b/sql/test/SQLancer/Tests/sqlancer15.test
--- a/sql/test/SQLancer/Tests/sqlancer15.test
+++ b/sql/test/SQLancer/Tests/sqlancer15.test
@@ -432,3 +432,40 @@ 9
statement ok
ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE "t0" ("c3" INTERVAL SECOND)
+
+statement ok rowcount 9
+INSERT INTO "t0" VALUES (INTERVAL '6' SECOND),(INTERVAL '9' SECOND),(INTERVAL
'1' SECOND),
+(INTERVAL '0' SECOND),(INTERVAL '9' SECOND),(INTERVAL '4' SECOND),(INTERVAL
'6' SECOND),(INTERVAL '1' SECOND),(NULL)
+
+query T rowsort
+SELECT (SELECT 2 WHERE FALSE) = ANY(SELECT 3 WHERE FALSE)
+----
+False
+
+query T rowsort
+SELECT t0.c3 FROM t0 WHERE ifthenelse((SELECT 2 WHERE FALSE) = ANY(SELECT 3
WHERE FALSE), 2, 1)
+----
+0:00:00
+0:00:01
+0:00:01
+0:00:04
+0:00:06
+0:00:06
+0:00:09
+0:00:09
+NULL
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(ifthenelse((SELECT 2 WHERE
FALSE) = ANY(SELECT 3 WHERE FALSE), 2, 1) AS INT) as count FROM t0) as res
+----
+9
+
+statement ok
+ROLLBACK
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
