Changeset: 302ab43788dc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/302ab43788dc
Modified Files:
sql/test/SQLancer/Tests/sqlancer15.test
Branch: Jul2021
Log Message:
Last week I forgot to commit this query with wrong results only under mitosis
diffs (37 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
@@ -658,6 +658,33 @@ statement ok
START TRANSACTION
statement ok
+CREATE TABLE "t0" ("c3" TIMESTAMP)
+
+statement ok rowcount 10
+INSERT INTO "t0" VALUES (NULL),(TIMESTAMP '1969-12-12
05:35:15.000000'),(TIMESTAMP '1970-01-01 01:00:00.000000'),(NULL),(TIMESTAMP
'1970-01-01 01:00:00.000000'),
+(TIMESTAMP '1970-01-20 20:06:22.000000'),(TIMESTAMP '1969-12-23
08:46:37.000000'),(TIMESTAMP '1970-01-01 01:00:00.000000'),(NULL),(TIMESTAMP
'1970-01-01 01:00:00.000000')
+
+query T rowsort
+SELECT t0.c3 FROM t0 WHERE (NOT FALSE OR (SELECT TRUE WHERE FALSE)) AND NOT
"isauuid"('1')
+----
+1969-12-12 05:35:15
+1969-12-23 08:46:37
+1970-01-01 01:00:00
+1970-01-01 01:00:00
+1970-01-01 01:00:00
+1970-01-01 01:00:00
+1970-01-20 20:06:22
+NULL
+NULL
+NULL
+
+statement ok
+ROLLBACK
+
+statement ok
+START TRANSACTION
+
+statement ok
CREATE TABLE "t0" ("c3" INTERVAL SECOND)
statement ok rowcount 9
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
