Changeset: f22b65bd6b9d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f22b65bd6b9d Modified Files: sql/test/BugTracker-2024/Tests/inequality-hash-issue-7426.test sql/test/BugTracker-2024/Tests/pkey-check-failed-7425.test Branch: Dec2023 Log Message:
Extend tests with cleaup of created tables, added query to show content and added a version when statements are done within a transaction. diffs (112 lines): diff --git a/sql/test/BugTracker-2024/Tests/inequality-hash-issue-7426.test b/sql/test/BugTracker-2024/Tests/inequality-hash-issue-7426.test --- a/sql/test/BugTracker-2024/Tests/inequality-hash-issue-7426.test +++ b/sql/test/BugTracker-2024/Tests/inequality-hash-issue-7426.test @@ -1,3 +1,46 @@ +statement ok +CREATE TABLE t1(c1 INTEGER) + +statement ok +CREATE TABLE t0(c0 BOOL, c1 INTEGER) + +statement ok +INSERT INTO t1 (c1) VALUES (0) + +statement ok +CREATE UNIQUE INDEX i0 ON t0(c1 , c0 ) + +statement ok +INSERT INTO t0 (c0, c1) VALUES (true, 0) + +query III +SELECT t0.c0, t0.c1, t1.c1 FROM t1 INNER JOIN t0 ON t0.c0 +---- +1 +0 +0 + +query I +SELECT (t0.c1) IS NOT NULL FROM t1 INNER JOIN t0 ON t0.c0 +---- +1 + +query III +SELECT t0.c0, t0.c1, t1.c1 FROM t1 INNER JOIN t0 ON t0.c0 WHERE (t0.c1) IS NOT NULL +---- +1 +0 +0 + +statement ok +DROP TABLE t0 + +statement ok +DROP TABLE t1 + +-- repeat test but within a transaction +statement ok +start transaction statement ok CREATE TABLE t1(c1 INTEGER) @@ -32,3 +75,6 @@ SELECT t0.c0, t0.c1, t1.c1 FROM t1 INNER 1 0 0 + +statement ok +rollback diff --git a/sql/test/BugTracker-2024/Tests/pkey-check-failed-7425.test b/sql/test/BugTracker-2024/Tests/pkey-check-failed-7425.test --- a/sql/test/BugTracker-2024/Tests/pkey-check-failed-7425.test +++ b/sql/test/BugTracker-2024/Tests/pkey-check-failed-7425.test @@ -13,5 +13,51 @@ delete from ttt where id=2 statement ok update ttt set id = 3 where id = 3 +query II +select id, k from ttt order by id +---- +1 +3 +3 +4 +4 +3 +5 +3 + statement ok drop table ttt + +-- repeat test but within a transaction +statement ok +start transaction + +statement ok +create table ttt(id int primary key,k int NOT NULL DEFAULT '0') + +statement ok +insert into ttt values(1,3),(2,3),(3,3),(4,3),(5,3) + +statement ok +update ttt set k=k+1 where id=3 + +statement ok +delete from ttt where id=2 + +statement ok +update ttt set id = 3 where id = 3 + +query II +select id, k from ttt order by id +---- +1 +3 +3 +4 +4 +3 +5 +3 + +statement ok +rollback _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
