Changeset: 93711891a50f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/93711891a50f
Modified Files:
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
Branch: sqlfuncfix
Log Message:
Approve power8 upgrade.
diffs (truncated from 8249 to 300 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -3169,7 +3169,7 @@ insert into sys.functions values (839, '
insert into sys.args values (43714, 839, 'res_0', 'double', 53, 0, 0, 0);
insert into sys.functions values (840, 'rand', 'rand', 'mmath', 0, 1, true,
false, false, 2000, true, true);
insert into sys.args values (43715, 840, 'res_0', 'int', 32, 0, 0, 0);
-insert into sys.functions values (841, 'rand', 'sqlrand', 'mmath', 0, 1, true,
false, false, 2000, true, true);
+insert into sys.functions values (841, 'rand', 'sqlrand', 'mmath', 0, 1,
false, false, false, 2000, true, true);
insert into sys.args values (43716, 841, 'res_0', 'int', 32, 0, 0, 0);
insert into sys.args values (43717, 841, 'arg_1', 'int', 32, 0, 1, 1);
insert into sys.functions values (842, 'curdate', 'current_date', 'mtime', 0,
1, false, false, false, 2000, true, false);
@@ -3455,7 +3455,7 @@ insert into sys.args values (43910, 928,
insert into sys.functions values (929, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (43911, 929, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (43912, 929, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
+insert into sys.functions values (930, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
insert into sys.args values (43913, 930, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (43914, 930, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (43915, 930, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3676,7 +3676,7 @@ insert into sys.args values (44075, 984,
insert into sys.args values (44076, 984, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44077, 984, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44078, 984, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
+insert into sys.functions values (985, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
insert into sys.args values (44079, 985, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44080, 985, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (44081, 985, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3897,7 +3897,7 @@ insert into sys.args values (44241, 1039
insert into sys.args values (44242, 1039, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44243, 1039, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44244, 1039, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
+insert into sys.functions values (1040, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
insert into sys.args values (44245, 1040, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (44246, 1040, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (44247, 1040, 'arg_2', 'char', 0, 0, 1, 2);
@@ -4118,7 +4118,7 @@ insert into sys.args values (44407, 1094
insert into sys.args values (44408, 1094, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (44409, 1094, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (44410, 1094, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (1095, 'copyfrom', 'copy_from', 'sql', 0, 5,
false, true, false, 2000, true, true);
+insert into sys.functions values (1095, 'copyfrom', 'copy_from', 'sql', 0, 5,
true, true, false, 2000, true, true);
insert into sys.args values (44411, 1095, 'res_0', 'table', 0, 0, 0, 0);
insert into sys.args values (44412, 1095, 'arg_1', 'ptr', 0, 0, 1, 1);
insert into sys.args values (44413, 1095, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -4132,13 +4132,13 @@ insert into sys.args values (44420, 1095
insert into sys.args values (44421, 1095, 'arg_10', 'clob', 0, 0, 1, 10);
insert into sys.args values (44422, 1095, 'arg_11', 'int', 32, 0, 1, 11);
insert into sys.args values (44423, 1095, 'arg_12', 'int', 32, 0, 1, 12);
-insert into sys.functions values (1096, 'copyfrom', 'importTable', 'sql', 0,
5, false, true, false, 2000, true, true);
+insert into sys.functions values (1096, 'copyfrom', 'importTable', 'sql', 0,
5, true, true, false, 2000, true, true);
insert into sys.args values (44424, 1096, 'res_0', 'table', 0, 0, 0, 0);
insert into sys.args values (44425, 1096, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (44426, 1096, 'arg_2', 'clob', 0, 0, 1, 2);
insert into sys.args values (44427, 1096, 'arg_3', 'int', 32, 0, 1, 3);
-insert into sys.functions values (1097, 'sys_update_schemas',
'update_schemas', 'sql', 0, 2, false, false, false, 2000, true, true);
-insert into sys.functions values (1098, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
+insert into sys.functions values (1097, 'sys_update_schemas',
'update_schemas', 'sql', 0, 2, true, false, false, 2000, true, true);
+insert into sys.functions values (1098, 'sys_update_tables', 'update_tables',
'sql', 0, 2, true, false, false, 2000, true, true);
set schema "sys";
Running database upgrade commands:
@@ -5135,8 +5135,13 @@ external name mtime.epoch;
grant execute on function sys.epoch (DECIMAL(18,3)) to public;
update sys.functions set system = true where system <> true and name in
('epoch') and schema_id = 2000 and type = 1;
set schema "sys";
+drop function sys.malfunctions();
+create function sys.malfunctions()
+ returns table("module" string, "function" string, "signature" string,
"address" string, "comment" string)
+ external name "manual"."functions";
create view sys.malfunctions as select * from sys.malfunctions();
update sys._tables set system = true where system <> true and schema_id = 2000
and name = 'malfunctions';
+update sys.functions set system = true where system <> true and schema_id =
2000 and name = 'malfunctions';
drop view sys.dependencies_vw;
drop view sys.ids;
CREATE VIEW sys.ids (id, name, schema_id, table_id, table_name, obj_type,
sys_table, system) AS
@@ -5780,4 +5785,284 @@ JOIN sys.fkey_actions upd ON fks.update_
JOIN sys.fkey_actions del ON fks.delete_action_id = del.action_id;
GRANT SELECT ON sys.fkeys TO PUBLIC;
update sys._tables set system = true where name in ('fkey_actions', 'fkeys')
AND schema_id = 2000;
+drop view logging.compinfo;
+drop function logging.compinfo;
+drop procedure sys.storagemodelinit();
+drop view sys.schemastorage;
+drop view sys.tablestorage;
+drop view sys.storage;
+drop function sys.storage();
+drop function wlr.tick;
+drop function wlr.clock;
+drop function wlc.tick;
+drop function wlc.clock;
+drop function profiler.getlimit;
+drop view sys.rejects;
+drop function sys.rejects;
+drop function sys.user_statistics;
+drop view sys.queue;
+drop function sys.queue;
+drop function sys.debugflags;
+drop function sys.bbp;
+drop view sys.optimizers;
+drop function sys.optimizers;
+drop function sys.querycache;
+drop function sys.optimizer_stats;
+drop function sys.current_sessionid;
+drop view sys.prepared_statements_args;
+drop function sys.prepared_statements_args;
+drop view sys.prepared_statements;
+drop function sys.prepared_statements;
+drop view sys.sessions;
+drop function sys.sessions;
+drop view sys.querylog_history;
+drop view sys.querylog_calls;
+drop function sys.querylog_calls;
+drop view sys.querylog_catalog;
+drop function sys.querylog_catalog;
+create function sys.querylog_catalog()
+returns table(
+ id oid,
+ owner string,
+ defined timestamp,
+ query string,
+ pipe string,
+ "plan" string,
+ mal int,
+ optimize bigint
+)
+external name sql.querylog_catalog;
+create view sys.querylog_catalog as select * from sys.querylog_catalog();
+create function sys.querylog_calls()
+returns table(
+ id oid,
+ "start" timestamp,
+ "stop" timestamp,
+ arguments string,
+ tuples bigint,
+ run bigint,
+ ship bigint,
+ cpu int,
+ io int
+)
+external name sql.querylog_calls;
+create view sys.querylog_calls as select * from sys.querylog_calls();
+create view sys.querylog_history as
+select qd.*, ql."start",ql."stop", ql.arguments, ql.tuples, ql.run, ql.ship,
ql.cpu, ql.io
+from sys.querylog_catalog() qd, sys.querylog_calls() ql
+where qd.id = ql.id and qd.owner = user;
+create function sys.sessions()
+returns table(
+ "sessionid" int,
+ "username" string,
+ "login" timestamp,
+ "idle" timestamp,
+ "optimizer" string,
+ "sessiontimeout" int,
+ "querytimeout" int,
+ "workerlimit" int,
+ "memorylimit" int
+)
+external name sql.sessions;
+create view sys.sessions as select * from sys.sessions();
+create function sys.prepared_statements()
+returns table(
+ "sessionid" int,
+ "username" string,
+ "statementid" int,
+ "statement" string,
+ "created" timestamp
+)
+external name sql.prepared_statements;
+grant execute on function sys.prepared_statements to public;
+create view sys.prepared_statements as select * from sys.prepared_statements();
+grant select on sys.prepared_statements to public;
+create function sys.prepared_statements_args()
+returns table(
+ "statementid" int,
+ "type" string,
+ "type_digits" int,
+ "type_scale" int,
+ "inout" tinyint,
+ "number" int,
+ "schema" string,
+ "table" string,
+ "column" string
+)
+external name sql.prepared_statements_args;
+grant execute on function sys.prepared_statements_args to public;
+create view sys.prepared_statements_args as select * from
sys.prepared_statements_args();
+grant select on sys.prepared_statements_args to public;
+create function sys.current_sessionid() returns int
+external name clients.current_sessionid;
+grant execute on function sys.current_sessionid to public;
+create function sys.optimizer_stats()
+ returns table (optname string, count int, timing bigint)
+ external name inspect.optimizer_stats;
+create function sys.querycache()
+ returns table (query string, count int)
+ external name sql.dump_cache;
+create function sys.optimizers ()
+ returns table (name string, def string, status string)
+ external name sql.optimizers;
+create view sys.optimizers as select * from sys.optimizers();
+create function sys.bbp ()
+ returns table (id int, name string,
+ ttype string, count bigint, refcnt int, lrefcnt int,
+ location string, heat int, dirty string,
+ status string, kind string)
+ external name bbp.get;
+create function sys.debugflags()
+ returns table(flag string, val bool)
+ external name mdb."getDebugFlags";
+create function sys.queue()
+returns table(
+ "tag" bigint,
+ "sessionid" int,
+ "username" string,
+ "started" timestamp,
+ "status" string,
+ "query" string,
+ "finished" timestamp,
+ "maxworkers" int,
+ "footprint" int
+)
+external name sysmon.queue;
+grant execute on function sys.queue to public;
+create view sys.queue as select * from sys.queue();
+grant select on sys.queue to public;
+create function sys.user_statistics()
+returns table(
+ username string,
+ querycount bigint,
+ totalticks bigint,
+ started timestamp,
+ finished timestamp,
+ maxticks bigint,
+ maxquery string
+)
+external name sysmon.user_statistics;
+create function sys.rejects()
+returns table(
+ rowid bigint,
+ fldid int,
+ "message" string,
+ "input" string
+)
+external name sql.copy_rejects;
+grant execute on function rejects to public;
+create view sys.rejects as select * from sys.rejects();
+create function profiler.getlimit() returns integer external name
profiler.getlimit;
+create function wlc.clock() returns string
+external name wlc."getclock";
+create function wlc.tick() returns bigint
+external name wlc."gettick";
+create function wlr.clock() returns string
+external name wlr."getclock";
+create function wlr.tick() returns bigint
+external name wlr."gettick";
+create function sys."storage"()
+returns table (
+ "schema" varchar(1024),
+ "table" varchar(1024),
+ "column" varchar(1024),
+ "type" varchar(1024),
+ "mode" varchar(15),
+ location varchar(1024),
+ "count" bigint,
+ typewidth int,
+ columnsize bigint,
+ heapsize bigint,
+ hashes bigint,
+ phash boolean,
+ "imprints" bigint,
+ sorted boolean,
+ revsorted boolean,
+ "unique" boolean,
+ orderidx bigint
+)
+external name sql."storage";
+create view sys."storage" as
+select * from sys."storage"()
+ where ("schema", "table") in (
+ select sch."name", tbl."name"
+ from sys."tables" as tbl join sys."schemas" as sch on tbl.schema_id = sch.id
+ where tbl."system" = false)
+order by "schema", "table", "column";
+create view sys."tablestorage" as
+select "schema", "table",
+ max("count") as "rowcount",
+ count(*) as "storages",
+ sum(columnsize) as columnsize,
+ sum(heapsize) as heapsize,
+ sum(hashes) as hashsize,
+ sum("imprints") as imprintsize,
+ sum(orderidx) as orderidxsize
+ from sys."storage"
+group by "schema", "table"
+order by "schema", "table";
+create view sys."schemastorage" as
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
