[prev in list] [next in list] [prev in thread] [next in thread]
List: monetdb-checkins
Subject: MonetDB: Mar2018 - Approve upgrade from new database.
From: Sjoerd Mullender <commits+sjoerd=acm.org () monetdb ! org>
Date: 2018-03-30 13:50:23
Message-ID: hg.9726707dc9b9.1522417823.6315528441665844383 () monetdb-vm0 ! spin-off ! cwi ! nl
[Download RAW message or body]
Changeset: 9726707dc9b9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9726707dc9b9
Modified Files:
sql/test/testdb-upgrade-hge/Tests/dump.stable.out.int128
sql/test/testdb-upgrade/Tests/dump.stable.out
Branch: Mar2018
Log Message:
Approve upgrade from new database.
(grafted from f1f9b243fe37ba2b14da822e8cc29e3722e263e9)
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
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic