MonetDB: Mar2018 - Approve power8 upgrade.
Changeset: 513d9b7a99f7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=513d9b7a99f7 Modified Files: sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 Branch: Mar2018 Log Message: Approve power8 upgrade. diffs (27 lines): diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 --- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 +++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64 @@ -42,6 +42,7 @@ GRANT SELECT ON sys.geometry_columns TO update sys._tables set system = true where name = 'geometry_columns' and schema_id in (select id from schemas where name = 'sys'); delete from sys.systemfunctions where function_id not in (select id from sys.functions); set schema "sys"; +commit; Running database upgrade commands: set schema "sys"; @@ -4997,6 +4998,7 @@ ALTER TABLE sys.keywords SET READ ONLY; ALTER TABLE sys.function_types SET READ ONLY; ALTER TABLE sys.function_languages SET READ ONLY; set schema "sys"; +commit; Running database upgrade commands: set schema sys; @@ -5008,6 +5010,7 @@ grant select on sys.netcdf_attrs to publ grant execute on procedure sys.netcdf_attach(varchar(256)) to public; grant execute on procedure sys.netcdf_importvar(integer, varchar(256)) to public; set schema "sys"; +commit; Running database upgrade commands: set schema sys; ___ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
MonetDB: Mar2018 - Approve power8 upgrade.
Changeset: 86802f389a00 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=86802f389a00
Added Files:
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
Branch: Mar2018
Log Message:
Approve power8 upgrade.
diffs (truncated from 5170 to 300 lines):
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
new file mode 100644
--- /dev/null
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
@@ -0,0 +1,5165 @@
+stdout of test 'upgrade` in directory 'sql/test/emptydb-upgrade-chain` itself:
+
+
+# 16:53:35 >
+# 16:53:35 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=39660" "--set"
"mapi_usock=/var/tmp/mtest-30908/.s.monetdb.39660" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/ufs/sjoerd/Monet-stable/var/MonetDB/mTests_sql_test_emptydb-upgrade-chain"
"--set" "mal_listing=0" "--set" "embedded_r=yes"
+# 16:53:35 >
+
+# MonetDB 5 server v11.21.16 (hg id: c20b591c1c70+)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_emptydb-upgrade-chain', using 8 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit
integers dynamically linked
+# Found 15.589 GiB available main-memory.
+# Copyright (c) 1993-July 2008 CWI.
+# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
+# Visit http://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:39660/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-30908/.s.monetdb.39660
+# MonetDB/GIS module loaded
+# Start processing logs sql/sql_logs version 52200
+# Start reading the write-ahead log 'sql_logs/sql/log.31'
+# Finished reading the write-ahead log 'sql_logs/sql/log.31'
+# Finished processing logs sql/sql_logs
+# MonetDB/SQL module loaded
+# MonetDB/R module loaded
+
+Ready.
+Running database upgrade commands:
+set schema "sys";
+drop view sys.geometry_columns cascade;
+create view sys.geometry_columns as
+ select cast(null as varchar(1)) as f_table_catalog,
+ s.name as f_table_schema,
+ t.name as f_table_name,
+ c.name as f_geometry_column,
+ cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer)
as coord_dimension,
+ c.type_scale as srid,
+ get_type(c.type_digits, 0) as type
+ from sys.columns c, sys.tables t, sys.schemas s
+ where c.table_id = t.id and t.schema_id = s.id
+ and c.type in (select sqlname from sys.types where systemname in
('wkb', 'wkba'));
+GRANT SELECT ON sys.geometry_columns TO PUBLIC;
+update sys._tables set system = true where name = 'geometry_columns' and
schema_id in (select id from schemas where name = 'sys');
+delete from sys.systemfunctions where function_id not in (select id from
sys.functions);
+set schema "sys";
+
+Running database upgrade commands:
+set schema "sys";
+delete from sys.dependencies where id < 2000;
+delete from sys.types where id < 2000;
+insert into sys.types values (0, 'void', 'any', 0, 0, 0, 0, 2000);
+insert into sys.types values (1, 'bat', 'table', 0, 0, 0, 1, 2000);
+insert into sys.types values (2, 'ptr', 'ptr', 0, 0, 0, 1, 2000);
+insert into sys.types values (3, 'bit', 'boolean', 1, 0, 2, 2, 2000);
+insert into sys.types values (4, 'str', 'char', 0, 0, 0, 3, 2000);
+insert into sys.types values (5, 'str', 'varchar', 0, 0, 0, 4, 2000);
+insert into sys.types values (6, 'str', 'clob', 0, 0, 0, 4, 2000);
+insert into sys.types values (7, 'oid', 'oid', 63, 0, 2, 6, 2000);
+insert into sys.types values (8, 'bte', 'tinyint', 8, 1, 2, 7, 2000);
+insert into sys.types values (9, 'sht', 'smallint', 16, 1, 2, 7, 2000);
+insert into sys.types values (10, 'int', 'int', 32, 1, 2, 7, 2000);
+insert into sys.types values (11, 'lng', 'bigint', 64, 1, 2, 7, 2000);
+insert into sys.types values (12, 'bte', 'decimal', 2, 1, 10, 10, 2000);
+insert into sys.types values (13, 'sht', 'decimal', 4, 1, 10, 10, 2000);
+insert into sys.types values (14, 'int', 'decimal', 9, 1, 10, 10, 2000);
+insert into sys.types values (15, 'lng', 'decimal', 18, 1, 10, 10, 2000);
+insert into sys.types values (16, 'flt', 'real', 24, 2, 2, 11, 2000);
+insert into sys.types values (17, 'dbl', 'double', 53, 2, 2, 11, 2000);
+insert into sys.types values (18, 'int', 'month_interval', 32, 0, 2, 8, 2000);
+insert into sys.types values (19, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
+insert into sys.types values (20, 'daytime', 'time', 7, 0, 0, 12, 2000);
+insert into sys.types values (21, 'daytime', 'timetz', 7, 1, 0, 12, 2000);
+insert into sys.types values (22, 'date', 'date', 0, 0, 0, 13, 2000);
+insert into sys.types values (23, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000);
+insert into sys.types values (24, 'timestamp', 'timestamptz', 7, 1, 0, 14,
MonetDB: Mar2018 - Approve power8 upgrade.
Changeset: 78b6ec831477 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=78b6ec831477
Added Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
Modified Files:
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
Branch: Mar2018
Log Message:
Approve power8 upgrade.
diffs (truncated from 16169 to 300 lines):
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
new file mode 100644
--- /dev/null
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
@@ -0,0 +1,5847 @@
+stdout of test 'upgrade` in directory 'sql/test/emptydb-upgrade-chain-hge`
itself:
+
+
+# 15:46:25 >
+# 15:46:25 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=8" "--set"
"mapi_open=true" "--set" "mapi_port=36716" "--set"
"mapi_usock=/var/tmp/mtest-7779/.s.monetdb.36716" "--set" "monet_prompt="
"--forcemito"
"--dbpath=/home/sjoerd/@Monet-candidate/var/MonetDB/mTests_sql_test_emptydb-upgrade-chain-hge"
+# 15:46:25 >
+
+# MonetDB 5 server v11.29.0 (hg id: 839372b4b4bb)
+# This is an unreleased version
+# Serving database 'mTests_sql_test_emptydb-upgrade-chain-hge', using 8 threads
+# Compiled for powerpc64-unknown-linux-gnu/64bit with 128bit integers
+# Found 255.360 GiB available main-memory.
+# Copyright (c) 1993 - July 2008 CWI.
+# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved
+# Visit https://www.monetdb.org/ for further information
+# Listening for connection requests on mapi:monetdb://power8:36716/
+# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-7779/.s.monetdb.36716
+# MonetDB/GIS module loaded
+# MonetDB/SQL module loaded
+
+Ready.
+Running database upgrade commands:
+set schema "sys";
+drop view sys.geometry_columns cascade;
+create view sys.geometry_columns as
+ select cast(null as varchar(1)) as f_table_catalog,
+ s.name as f_table_schema,
+ t.name as f_table_name,
+ c.name as f_geometry_column,
+ cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer)
as coord_dimension,
+ c.type_scale as srid,
+ get_type(c.type_digits, 0) as type
+ from sys.columns c, sys.tables t, sys.schemas s
+ where c.table_id = t.id and t.schema_id = s.id
+ and c.type in (select sqlname from sys.types where systemname in
('wkb', 'wkba'));
+GRANT SELECT ON sys.geometry_columns TO PUBLIC;
+update sys._tables set system = true where name = 'geometry_columns' and
schema_id in (select id from schemas where name = 'sys');
+delete from sys.systemfunctions where function_id not in (select id from
sys.functions);
+set schema "sys";
+
+Running database upgrade commands:
+set schema "sys";
+delete from sys.dependencies where id < 2000;
+delete from sys.types where id < 2000;
+insert into sys.types values (0, 'void', 'any', 0, 0, 0, 0, 2000);
+insert into sys.types values (1, 'bat', 'table', 0, 0, 0, 1, 2000);
+insert into sys.types values (2, 'ptr', 'ptr', 0, 0, 0, 1, 2000);
+insert into sys.types values (3, 'bit', 'boolean', 1, 0, 2, 2, 2000);
+insert into sys.types values (4, 'str', 'char', 0, 0, 0, 3, 2000);
+insert into sys.types values (5, 'str', 'varchar', 0, 0, 0, 4, 2000);
+insert into sys.types values (6, 'str', 'clob', 0, 0, 0, 4, 2000);
+insert into sys.types values (7, 'oid', 'oid', 63, 0, 2, 6, 2000);
+insert into sys.types values (8, 'bte', 'tinyint', 8, 1, 2, 7, 2000);
+insert into sys.types values (9, 'sht', 'smallint', 16, 1, 2, 7, 2000);
+insert into sys.types values (10, 'int', 'int', 32, 1, 2, 7, 2000);
+insert into sys.types values (11, 'lng', 'bigint', 64, 1, 2, 7, 2000);
+insert into sys.types values (12, 'hge', 'hugeint', 128, 1, 2, 7, 2000);
+insert into sys.types values (13, 'bte', 'decimal', 2, 1, 10, 10, 2000);
+insert into sys.types values (14, 'sht', 'decimal', 4, 1, 10, 10, 2000);
+insert into sys.types values (15, 'int', 'decimal', 9, 1, 10, 10, 2000);
+insert into sys.types values (16, 'lng', 'decimal', 18, 1, 10, 10, 2000);
+insert into sys.types values (17, 'hge', 'decimal', 38, 1, 10, 10, 2000);
+insert into sys.types values (18, 'flt', 'real', 24, 2, 2, 11, 2000);
+insert into sys.types values (19, 'dbl', 'double', 53, 2, 2, 11, 2000);
+insert into sys.types values (20, 'int', 'month_interval', 32, 0, 2, 8, 2000);
+insert into sys.types values (21, 'lng', 'sec_interval', 13, 1, 10, 9, 2000);
+insert into sys.types values (22, 'daytime', 'time', 7, 0, 0, 12, 2000);
+insert into sys.types values (23, 'daytime', 'timetz', 7, 1, 0, 12, 2000);
+insert into sys.types values (24, 'date', 'date', 0, 0, 0, 13, 2000);
+insert into sys.types values (25, 'timestamp', 'timestamp', 7, 0, 0, 14, 2000);
+insert into sys.types values (26, 'timestamp', 'timestamptz', 7, 1, 0, 14,
2000);
+insert into sys.types values (27, 'sqlblob', 'blob', 0, 0, 0, 5, 2000);
