Changeset: e067c6c56890 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e067c6c56890
Modified Files:
sql/test/SQLancer/Tests/sqlancer15.test
Branch: Jul2021
Log Message:
Query with wrong results only when the column is a primary key
diffs (33 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
@@ -714,6 +714,29 @@ statement ok
START TRANSACTION
statement ok
+CREATE TABLE "t0" ("c2" DATE, CONSTRAINT "t0_c2_pkey" PRIMARY KEY ("c2"))
+
+statement ok rowcount 2
+INSERT INTO "t0" VALUES (DATE '1970-01-04'), (DATE '1970-01-01')
+
+query T rowsort
+SELECT t0.c2 FROM t0 WHERE (t0.c2) IN (t0.c2, (VALUES (DATE '1969-12-10'),
(DATE '1970-01-01')))
+----
+1970-01-01
+1970-01-04
+
+query I rowsort
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((t0.c2) IN (t0.c2, (VALUES
(DATE '1969-12-10'), (DATE '1970-01-01'))) AS INT) as count FROM t0) as res
+----
+2
+
+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
