Changeset: 3aed0d1bbb09 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3aed0d1bbb09 Modified Files: sql/test/SQLancer/Tests/sqlancer04.sql sql/test/SQLancer/Tests/sqlancer09.sql Branch: Oct2020 Log Message:
Updated previous bug and had to add this one: BATgroup_internal: Assertion (hs)->nbucket >= 256 failed diffs (39 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,13 @@ 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); +CREATE TABLE t0(c0 BOOLEAN PRIMARY KEY,c1 DOUBLE); +CREATE TABLE 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); +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 = (CAST(((0.17)>>(0.12)) AS INT)) WHERE t1.c1 BETWEEN SYMMETRIC 3 AND 7 + t1.c1; +UPDATE t1 SET c1 = 0 WHERE t1.c1 BETWEEN SYMMETRIC 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 @@ -420,3 +420,14 @@ inner join (values (+ (88)), (greatest(0 or(v0.vc1)) group by v0.vc1) as sub1 where (v0.vc0) in (0.06683239) group by least(-1913343924, 10622), ((v1.vc1)not ilike(least(v1.vc1, v1.vc1))); ROLLBACK; + +CREATE TABLE t0(c0 BOOLEAN PRIMARY KEY, c1 DOUBLE); +CREATE TABLE t1(LIKE t0); +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; +DROP TABLE t1; +DROP TABLE t0; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
