Changeset: 1e8a8c55ab75 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1e8a8c55ab75 Modified Files: sql/test/SQLancer/Tests/sqlancer04.sql sql/test/SQLancer/Tests/sqlancer09.sql Branch: Oct2020 Log Message:
Simplifying diffs (40 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 @@ -427,13 +427,9 @@ ROLLBACK; select cast(count(1) as interval second) from (values (false)) as v6(vc0); --error -CREATE TABLE t0(c0 BOOLEAN PRIMARY KEY,c1 DOUBLE); -CREATE TABLE t1(LIKE t0); -ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t0(c0); +CREATE TABLE t1(c0 BOOLEAN, c1 DOUBLE); 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.0, true), (4, false), (1, true), (4, true); -DELETE FROM t1 WHERE NOT least(t1.c0, t1.c0); -UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN SYMMETRIC 3 AND 7 + t1.c1; +DELETE FROM t1 WHERE NOT t1.c0; +UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN 3 AND 7 + t1.c1; DROP TABLE t1; -DROP TABLE t0; 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 @@ -421,13 +421,10 @@ or(v0.vc1)) group by v0.vc1) as sub1 whe ((v1.vc1)not ilike(least(v1.vc1, v1.vc1))); ROLLBACK; -CREATE TABLE t0(c0 BOOLEAN PRIMARY KEY, c1 DOUBLE); -CREATE TABLE t1(LIKE t0); +CREATE TABLE t1(c0 BOOLEAN, c1 DOUBLE); INSERT INTO t1(c0) VALUES(true); -ALTER TABLE t1 ADD FOREIGN KEY (c0) REFERENCES t0(c0); TRUNCATE t1; ALTER TABLE t1 ADD PRIMARY KEY(c0, c1); -INSERT INTO t1(c1, c0) VALUES(7,true),(5,false),(2,true),(4,false),(3,false),(1,true),(4,true); -UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN SYMMETRIC 3 AND 7 + t1.c1; +INSERT INTO t1(c1, c0) VALUES(7,true),(5,false),(2,true),(4,false); +UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN SYMMETRIC 3 AND t1.c1; DROP TABLE t1; -DROP TABLE t0; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
