Changeset: e7547b50ed60 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e7547b50ed60 Added Files: sql/test/BugTracker-2026/Tests/7783-deleted-row.test Modified Files: sql/test/BugTracker-2026/Tests/All Branch: Dec2025 Log Message:
add test for issue #7782 diffs (93 lines): diff --git a/sql/test/BugTracker-2026/Tests/7783-deleted-row.test b/sql/test/BugTracker-2026/Tests/7783-deleted-row.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2026/Tests/7783-deleted-row.test @@ -0,0 +1,82 @@ +statement ok +create table test (a int not null, b int not null, primary key (a, b)) + +statement ok +insert into test values (1, 1) + +statement ok +delete from test where a = 1; + +statement ok +insert into test values (1, 1) + +-- BUG: returns 2 identical rows (1, 1), this violates the constraint +query II +select * from test where a = 1 and b = 1 +---- +1 +1 + +-- OK: returns 1 row +query II +select * from test where a = 1 +---- +1 +1 + +query II +select * from test where b = 1 +---- +1 +1 + +query II +select * from test +---- +1 +1 + +statement ok +drop table test + +-- also happens with a composite unique constraint: +statement ok +create table test (a int, b int, unique (a, b)) + +statement ok +insert into test values (1, 1) + +statement ok +delete from test where a = 1; + +statement ok +insert into test values (1, 1) + +-- BUG: returns 2 identical rows (1, 1), this violates the constraint +query II +select * from test where a = 1 and b = 1 +---- +1 +1 + +-- OK: returns 1 row +query II +select * from test where a = 1 +---- +1 +1 + +query II +select * from test where b = 1 +---- +1 +1 + +query II +select * from test +---- +1 +1 + +statement ok +drop table test diff --git a/sql/test/BugTracker-2026/Tests/All b/sql/test/BugTracker-2026/Tests/All --- a/sql/test/BugTracker-2026/Tests/All +++ b/sql/test/BugTracker-2026/Tests/All @@ -1,1 +1,2 @@ 7780-unnest-slow +7783-deleted-row _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
