Changeset: 0dbe3839e358 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0dbe3839e358 Modified Files: sql/test/SQLancer/Tests/sqlancer09.sql Branch: Oct2020 Log Message:
SQLancer statements generating assertion error at hashjoin diffs (17 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer09.sql b/sql/test/SQLancer/Tests/sqlancer09.sql --- a/sql/test/SQLancer/Tests/sqlancer09.sql +++ b/sql/test/SQLancer/Tests/sqlancer09.sql @@ -282,3 +282,13 @@ CAST(1847496204 AS BOOLEAN) WHEN CASE WH WHEN ((t2.c1)LIKE(t2.c1)) THEN (t1.c0) IN (t2.c0, t1.c0) ELSE (t2.c1) NOT BETWEEN SYMMETRIC (t1.c1) AND (t2.c1) END FROM t2, t1 WHERE CAST(20726 AS BOOLEAN)) AS sub0 ON ((CAST(t1.c1 AS STRING))ILIKE(t1.c1)); ROLLBACK; + +CREATE TABLE t1(c0 FLOAT); +ALTER TABLE t1 ADD UNIQUE(c0); +INSERT INTO t1(c0) VALUES(13.38); +DELETE FROM t1 WHERE true; +INSERT INTO t1(c0) VALUES(0.9), (0.5), (-3), (0.4); +ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t1(c0); +INSERT INTO t1(c0) VALUES(null); +DELETE FROM t1; +DROP TABLE t1; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
