Changeset: d835a9f6c14d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d835a9f6c14d Modified Files: sql/test/SQLancer/Tests/sqlancer04.sql Branch: Oct2020 Log Message:
SQLancer: cannot create object. Enough bugs for now diffs (18 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql b/sql/test/SQLancer/Tests/sqlancer04.sql --- a/sql/test/SQLancer/Tests/sqlancer04.sql +++ b/sql/test/SQLancer/Tests/sqlancer04.sql @@ -426,3 +426,14 @@ ILIKE(CAST(30792 AS STRING(381))))) as r ROLLBACK; select cast(count(1) as interval second) from (values (false)) as v6(vc0); --error + +CREATE TABLE IF NOT EXISTS t0(c0 boolean UNIQUE PRIMARY KEY, c1 DOUBLE , UNIQUE(c1, c0)); +CREATE TABLE IF NOT EXISTS t1(LIKE t0); +ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t0(c0); +ALTER TABLE t1 ADD PRIMARY KEY(c0, c1); +INSERT INTO t0(c0) VALUES(FALSE),(TRUE); +INSERT INTO t1(c1, c0) VALUES(0.3, FALSE), (0.5, true), (0.00000000000000000, true), (497053888, false), (1, true), (4, true); +DELETE FROM t1 WHERE NOT least(t1.c0, t1.c0); +UPDATE t1 SET c1 = (CAST(((0.17)>>(0.12)) AS INT)) WHERE t1.c1 BETWEEN SYMMETRIC 3 AND 7 + t1.c1; +DROP TABLE t1; +DROP TABLE t0; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
