Changeset: c05a8d7f1c39 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c05a8d7f1c39
Modified Files:
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
sql/test/testdb/Tests/load.test
Branch: default
Log Message:
Add test for dumping new types of constraints.
diffs (65 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
@@ -101190,6 +101190,18 @@ 0 0
0 1
1 0
1 1
+CREATE TABLE "testschema"."nulls_not_distinct" (
+ "id" INTEGER NOT NULL,
+ "unique1" INTEGER,
+ "unique2" INTEGER,
+ "check1" INTEGER,
+ CONSTRAINT "nulls_not_distinct_id_pkey" PRIMARY KEY ("id"),
+ CONSTRAINT "nulls_not_distinct_unique1_unique" UNIQUE ("unique1"),
+ CONSTRAINT "nulls_not_distinct_unique2_nndunique" UNIQUE NULLS NOT
DISTINCT ("unique2"),
+ CONSTRAINT "nulls_not_distinct_check1_check" CHECK("check1" > 0)
+);
+COPY 1 RECORDS INTO "testschema"."nulls_not_distinct" FROM stdin USING
DELIMITERS E'\t',E'\n','"';
+1 1 1 1
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL,
"parentid" INTEGER,
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
@@ -101190,6 +101190,18 @@ 0 0
0 1
1 0
1 1
+CREATE TABLE "testschema"."nulls_not_distinct" (
+ "id" INTEGER NOT NULL,
+ "unique1" INTEGER,
+ "unique2" INTEGER,
+ "check1" INTEGER,
+ CONSTRAINT "nulls_not_distinct_id_pkey" PRIMARY KEY ("id"),
+ CONSTRAINT "nulls_not_distinct_unique1_unique" UNIQUE ("unique1"),
+ CONSTRAINT "nulls_not_distinct_unique2_nndunique" UNIQUE NULLS NOT
DISTINCT ("unique2"),
+ CONSTRAINT "nulls_not_distinct_check1_check" CHECK("check1" > 0)
+);
+COPY 1 RECORDS INTO "testschema"."nulls_not_distinct" FROM stdin USING
DELIMITERS E'\t',E'\n','"';
+1 1 1 1
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL,
"parentid" INTEGER,
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
@@ -101300,6 +101300,17 @@ statement ok
comment on function keyjoin is 'function used for testing'
statement ok
+create table testschema.nulls_not_distinct (
+ id integer primary key,
+ unique1 integer unique nulls distinct,
+ unique2 integer unique nulls not distinct,
+ check1 integer check (check1 > 0)
+)
+
+statement ok
+insert into testschema.nulls_not_distinct values (1, 1, 1, 1)
+
+statement ok
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL DEFAULT next value for
"testschema"."selfref_seq",
"parentid" INTEGER,
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
