Changeset: f90e6e340085 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f90e6e340085
Modified Files:
sql/test/testdb/Tests/dump-nogeom.stable.out
sql/test/testdb/Tests/dump.stable.out
sql/test/testdb/Tests/load.test
Branch: Dec2025
Log Message:
Test dumping of unlogged table.
Test for bug #7772.
diffs (90 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
@@ -10,6 +10,7 @@ ALTER USER "testuser2" SET SCHEMA "testu
GRANT COPY FROM TO "testuser";
CREATE SEQUENCE "testschema"."selfref_seq" AS INTEGER;
COMMENT ON SEQUENCE "testschema"."selfref_seq" IS 'sequence number for selfref
table';
+CREATE SEQUENCE "testschema"."seq_8177" AS INTEGER;
CREATE SEQUENCE "testschema"."test_seq" AS INTEGER;
COMMENT ON SEQUENCE "testschema"."test_seq" IS 'sequence number for testing';
SET SCHEMA "testschema";
@@ -101209,6 +101210,11 @@ CREATE TABLE "testschema"."double_check"
CONSTRAINT "double_check_c1_check" CHECK (c1 >= 1),
CONSTRAINT "c2gtc1" CHECK (c2 is null or c2 > c1)
);
+CREATE UNLOGGED TABLE "testschema"."unlogged_table" (
+ "id" INTEGER NOT NULL,
+ "nm" VARCHAR(99),
+ CONSTRAINT "unlogged_table_id_pkey" PRIMARY KEY ("id")
+);
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL,
"parentid" INTEGER,
@@ -101445,11 +101451,13 @@ CREATE FUNCTION "testschema"."pyapi10_mu
}
;
ALTER TABLE "testschema"."test" ALTER COLUMN "i" SET DEFAULT next value for
"testschema"."test_seq";
+ALTER TABLE "testschema"."unlogged_table" ALTER COLUMN "id" SET DEFAULT next
value for "testschema"."seq_8177";
ALTER TABLE "testschema"."selfref" ALTER COLUMN "id" SET DEFAULT next value
for "testschema"."selfref_seq";
ALTER TABLE "testschema"."t1" ALTER COLUMN "z" SET DEFAULT 0;
ALTER TABLE "testschema"."keytest2" ADD CONSTRAINT "keytest2_key1_key2_fkey"
FOREIGN KEY ("key1", "key2") REFERENCES "testschema"."keytest1" ("key1",
"key2") ON DELETE CASCADE;
ALTER TABLE "testschema"."selfref" ADD CONSTRAINT "selfref_parentid_fkey"
FOREIGN KEY ("parentid") REFERENCES "testschema"."selfref" ("id");
ALTER SEQUENCE "testschema"."selfref_seq" RESTART WITH 7 NO CYCLE;
+ALTER SEQUENCE "testschema"."seq_8177" RESTART WITH 1 NO CYCLE;
ALTER SEQUENCE "testschema"."test_seq" RESTART WITH 8 INCREMENT BY 3 MINVALUE
5 MAXVALUE 10 CYCLE;
ALTER TABLE "testschema"."testme" ADD TABLE "testschema"."subtable1" AS
PARTITION FROM RANGE MINVALUE TO '11' WITH NULL VALUES;
ALTER TABLE "testschema"."testme" ADD TABLE "testschema"."subtable2" AS
PARTITION FROM '11' TO '20';
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
@@ -10,6 +10,7 @@ ALTER USER "testuser2" SET SCHEMA "testu
GRANT COPY FROM TO "testuser";
CREATE SEQUENCE "testschema"."selfref_seq" AS INTEGER;
COMMENT ON SEQUENCE "testschema"."selfref_seq" IS 'sequence number for selfref
table';
+CREATE SEQUENCE "testschema"."seq_8177" AS INTEGER;
CREATE SEQUENCE "testschema"."test_seq" AS INTEGER;
COMMENT ON SEQUENCE "testschema"."test_seq" IS 'sequence number for testing';
SET SCHEMA "testschema";
@@ -101209,6 +101210,11 @@ CREATE TABLE "testschema"."double_check"
CONSTRAINT "double_check_c1_check" CHECK (c1 >= 1),
CONSTRAINT "c2gtc1" CHECK (c2 is null or c2 > c1)
);
+CREATE UNLOGGED TABLE "testschema"."unlogged_table" (
+ "id" INTEGER NOT NULL,
+ "nm" VARCHAR(99),
+ CONSTRAINT "unlogged_table_id_pkey" PRIMARY KEY ("id")
+);
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL,
"parentid" INTEGER,
@@ -101463,11 +101469,13 @@ CREATE FUNCTION "testschema"."pyapi10_mu
}
;
ALTER TABLE "testschema"."test" ALTER COLUMN "i" SET DEFAULT next value for
"testschema"."test_seq";
+ALTER TABLE "testschema"."unlogged_table" ALTER COLUMN "id" SET DEFAULT next
value for "testschema"."seq_8177";
ALTER TABLE "testschema"."selfref" ALTER COLUMN "id" SET DEFAULT next value
for "testschema"."selfref_seq";
ALTER TABLE "testschema"."t1" ALTER COLUMN "z" SET DEFAULT 0;
ALTER TABLE "testschema"."keytest2" ADD CONSTRAINT "keytest2_key1_key2_fkey"
FOREIGN KEY ("key1", "key2") REFERENCES "testschema"."keytest1" ("key1",
"key2") ON DELETE CASCADE;
ALTER TABLE "testschema"."selfref" ADD CONSTRAINT "selfref_parentid_fkey"
FOREIGN KEY ("parentid") REFERENCES "testschema"."selfref" ("id");
ALTER SEQUENCE "testschema"."selfref_seq" RESTART WITH 7 NO CYCLE;
+ALTER SEQUENCE "testschema"."seq_8177" RESTART WITH 1 NO CYCLE;
ALTER SEQUENCE "testschema"."test_seq" RESTART WITH 8 INCREMENT BY 3 MINVALUE
5 MAXVALUE 10 CYCLE;
ALTER TABLE "testschema"."testme" ADD TABLE "testschema"."subtable1" AS
PARTITION FROM RANGE MINVALUE TO '11' WITH NULL VALUES;
ALTER TABLE "testschema"."testme" ADD TABLE "testschema"."subtable2" AS
PARTITION FROM '11' TO '20';
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
@@ -101319,6 +101319,12 @@ create table testschema.double_check (
)
statement ok
+create unlogged table testschema.unlogged_table (
+ id serial,
+ nm varchar(99)
+)
+
+statement ok
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL DEFAULT next value for
"testschema"."selfref_seq",
"parentid" INTEGER,
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
