Changeset: b69b76872ae9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b69b76872ae9
Modified Files:
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
sql/test/testdb/Tests/load.test
Branch: Aug2024
Log Message:
Add test for dumping UNIQUE NULLS NOT DISTINCT constraints.
diffs (39 lines):
diff --git a/sql/test/testdb/Tests/dump-nogeom.stable.out
b/sql/test/testdb/Tests/dump-nogeom.stable.out
--- a/sql/test/testdb/Tests/dump-nogeom.stable.out
+++ b/sql/test/testdb/Tests/dump-nogeom.stable.out
@@ -101174,7 +101174,8 @@ CREATE TABLE "testschema"."keytest1" (
"key2" INTEGER NOT NULL,
"key3" INTEGER,
CONSTRAINT "keytest1_key1_key2_pkey" PRIMARY KEY ("key1", "key2"),
- CONSTRAINT "keytest1_key3_unique" UNIQUE ("key3")
+ CONSTRAINT "keytest1_key3_unique" UNIQUE ("key3"),
+ CONSTRAINT "keytest1_key1_key3_nndunique" UNIQUE NULLS NOT DISTINCT
("key1", "key3")
);
COPY 4 RECORDS INTO "testschema"."keytest1" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
0 0 0
diff --git a/sql/test/testdb/Tests/dump.stable.out
b/sql/test/testdb/Tests/dump.stable.out
--- a/sql/test/testdb/Tests/dump.stable.out
+++ b/sql/test/testdb/Tests/dump.stable.out
@@ -101174,7 +101174,8 @@ CREATE TABLE "testschema"."keytest1" (
"key2" INTEGER NOT NULL,
"key3" INTEGER,
CONSTRAINT "keytest1_key1_key2_pkey" PRIMARY KEY ("key1", "key2"),
- CONSTRAINT "keytest1_key3_unique" UNIQUE ("key3")
+ CONSTRAINT "keytest1_key3_unique" UNIQUE ("key3"),
+ CONSTRAINT "keytest1_key1_key3_nndunique" UNIQUE NULLS NOT DISTINCT
("key1", "key3")
);
COPY 4 RECORDS INTO "testschema"."keytest1" FROM stdin USING DELIMITERS
E'\t',E'\n','"';
0 0 0
diff --git a/sql/test/testdb/Tests/load.test b/sql/test/testdb/Tests/load.test
--- a/sql/test/testdb/Tests/load.test
+++ b/sql/test/testdb/Tests/load.test
@@ -101244,7 +101244,8 @@ CREATE TABLE "testschema"."keytest1" (
"key2" INTEGER NOT NULL,
"key3" INTEGER,
CONSTRAINT "keytest1_key1_key2_pkey" PRIMARY KEY ("key1", "key2"),
- CONSTRAINT "keytest1_key3_unique" UNIQUE ("key3")
+ CONSTRAINT "keytest1_key3_unique" UNIQUE ("key3"),
+ CONSTRAINT "keytest1_key1_key3_nndunique" UNIQUE NULLS NOT DISTINCT
("key1", "key3")
)
statement ok
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
