Changeset: 82cfc16811b2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/82cfc16811b2 Added Files: sql/test/2023/Tests/unique_nulls_distinct.test Modified Files: sql/test/2023/Tests/All Branch: literal_features Log Message:
add tests for various unique constraints diffs (136 lines): diff --git a/sql/test/2023/Tests/All b/sql/test/2023/Tests/All --- a/sql/test/2023/Tests/All +++ b/sql/test/2023/Tests/All @@ -1,3 +1,4 @@ literals btrim any_value +unique_nulls_distinct diff --git a/sql/test/2023/Tests/unique_nulls_distinct.test b/sql/test/2023/Tests/unique_nulls_distinct.test new file mode 100644 --- /dev/null +++ b/sql/test/2023/Tests/unique_nulls_distinct.test @@ -0,0 +1,123 @@ + +statement ok +CREATE TABLE und1 (i1 int, i2 int, UNIQUE (i1, i2)) + +statement ok +CREATE TABLE und2 (i1 int, i2 int, UNIQUE NULLS DISTINCT (i1, i2)) + +statement ok +CREATE TABLE unnd1 (i1 int, i2 int, UNIQUE NULLS NOT DISTINCT (i1, i2)) + +statement ok +INSERT INTO und1 VALUES (NULL, 10) + +statement ok +INSERT INTO und1 VALUES (NULL, 10), (NULL, 10) + +statement ok +INSERT INTO und1 VALUES (20, 10) + +statement error +INSERT INTO und1 VALUES (20, 10) + +statement error +INSERT INTO und1 VALUES (30, 10), (30, 10) + +statement ok +INSERT INTO und2 VALUES (NULL, 10) + +statement ok +INSERT INTO und2 VALUES (NULL, 10), (NULL, 10) + +statement ok +INSERT INTO und2 VALUES (20, 10) + +statement error +INSERT INTO und2 VALUES (20, 10) + +statement error +INSERT INTO und2 VALUES (30, 10), (30, 10) + +statement error +INSERT INTO unnd1 VALUES (NULL, 10), (NULL, 10) + +statement ok +INSERT INTO unnd1 VALUES (NULL, 10) + +statement error +INSERT INTO unnd1 VALUES (NULL, 10) + +statement ok +INSERT INTO unnd1 VALUES (20, 10) + +statement error +INSERT INTO unnd1 VALUES (20, 10) + +statement error +INSERT INTO unnd1 VALUES (30, 10), (30, 10) + +statement ok +CREATE TABLE und3 (i1 int UNIQUE) + +statement ok +CREATE TABLE und4 (i1 int UNIQUE NULLS DISTINCT ) + +statement ok +CREATE TABLE unnd2 (i1 int UNIQUE NULLS NOT DISTINCT) + +statement ok +INSERT INTO und3 VALUES (NULL) + +statement ok +INSERT INTO und3 VALUES (NULL), (NULL) + +statement ok +INSERT INTO und3 VALUES (10) + +statement error +INSERT INTO und3 VALUES (10) + +statement error +INSERT INTO und3 VALUES (10), (20) + +statement error +INSERT INTO und3 VALUES (30), (30) + +statement ok +INSERT INTO und4 VALUES (NULL) + +statement ok +INSERT INTO und4 VALUES (NULL), (NULL) + +statement ok +INSERT INTO und4 VALUES (10) + +statement error +INSERT INTO und4 VALUES (10) + +statement error +INSERT INTO und4 VALUES (10), (20) + +statement error +INSERT INTO und4 VALUES (30), (30) + +statement error +INSERT INTO unnd2 VALUES (NULL), (NULL) + +statement ok +INSERT INTO unnd2 VALUES (NULL) + +statement error +INSERT INTO unnd2 VALUES (NULL) + +statement ok +INSERT INTO unnd2 VALUES (10) + +statement error +INSERT INTO unnd2 VALUES (10) + +statement error +INSERT INTO unnd2 VALUES (10), (20) + +statement error +INSERT INTO unnd2 VALUES (30), (30) _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org