Changeset: 5bfe7b1a718d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/5bfe7b1a718d
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:
Avoid columns of type `serial` in the testdb test.
We cannot control the name of the sequence created.
diffs (86 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,7 +10,6 @@ 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";
@@ -101211,9 +101210,8 @@ CREATE TABLE "testschema"."double_check"
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")
+ "id" INTEGER,
+ "nm" VARCHAR(99)
);
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL,
@@ -101451,13 +101449,11 @@ 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,7 +10,6 @@ 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";
@@ -101211,9 +101210,8 @@ CREATE TABLE "testschema"."double_check"
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")
+ "id" INTEGER,
+ "nm" VARCHAR(99)
);
CREATE TABLE "testschema"."selfref" (
"id" INTEGER NOT NULL,
@@ -101469,13 +101467,11 @@ 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
@@ -101320,7 +101320,7 @@ create table testschema.double_check (
statement ok
create unlogged table testschema.unlogged_table (
- id serial,
+ id int,
nm varchar(99)
)
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
