Changeset: 897d0ba85ee1 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=897d0ba85ee1 Modified Files: sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 Branch: Jul2015 Log Message:
Upgrade approvals. diffs (56 lines): diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128 @@ -24,12 +24,6 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. -Running database upgrade commands: -set schema "sys"; -create function sys."epoch"(sec INT) returns TIMESTAMP external name timestamp."epoch"; -create function sys."epoch"(ts TIMESTAMP) returns INT external name timestamp."epoch"; -insert into sys.systemfunctions (select id from sys.functions where name = 'epoch' and schema_id = (select id from sys.schemas where name = 'sys') and id not in (select function_id from sys.systemfunctions)); -set schema "sys"; # 16:53:39 > diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out @@ -24,12 +24,6 @@ stdout of test 'upgrade` in directory 's # MonetDB/R module loaded Ready. -Running database upgrade commands: -set schema "sys"; -create function sys."epoch"(sec INT) returns TIMESTAMP external name timestamp."epoch"; -create function sys."epoch"(ts TIMESTAMP) returns INT external name timestamp."epoch"; -insert into sys.systemfunctions (select id from sys.functions where name = 'epoch' and schema_id = (select id from sys.schemas where name = 'sys') and id not in (select function_id from sys.systemfunctions)); -set schema "sys"; # 16:53:35 > diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128 @@ -64,18 +64,11 @@ from sys.storagemodel() group by "schema insert into sys.systemfunctions (select id from sys.functions where name in ('fuse', 'generate_series', 'stddev_samp', 'stddev_pop', 'var_samp', 'var_pop', 'median', 'quantile', 'corr') and schema_id = (select id from sys.schemas where name = 'sys') and id not in (select function_id from sys.systemfunctions)); insert into sys.systemfunctions (select id from sys.functions where name = 'filter' and schema_id = (select id from sys.schemas where name = 'json') and id not in (select function_id from sys.systemfunctions)); update sys._tables set system = true where name = 'tablestoragemodel' and schema_id = (select id from sys.schemas where name = 'sys'); -insert into sys.types values(7492, 'hge', 'hugeint', 128, 1, 2, 6, 0); -insert into sys.types values(7493, 'hge', 'decimal', 39, 1, 10, 8, 0); +insert into sys.types values(7500, 'hge', 'hugeint', 128, 1, 2, 6, 0); +insert into sys.types values(7501, 'hge', 'decimal', 39, 1, 10, 8, 0); update sys.types set digits = 18 where systemname = 'lng' and sqlname = 'decimal'; set schema "sys"; -Running database upgrade commands: -set schema "sys"; -create function sys."epoch"(sec INT) returns TIMESTAMP external name timestamp."epoch"; -create function sys."epoch"(ts TIMESTAMP) returns INT external name timestamp."epoch"; -insert into sys.systemfunctions (select id from sys.functions where name = 'epoch' and schema_id = (select id from sys.schemas where name = 'sys') and id not in (select function_id from sys.systemfunctions)); -set schema "sys"; - # 16:53:35 > # 16:53:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-30908" "--port=39660" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list