Changeset: f1f9b243fe37 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f1f9b243fe37
Modified Files:
sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
sql/test/testdb-upgrade/Tests/dump.stable.out
Branch: default
Log Message:
Approve upgrade from new database.
diffs (110 lines):
diff --git a/sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
b/sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
--- a/sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
+++ b/sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
@@ -32,15 +32,22 @@ Ready.
START TRANSACTION;
CREATE USER "testuser" WITH ENCRYPTED PASSWORD
'e9e633097ab9ceb3e48ec3f70ee2beba41d05d5420efee5da85f97d97005727587fda33ef4ff2322088f4c79e8133cc9cd9f3512f4d3a303cbdb5bc585415a00'
NAME 'Test User' SCHEMA "sys";
CREATE SCHEMA "testschema" AUTHORIZATION "testuser";
+COMMENT ON SCHEMA "testschema" IS 'a schema used for testing';
ALTER USER "testuser" SET SCHEMA "testschema";
CREATE SEQUENCE "testschema"."selfref_seq" AS INTEGER;
+COMMENT ON SEQUENCE "testschema"."selfref_seq" IS 'sequence number for selfref
table';
CREATE SEQUENCE "testschema"."test_seq" AS INTEGER;
+COMMENT ON SEQUENCE "testschema"."test_seq" IS 'sequence number for testing';
SET SCHEMA "testschema";
CREATE TABLE "testschema"."smallstring" (
"string1" VARCHAR(5),
"string2" CHAR(5),
"string3" CHARACTER LARGE OBJECT
);
+COMMENT ON TABLE "testschema"."smallstring" IS 'table to test small strings';
+COMMENT ON COLUMN "testschema"."smallstring"."string1" IS 'first column of
table to test small strings';
+COMMENT ON COLUMN "testschema"."smallstring"."string2" IS 'second column of
table to test small strings';
+COMMENT ON COLUMN "testschema"."smallstring"."string3" IS 'third column of
table to test small strings';
COPY 66 RECORDS INTO "testschema"."smallstring" FROM stdin USING DELIMITERS
'\t','\n','"';
"a0" "b0" "c0"
"a1" "b1" "c1"
@@ -101126,6 +101133,12 @@ CREATE TABLE "testschema"."test" (
"id" INTEGER,
"i" SMALLINT DEFAULT next value for "testschema"."test_seq"
);
+CREATE INDEX "i1" ON "testschema"."test" ("id", "i");
+CREATE ORDERED INDEX "i2" ON "testschema"."test" ("id");
+CREATE IMPRINTS INDEX "i3" ON "testschema"."test" ("id");
+COMMENT ON INDEX "testschema"."i1" IS 'a unique index used for testing';
+COMMENT ON INDEX "testschema"."i2" IS 'an ordered index used for testing';
+COMMENT ON INDEX "testschema"."i3" IS 'an imprints index used for testing';
COPY 5 RECORDS INTO "testschema"."test" FROM stdin USING DELIMITERS
'\t','\n','"';
0 7
1 10
@@ -101287,6 +101300,7 @@ ALTER TABLE "testschema"."mt2" ADD TABLE
ALTER TABLE "testschema"."mt1" ADD TABLE "t1";
ALTER TABLE "testschema"."mt1" ADD TABLE "t2";
create view keytest3 as select t2.key1, t2.key2, t1.key3 from keytest1 t1,
keytest2 t2 where t1.key1 = t2.key1 and t1.key2 = t2.key2;
+COMMENT ON VIEW "testschema"."keytest3" IS 'a view used for testing';
create trigger keytesttrigger after update on keytest1 referencing new row as
new_row for each row insert into keytest2 values (new_row.key1, new_row.key2);
create function keyjoin()
returns table (
@@ -101301,6 +101315,7 @@ begin
where keytest1.key1 = keytest2.key1 and keytest1.key2 = keytest2.key2
);
end;
+COMMENT ON FUNCTION "testschema"."keyjoin"() IS 'function used for testing';
create function nleaves()
returns integer
begin
diff --git a/sql/test/testdb-upgrade/Tests/dump.stable.out
b/sql/test/testdb-upgrade/Tests/dump.stable.out
--- a/sql/test/testdb-upgrade/Tests/dump.stable.out
+++ b/sql/test/testdb-upgrade/Tests/dump.stable.out
@@ -27,15 +27,22 @@ Ready.
START TRANSACTION;
CREATE USER "testuser" WITH ENCRYPTED PASSWORD
'e9e633097ab9ceb3e48ec3f70ee2beba41d05d5420efee5da85f97d97005727587fda33ef4ff2322088f4c79e8133cc9cd9f3512f4d3a303cbdb5bc585415a00'
NAME 'Test User' SCHEMA "sys";
CREATE SCHEMA "testschema" AUTHORIZATION "testuser";
+COMMENT ON SCHEMA "testschema" IS 'a schema used for testing';
ALTER USER "testuser" SET SCHEMA "testschema";
CREATE SEQUENCE "testschema"."selfref_seq" AS INTEGER;
+COMMENT ON SEQUENCE "testschema"."selfref_seq" IS 'sequence number for selfref
table';
CREATE SEQUENCE "testschema"."test_seq" AS INTEGER;
+COMMENT ON SEQUENCE "testschema"."test_seq" IS 'sequence number for testing';
SET SCHEMA "testschema";
CREATE TABLE "testschema"."smallstring" (
"string1" VARCHAR(5),
"string2" CHAR(5),
"string3" CHARACTER LARGE OBJECT
);
+COMMENT ON TABLE "testschema"."smallstring" IS 'table to test small strings';
+COMMENT ON COLUMN "testschema"."smallstring"."string1" IS 'first column of
table to test small strings';
+COMMENT ON COLUMN "testschema"."smallstring"."string2" IS 'second column of
table to test small strings';
+COMMENT ON COLUMN "testschema"."smallstring"."string3" IS 'third column of
table to test small strings';
COPY 66 RECORDS INTO "testschema"."smallstring" FROM stdin USING DELIMITERS
'\t','\n','"';
"a0" "b0" "c0"
"a1" "b1" "c1"
@@ -101121,6 +101128,12 @@ CREATE TABLE "testschema"."test" (
"id" INTEGER,
"i" SMALLINT DEFAULT next value for "testschema"."test_seq"
);
+CREATE INDEX "i1" ON "testschema"."test" ("id", "i");
+CREATE ORDERED INDEX "i2" ON "testschema"."test" ("id");
+CREATE IMPRINTS INDEX "i3" ON "testschema"."test" ("id");
+COMMENT ON INDEX "testschema"."i1" IS 'a unique index used for testing';
+COMMENT ON INDEX "testschema"."i2" IS 'an ordered index used for testing';
+COMMENT ON INDEX "testschema"."i3" IS 'an imprints index used for testing';
COPY 5 RECORDS INTO "testschema"."test" FROM stdin USING DELIMITERS
'\t','\n','"';
0 7
1 10
@@ -101282,6 +101295,7 @@ ALTER TABLE "testschema"."mt2" ADD TABLE
ALTER TABLE "testschema"."mt1" ADD TABLE "t1";
ALTER TABLE "testschema"."mt1" ADD TABLE "t2";
create view keytest3 as select t2.key1, t2.key2, t1.key3 from keytest1 t1,
keytest2 t2 where t1.key1 = t2.key1 and t1.key2 = t2.key2;
+COMMENT ON VIEW "testschema"."keytest3" IS 'a view used for testing';
create trigger keytesttrigger after update on keytest1 referencing new row as
new_row for each row insert into keytest2 values (new_row.key1, new_row.key2);
create function keyjoin()
returns table (
@@ -101296,6 +101310,7 @@ begin
where keytest1.key1 = keytest2.key1 and keytest1.key2 = keytest2.key2
);
end;
+COMMENT ON FUNCTION "testschema"."keyjoin"() IS 'function used for testing';
create function nleaves()
returns integer
begin
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
