Changeset: 277936942d2a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/277936942d2a
Modified Files:
sql/test/SQLancer/Tests/sqlancer18.test
Branch: default
Log Message:
Approved output
diffs (28 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
@@ -573,12 +573,10 @@ CREATE TABLE "t1" ("c0" INT)
statement ok rowcount 17
INSERT INTO "t1" VALUES
(1),(10),(7),(9),(NULL),(1),(7),(7),(0),(8),(0),(9),(NULL),(5),(3),(8),(0)
-# this one could be an error too
query T rowsort
select (FALSE) in (TRUE, (select time '13:35:07' from t1) between t0.c0 and
t0.c0) from t0
----
-# this one could be an error too
query T rowsort
select (FALSE) in (FALSE, (select time '13:35:07' from t1) between t0.c0 and
t0.c0) from t0
----
@@ -586,8 +584,10 @@ select (FALSE) in (FALSE, (select time '
statement ok rowcount 1
INSERT INTO "t0" VALUES (NULL, 1)
-statement error GDK reported error: BATsubcross: more than one match
+query T rowsort
select (FALSE) in (FALSE, (select time '13:35:07' from t1) between t0.c0 and
t0.c0) from t0
+----
+True
statement ok
DROP TABLE t0
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
