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