Changeset: 983f426d99bc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/983f426d99bc Added Files: sql/test/BugTracker-2025/Tests/7611_multiple_unnd_constraints.test sql/test/BugTracker-2025/Tests/All sql/test/BugTracker-2025/Tests/SingleServer Branch: Aug2024 Log Message:
Add test for issue #7611 diffs (37 lines): diff --git a/sql/test/BugTracker-2025/Tests/7611_multiple_unnd_constraints.test b/sql/test/BugTracker-2025/Tests/7611_multiple_unnd_constraints.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/7611_multiple_unnd_constraints.test @@ -0,0 +1,24 @@ +statement ok +CREATE TABLE tunnd0(c1 int, c2 varchar(9), c3 dec(10,2), UNIQUE NULLS NOT DISTINCT (c1, c2), UNIQUE NULLS NOT DISTINCT (c2, c3)) + +statement ok +CREATE TABLE tunnd1(c1 int, c2 varchar(9), c3 dec(10,2), UNIQUE NULLS NOT DISTINCT (c1, c2), UNIQUE NULLS DISTINCT (c2, c3)) + +query TI rowsort +SELECT name, type FROM sys.keys WHERE table_id IN (SELECT id FROM sys.tables WHERE NOT system AND name LIKE 'tunnd%') +---- +tunnd0_c1_c2_nndunique +3 +tunnd0_c2_c3_nndunique +3 +tunnd1_c1_c2_nndunique +3 +tunnd1_c2_c3_unique +1 + +statement ok +DROP TABLE IF EXISTS tunnd0 + +statement ok +DROP TABLE tunnd1 + diff --git a/sql/test/BugTracker-2025/Tests/All b/sql/test/BugTracker-2025/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/All @@ -0,0 +1,1 @@ +7611_multiple_unnd_constraints diff --git a/sql/test/BugTracker-2025/Tests/SingleServer b/sql/test/BugTracker-2025/Tests/SingleServer new file mode 100644 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
