Changeset: c614f0b1a402 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c614f0b1a402
Modified Files:
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit
Branch: default
Log Message:
Approvals.
diffs (truncated from 337 to 300 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -2860,7 +2860,7 @@ insert into sys.args values (38634, 777,
insert into sys.functions values (778, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (38635, 778, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (38636, 778, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (38637, 779, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38638, 779, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (38639, 779, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3081,7 +3081,7 @@ insert into sys.args values (38799, 833,
insert into sys.args values (38800, 833, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38801, 833, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38802, 833, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (38803, 834, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38804, 834, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (38805, 834, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3302,7 +3302,7 @@ insert into sys.args values (38965, 888,
insert into sys.args values (38966, 888, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (38967, 888, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (38968, 888, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (38969, 889, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (38970, 889, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (38971, 889, 'arg_2', 'char', 0, 0, 1, 2);
@@ -5470,4 +5470,5 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'profiler') and name = 'getlimit';
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlc') and name in ('clock', 'tick');
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlr') and name in ('clock', 'tick');
+drop view sys.systemfunctions;
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit
@@ -2860,7 +2860,7 @@ insert into sys.args values (9681, 777,
insert into sys.functions values (778, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (9682, 778, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (9683, 778, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (9684, 779, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (9685, 779, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (9686, 779, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3081,7 +3081,7 @@ insert into sys.args values (9846, 833,
insert into sys.args values (9847, 833, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (9848, 833, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (9849, 833, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (9850, 834, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (9851, 834, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (9852, 834, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3302,7 +3302,7 @@ insert into sys.args values (10012, 888,
insert into sys.args values (10013, 888, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (10014, 888, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (10015, 888, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (10016, 889, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (10017, 889, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (10018, 889, 'arg_2', 'char', 0, 0, 1, 2);
@@ -5470,4 +5470,5 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'profiler') and name = 'getlimit';
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlc') and name in ('clock', 'tick');
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlr') and name in ('clock', 'tick');
+drop view sys.systemfunctions;
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -2862,7 +2862,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "json", "tojsonarray", "SYSTEM", "create
aggregate json.tojsonarray(x double) returns string external name
aggr.jsonaggr;", "aggr", "MAL", "Aggregate function", false, false,
false, true, "result", "clob", 0, 0, "out", "x",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "json", "tojsonarray", "SYSTEM", "create
aggregate json.tojsonarray(x string) returns string external name
aggr.jsonaggr;", "aggr", "MAL", "Aggregate function", false, false,
false, true, "result", "clob", 0, 0, "out", "x", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "json", "valuearray", "SYSTEM", "create
function json.valuearray(js json) returns json external name json.valuearray;",
"json", "MAL", "Scalar function", false, false, false, true,
"result", "json", 0, 0, "out", "js", "json", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys.functions", "logging", "compinfo", "SYSTEM", "create
function logging.compinfo() returns table(\"id\" int, \"component\" string,
\"log_level\" string) external name logging.compinfo;", "logging",
"MAL", "Function returning a table", true, false, false, true, "id",
"int", 32, 0, "out", "component", "clob", 0, 0, "out",
"log_level", "clob", 0, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "logging", "compinfo", "SYSTEM", "create
function logging.compinfo() returns table(\"id\" int, \"component\" string,
\"log_level\" string) external name logging.compinfo;", "logging",
"MAL", "Function returning a table", false, false, false, true, "id",
"int", 32, 0, "out", "component", "clob", 0, 0, "out",
"log_level", "clob", 0, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "logging", "flush", "SYSTEM", "create
procedure logging.flush() external name logging.flush;", "logging",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "logging", "resetadapter", "SYSTEM", "create
procedure logging.resetadapter() external name logging.resetadapter;",
"logging", "MAL", "Procedure", true, false, false, true, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "logging", "resetcomplevel", "SYSTEM",
"create procedure logging.resetcomplevel(comp_id string) external name
logging.resetcomplevel;", "logging", "MAL", "Procedure", true,
false, false, true, "comp_id", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
@@ -2872,7 +2872,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "logging", "setcomplevel", "SYSTEM", "create
procedure logging.setcomplevel(comp_id string, lvl_id string) external name
logging.setcomplevel;", "logging", "MAL", "Procedure", true,
false, false, true, "comp_id", "clob", 0, 0, "in",
"lvl_id", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "logging", "setflushlevel", "SYSTEM",
"create procedure logging.setflushlevel(lvl_id string) external name
logging.setflushlevel;", "logging", "MAL", "Procedure", true,
false, false, true, "lvl_id", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "logging", "setlayerlevel", "SYSTEM",
"create procedure logging.setlayerlevel(layer_id string, lvl_id string)
external name logging.setlayerlevel;", "logging", "MAL", "Procedure",
true, false, false, true, "layer_id", "clob", 0, 0, "in",
"lvl_id", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "profiler", "getlimit", "SYSTEM", "create
function profiler.getlimit() returns integer external name profiler.getlimit;",
"profiler", "MAL", "Scalar function", true, false, false, true,
"result", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "profiler", "getlimit", "SYSTEM", "create
function profiler.getlimit() returns integer external name profiler.getlimit;",
"profiler", "MAL", "Scalar function", false, false, false, true,
"result", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "profiler", "setheartbeat", "SYSTEM", "create
procedure profiler.setheartbeat(beat int) external name
profiler.setheartbeat;", "profiler", "MAL", "Procedure", true,
false, false, true, "beat", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "profiler", "setlimit", "SYSTEM", "create
procedure profiler.setlimit(lim integer) external name profiler.setlimit;",
"profiler", "MAL", "Procedure", true, false, false, true, "lim",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "profiler", "start", "SYSTEM", "create
procedure profiler.start() external name profiler.\"start\";", "profiler",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -2945,7 +2945,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "double", 53, 0, "out", "arg_1",
"tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "month_interval", 3, 0, "out", "arg_1",
"month_interval", 3, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "sec_interval", 13, 0, "out", "arg_1",
"sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "bbp", "SYSTEM", "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;", "bbp", "MAL", "Function
returning a table", true, false, false, true, "id", "int", 32,
0, "out", "name", "clob", 0, 0, "out", "ttype", "clob",
0, 0, "out", "count", "bigint", 64, 0, "out",
"refcnt", "int", 32, 0, "out", "lrefcnt", "int", 32,
0, "out", "location", "clob", 0, 0, "out", "heat", "int",
32, 0, "out", "dirty", "clob", 0, 0, "out",
"status", "clob", 0, 0, "out", "kind", "clob", 0, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "bbp", "SYSTEM", "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;", "bbp", "MAL", "Function
returning a table", false, false, false, true, "id", "int", 32,
0, "out", "name", "clob", 0, 0, "out", "ttype", "clob",
0, 0, "out", "count", "bigint", 64, 0, "out",
"refcnt", "int", 32, 0, "out", "lrefcnt", "int", 32,
0, "out", "location", "clob", 0, 0, "out", "heat", "int",
32, 0, "out", "dirty", "clob", 0, 0, "out",
"status", "clob", 0, 0, "out", "kind", "clob", 0, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "between", "SYSTEM", "between",
"calc", "Internal C", "Scalar function", false, false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1", "any",
0, 0, "in", "arg_2", "any", 0, 0, "in",
"arg_3", "any", 0, 0, "in", "arg_4", "boolean",
1, 0, "in", "arg_5", "boolean", 1, 0, "in",
"arg_6", "boolean", 1, 0, "in", "arg_7",
"boolean", 1, 0, "in", "arg_8", "boolean", 1,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "bit_and", "SYSTEM", "and", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "bigint", 64, 0, "out", "arg_1",
"bigint", 64, 0, "in", "arg_2", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "bit_and", "SYSTEM", "and", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "decimal", 2, 0, "out", "arg_1",
"decimal", 2, 0, "in", "arg_2", "decimal", 2,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -3014,8 +3014,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "concat", "SYSTEM", "+", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "concat", "SYSTEM", "+", "calc",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "contains", "SYSTEM", "create
function contains(a geometry, x double, y double) returns boolean external name
geom.\"Contains\";", "geom", "MAL", "Scalar function", false, false,
false, true, "result", "boolean", 1, 0, "out", "a",
"geometry", 0, 0, "in", "x", "double", 53, 0,
"in", "y", "double", 53, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "copyfrom", "SYSTEM", "copy_from",
"sql", "Internal C", "Function returning a table", false, true, false,
true, "res_0", "table", 0, 0, "out", "arg_1",
"ptr", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "clob", 0, 0, "in", "arg_4", "clob", 0,
0, "in", "arg_5", "clob", 0, 0, "in", "arg_6",
"clob", 0, 0, "in", "arg_7", "bigint", 64, 0,
"in", "arg_8", "bigint", 64, 0, "in", "arg_9",
"int", 32, 0, "in", "arg_10", "clob", 0, 0, "in",
"arg_11", "int", 32, 0, "in", "arg_12", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "copyfrom", "SYSTEM", "importTable",
"sql", "Internal C", "Function returning a table", false, true, false,
true, "res_0", "table", 0, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "int", 32, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "copyfrom", "SYSTEM", "copy_from",
"sql", "Internal C", "Function returning a table", true, true, false,
true, "res_0", "table", 0, 0, "out", "arg_1",
"ptr", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "clob", 0, 0, "in", "arg_4", "clob", 0,
0, "in", "arg_5", "clob", 0, 0, "in", "arg_6",
"clob", 0, 0, "in", "arg_7", "bigint", 64, 0,
"in", "arg_8", "bigint", 64, 0, "in", "arg_9",
"int", 32, 0, "in", "arg_10", "clob", 0, 0, "in",
"arg_11", "int", 32, 0, "in", "arg_12", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "copyfrom", "SYSTEM", "importTable",
"sql", "Internal C", "Function returning a table", true, true, false,
true, "res_0", "table", 0, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "int", 32, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 bigint, e2 bigint) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "bigint",
64, 0, "in", "e2", "bigint", 64, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 double, e2 double) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "double",
53, 0, "in", "e2", "double", 53, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 integer, e2 integer) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
"result", "double", 53, 0, "out", "e1", "int", 32,
0, "in", "e2", "int", 32, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
@@ -3065,7 +3065,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "cume_dist", "SYSTEM", "cume_dist",
"sql", "Internal C", "Analytic function", false, false, false, true,
"res_0", "double", 53, 0, "out", "arg_1", "any",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "curdate", "SYSTEM", "current_date",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "current_date", "SYSTEM", "current_date",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "current_sessionid", "SYSTEM", "create
function sys.current_sessionid() returns int external name
clients.current_sessionid;", "clients", "MAL", "Scalar function",
true, false, false, true, "result", "int", 32, 0, "out",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "current_sessionid", "SYSTEM", "create
function sys.current_sessionid() returns int external name
clients.current_sessionid;", "clients", "MAL", "Scalar function",
false, false, false, true, "result", "int", 32, 0, "out",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "current_time", "SYSTEM", "current_time",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "timetz", 7, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "current_timestamp", "SYSTEM",
"current_timestamp", "mtime", "Internal C", "Scalar function",
false, false, false, false, "res_0", "timestamptz", 7, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "curtime", "SYSTEM", "current_time",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "timetz", 7, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -3083,7 +3083,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "db_users", "SYSTEM", "CREATE
FUNCTION db_users () RETURNS TABLE(name varchar(2048)) EXTERNAL NAME
sql.db_users;", "sql", "MAL", "Function returning a table", false,
false, false, true, "name", "varchar", 2048, 0, "out", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "debug", "SYSTEM", "create
function sys.debug(debug int) returns integer external name mdb.\"setDebug\";",
"mdb", "MAL", "Scalar function", false, false, false, true,
"result", "int", 32, 0, "out", "debug", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "debug", "SYSTEM", "create
function sys.debug(flag string) returns integer external name
mdb.\"setDebug\";", "mdb", "MAL", "Scalar function", false,
false, false, true, "result", "int", 32, 0, "out", "flag",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "debugflags", "SYSTEM", "create
function sys.debugflags() returns table(flag string, val bool) external name
mdb.\"getDebugFlags\";", "mdb", "MAL", "Function returning a table",
true, false, false, true, "flag", "clob", 0, 0, "out", "val",
"boolean", 1, 0, "out", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "debugflags", "SYSTEM", "create
function sys.debugflags() returns table(flag string, val bool) external name
mdb.\"getDebugFlags\";", "mdb", "MAL", "Function returning a table",
false, false, false, true, "flag", "clob", 0, 0, "out", "val",
"boolean", 1, 0, "out", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "decade", "SYSTEM", "decade",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "date",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "decade", "SYSTEM", "decade",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1",
"timestamp", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "decade", "SYSTEM", "decade",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -3312,7 +3312,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "ltrim", "SYSTEM", "ltrim2",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "char", 0, 0, "out", "arg_1", "char", 0,
0, "in", "arg_2", "char", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "ltrim", "SYSTEM", "ltrim2",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "ltrim", "SYSTEM", "ltrim2",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "malfunctions", "SYSTEM", "create
function sys.malfunctions() returns table(\"module\" string, \"function\"
string, \"signature\" string, \"address\" string, \"comment\" string) external
name \"manual\".\"functions\";", "manual", "MAL", "Function
returning a table", true, false, false, true, "module", "clob",
0, 0, "out", "function", "clob", 0, 0, "out",
"signature", "clob", 0, 0, "out", "address", "clob", 0,
0, "out", "comment", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys.functions", "sys", "malfunctions", "SYSTEM", "create
function sys.malfunctions() returns table(\"module\" string, \"function\"
string, \"signature\" string, \"address\" string, \"comment\" string) external
name \"manual\".\"functions\";", "manual", "MAL", "Function
returning a table", false, false, false, true, "module", "clob",
0, 0, "out", "function", "clob", 0, 0, "out",
"signature", "clob", 0, 0, "out", "address", "clob", 0,
0, "out", "comment", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "masklen", "SYSTEM", "create
function \"masklen\" (p inet) returns int external name inet.\"masklen\";",
"inet", "MAL", "Scalar function", false, false, false, true,
"result", "int", 32, 0, "out", "p", "inet", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "max", "SYSTEM", "max", "aggr",
"Internal C", "Aggregate function", false, false, false, false,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "max", "SYSTEM", "max", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
@@ -3416,8 +3416,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "octet_length", "SYSTEM", "nbytes",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "octet_length", "SYSTEM", "nbytes",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "varchar",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "octet_length", "SYSTEM", "nitems",
"blob", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "blob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "optimizer_stats", "SYSTEM", "create
function sys.optimizer_stats() returns table (optname string, count int, timing
bigint) external name inspect.optimizer_stats;", "inspect", "MAL",
"Function returning a table", true, false, false, true, "optname",
"clob", 0, 0, "out", "count", "int", 32, 0, "out",
"timing", "bigint", 64, 0, "out", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "optimizers", "SYSTEM", "create
function sys.optimizers () returns table (name string, def string, status
string) external name sql.optimizers;", "sql", "MAL", "Function
returning a table", true, false, false, true, "name", "clob", 0,
0, "out", "def", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "optimizer_stats", "SYSTEM", "create
function sys.optimizer_stats() returns table (optname string, count int, timing
bigint) external name inspect.optimizer_stats;", "inspect", "MAL",
"Function returning a table", false, false, false, true, "optname",
"clob", 0, 0, "out", "count", "int", 32, 0, "out",
"timing", "bigint", 64, 0, "out", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "optimizers", "SYSTEM", "create
function sys.optimizers () returns table (name string, def string, status
string) external name sql.optimizers;", "sql", "MAL", "Function
returning a table", false, false, false, true, "name", "clob", 0,
0, "out", "def", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "or", "SYSTEM", "or", "calc",
"Internal C", "Scalar function", false, false, false, true,
"res_0", "boolean", 1, 0, "out", "arg_1",
"boolean", 1, 0, "in", "arg_2", "boolean", 1,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "password_hash", "SYSTEM", "create
function sys.password_hash (username string) returns string external name
sql.password;", "sql", "MAL", "Scalar function", false, false,
false, true, "result", "clob", 0, 0, "out", "username",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "patindex", "SYSTEM", "patindex",
"pcre", "Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "char", 0,
0, "in", "arg_2", "char", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -3430,8 +3430,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "power", "SYSTEM", "pow",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", "arg_2", "double", 53,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "power", "SYSTEM", "pow",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "real", 24, 0, "out", "arg_1", "real",
24, 0, "in", "arg_2", "real", 24, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "prepare_esc", "SYSTEM", "create
function sys.prepare_esc(s string, t string) returns string begin return case
when (t = 'varchar' or t ='char' or t = 'clob' or t = 'json' or t = 'geometry'
or t = 'url') then 'CASE WHEN ' || sys.dq(s) || ' IS NULL THEN \\'null\\' ELSE
' || 'sys.esc(' || sys.dq(s) || ')' || ' END' else 'CASE WHEN ' || sys.dq(s) ||
' IS NULL THEN \\'null\\' ELSE CAST(' || sys.dq(s) || ' AS STRING) END' end;
end;", "sql", "SQL", "Scalar function", false, false, false, true,
"result", "clob", 0, 0, "out", "s", "clob", 0, 0,
"in", "t", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys.functions", "sys", "prepared_statements", "SYSTEM", "create
function sys.prepared_statements() returns table(\"sessionid\" int,
\"username\" string, \"statementid\" int, \"statement\" string, \"created\"
timestamp) external name sql.prepared_statements;", "sql", "MAL",
"Function returning a table", true, false, false, true, "sessionid",
"int", 32, 0, "out", "username", "clob", 0, 0, "out",
"statementid", "int", 32, 0, "out", "statement", "clob", 0,
0, "out", "created", "timestamp", 7, 0, "out", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "prepared_statements_args", "SYSTEM",
"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;", "sql", "MAL",
"Function returning a table", true, false, false, true, "statementid",
"int", 32, 0, "out", "type", "clob", 0, 0, "out",
"type_digits", "int", 32, 0, "out", "type_scale", "int", 32,
0, "out", "inout", "tinyint", 8, 0, "out",
"number", "int", 32, 0, "out", "schema", "clob", 0,
0, "out", "table", "clob", 0, 0, "out", "column",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "prepared_statements", "SYSTEM", "create
function sys.prepared_statements() returns table(\"sessionid\" int,
\"username\" string, \"statementid\" int, \"statement\" string, \"created\"
timestamp) external name sql.prepared_statements;", "sql", "MAL",
"Function returning a table", false, false, false, true, "sessionid",
"int", 32, 0, "out", "username", "clob", 0, 0, "out",
"statementid", "int", 32, 0, "out", "statement", "clob", 0,
0, "out", "created", "timestamp", 7, 0, "out", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "prepared_statements_args", "SYSTEM",
"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;", "sql", "MAL",
"Function returning a table", false, false, false, true, "statementid",
"int", 32, 0, "out", "type", "clob", 0, 0, "out",
"type_digits", "int", 32, 0, "out", "type_scale", "int", 32,
0, "out", "inout", "tinyint", 8, 0, "out",
"number", "int", 32, 0, "out", "schema", "clob", 0,
0, "out", "table", "clob", 0, 0, "out", "column",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, false,
"res_0", "bigint", 64, 0, "out", "arg_1",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, false,
"res_0", "bigint", 64, 0, "out", "arg_1", "int",
32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, false,
"res_0", "bigint", 64, 0, "out", "arg_1",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -3470,21 +3470,21 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "quarter", "SYSTEM", "quarter",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "date",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "quarter", "SYSTEM", "quarter",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1",
"timestamp", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "quarter", "SYSTEM", "quarter",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "querycache", "SYSTEM", "create
function sys.querycache() returns table (query string, count int) external name
sql.dump_cache;", "sql", "MAL", "Function returning a table", true,
false, false, true, "query", "clob", 0, 0, "out",
"count", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "querycache", "SYSTEM", "create
function sys.querycache() returns table (query string, count int) external name
sql.dump_cache;", "sql", "MAL", "Function returning a table", false,
false, false, true, "query", "clob", 0, 0, "out",
"count", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "querylog", "SYSTEM", "create
procedure sys.querylog(filename string) external name sql.logfile;", "sql",
"MAL", "Procedure", true, false, false, true, "filename", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "querylog_calls", "SYSTEM", "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;", "sql", "MAL",
"Function returning a table", true, false, false, true, "id", "oid",
31, 0, "out", "start", "timestamp", 7, 0, "out",
"stop", "timestamp", 7, 0, "out", "arguments", "clob", 0,
0, "out", "tuples", "bigint", 64, 0, "out", "run",
"bigint", 64, 0, "out", "ship", "bigint", 64, 0,
"out", "cpu", "int", 32, 0, "out", "io", "int", 32, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "querylog_catalog", "SYSTEM", "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;", "sql", "MAL", "Function
returning a table", true, false, false, true, "id", "oid", 31,
0, "out", "owner", "clob", 0, 0, "out", "defined",
"timestamp", 7, 0, "out", "query", "clob", 0, 0,
"out", "pipe", "clob", 0, 0, "out", "plan", "clob", 0, 0,
"out", "mal", "int", 32, 0, "out", "optimize", "bigint",
64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys.functions", "sys", "querylog_calls", "SYSTEM", "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;", "sql", "MAL",
"Function returning a table", false, false, false, true, "id", "oid",
31, 0, "out", "start", "timestamp", 7, 0, "out",
"stop", "timestamp", 7, 0, "out", "arguments", "clob", 0,
0, "out", "tuples", "bigint", 64, 0, "out", "run",
"bigint", 64, 0, "out", "ship", "bigint", 64, 0,
"out", "cpu", "int", 32, 0, "out", "io", "int", 32, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "querylog_catalog", "SYSTEM", "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;", "sql", "MAL", "Function
returning a table", false, false, false, true, "id", "oid", 31,
0, "out", "owner", "clob", 0, 0, "out", "defined",
"timestamp", 7, 0, "out", "query", "clob", 0, 0,
"out", "pipe", "clob", 0, 0, "out", "plan", "clob", 0, 0,
"out", "mal", "int", 32, 0, "out", "optimize", "bigint",
64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "querylog_disable", "SYSTEM", "create
procedure sys.querylog_disable() external name sql.querylog_disable;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "querylog_empty", "SYSTEM", "create
procedure sys.querylog_empty() external name sql.querylog_empty;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable() external name sql.querylog_enable;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;", "sql", "MAL", "Procedure", true, false, false,
true, "threshold", "int", 32, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "queue", "SYSTEM", "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;", "sysmon", "MAL", "Function returning a table",
true, false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"maxworkers", "int", 32, 0, "out", "footprint", "int", 32,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "queue", "SYSTEM", "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;", "sysmon", "MAL", "Function returning a table",
false, false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"maxworkers", "int", 32, 0, "out", "footprint", "int", 32,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "real", 24, 0, "out", "arg_1", "real",
24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "rand", "SYSTEM", "rand", "mmath",
"Internal C", "Scalar function", true, false, false, true,
"res_0", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys.functions", "sys", "rand", "SYSTEM", "sqlrand",
"mmath", "Internal C", "Scalar function", true, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "int",
32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys.functions", "sys", "rand", "SYSTEM", "sqlrand",
"mmath", "Internal C", "Scalar function", false, false, false,
true, "res_0", "int", 32, 0, "out", "arg_1", "int",
32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "rank", "SYSTEM", "rank", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "int", 32, 0, "out", "arg_1", "any", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "rejects", "SYSTEM", "create
function sys.rejects() returns table(rowid bigint, fldid int, \"message\"
string, \"input\" string) external name sql.copy_rejects;", "sql", "MAL",
"Function returning a table", true, false, false, true, "rowid",
"bigint", 64, 0, "out", "fldid", "int", 32, 0,
"out", "message", "clob", 0, 0, "out", "input", "clob",
0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys.functions", "sys", "rejects", "SYSTEM", "create
function sys.rejects() returns table(rowid bigint, fldid int, \"message\"
string, \"input\" string) external name sql.copy_rejects;", "sql", "MAL",
"Function returning a table", false, false, false, true, "rowid",
"bigint", 64, 0, "out", "fldid", "int", 32, 0,
"out", "message", "clob", 0, 0, "out", "input", "clob",
0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "remote_table_credentials", "SYSTEM",
"create function sys.remote_table_credentials (tablename string) returns table
(\"uri\" string, \"username\" string, \"hash\" string) external name
sql.rt_credentials;", "sql", "MAL", "Function returning a table",
false, false, false, true, "uri", "clob", 0, 0, "out",
"username", "clob", 0, 0, "out", "hash", "clob", 0, 0,
"out", "tablename", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "repeat", "SYSTEM", "repeat",
"str", "Internal C", "Scalar function", false, false, false, true,
"res_0", "char", 0, 0, "out", "arg_1", "char", 0,
0, "in", "arg_2", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "repeat", "SYSTEM", "repeat",
"str", "Internal C", "Scalar function", false, false, false, true,
"res_0", "clob", 0, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -3656,7 +3656,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "decimal", 9, 6, "out", "arg_1",
"timestamp", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "decimal", 9, 6, "out", "arg_1",
"timestamptz", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "decimal", 9, 6, "out", "arg_1",
"timetz", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "sessions", "SYSTEM", "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;", "sql", "MAL",
"Function returning a table", true, false, false, true, "sessionid",
"int", 32, 0, "out", "username", "clob", 0, 0, "out",
"login", "timestamp", 7, 0, "out", "idle", "timestamp",
7, 0, "out", "optimizer", "clob", 0, 0, "out",
"sessiontimeout", "int", 32, 0, "out", "querytimeout", "int",
32, 0, "out", "workerlimit", "int", 32, 0, "out",
"memorylimit", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "sys", "sessions", "SYSTEM", "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;", "sql", "MAL",
"Function returning a table", false, false, false, true, "sessionid",
"int", 32, 0, "out", "username", "clob", 0, 0, "out",
"login", "timestamp", 7, 0, "out", "idle", "timestamp",
7, 0, "out", "optimizer", "clob", 0, 0, "out",
"sessiontimeout", "int", 32, 0, "out", "querytimeout", "int",
32, 0, "out", "workerlimit", "int", 32, 0, "out",
"memorylimit", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "setmasklen", "SYSTEM", "create
function \"setmasklen\" (p inet, mask int) returns inet external name
inet.\"setmasklen\";", "inet", "MAL", "Scalar function", false,
false, false, true, "result", "inet", 0, 0, "out", "p",
"inet", 0, 0, "in", "mask", "int", 32, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "setmemorylimit", "SYSTEM", "create
procedure sys.setmemorylimit(\"limit\" int) external name
clients.setmemorylimit;", "clients", "MAL", "Procedure", true,
false, false, true, "limit", "int", 32, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "setmemorylimit", "SYSTEM", "create
procedure sys.setmemorylimit(\"sessionid\" int, \"limit\" int) external name
clients.setmemorylimit;", "clients", "MAL", "Procedure", true,
false, false, true, "sessionid", "int", 32, 0, "in",
"limit", "int", 32, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -4070,7 +4070,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, "tag", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, "sname", "clob", 0, 0, "in", "tname",
"clob", 0, 0, "in", "cname", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, "sessionid", "int", 32, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "storage", "SYSTEM", "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\";", "sql", "MAL", "Function returning a
table", true, false, false, true, "schema", "varchar", 1024,
0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "mode", "varchar", 15, 0, "out",
"location", "varchar", 1024, 0, "out", "count",
"bigint", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 64, 0, "out
", "sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
+[ "sys.functions", "sys", "storage", "SYSTEM", "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\";", "sql", "MAL", "Function returning a
table", false, false, false, true, "schema", "varchar", 1024,
0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "mode", "varchar", 15, 0, "out",
"location", "varchar", 1024, 0, "out", "count",
"bigint", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 64, 0, "ou
t", "sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"(sname varchar(1024)) 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\";", "sql",
"MAL", "Function returning a table", false, false, false, true,
"schema", "varchar", 1024, 0, "out", "table",
"varchar", 1024, 0, "out", "column", "varchar", 1024,
0, "out", "type", "varchar", 1024, 0, "out", "mode",
"varchar", 15, 0, "out", "location", "varchar", 1024,
0, "out", "count", "bigint", 64, 0, "out",
"typewidth", "int", 32, 0, "out", "columnsize", "bigint",
64, 0, "out", "heapsize", "bigint", 64, 0, "out",
"hashes", "bigint", 64, 0, "out", "phash",
"boolean", 1, 0, "out", "imprints", "
bigint", 64, 0, "out", "sorted", "boolean", 1,
0, "out", "revsorted", "boolean", 1, 0, "out",
"unique", "boolean", 1, 0, "out" ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"(sname varchar(1024), tname varchar(1024)) 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\";", "sql", "MAL", "Function returning a table", false,
false, false, true, "schema", "varchar", 1024, 0, "out",
"table", "varchar", 1024, 0, "out", "column",
"varchar", 1024, 0, "out", "type", "varchar", 1024, 0,
"out", "mode", "varchar", 15, 0, "out", "location",
"varchar", 1024, 0, "out", "count", "bigint", 64,
0, "out", "typewidth", "int", 32, 0, "out", "columnsize",
"bigint", 64, 0, "out", "heapsize", "bigint", 64,
0, "out", "hashes", "bigint", 64, 0, "out",
"phash", "boolean", 1, 0,
"out", "imprints", "bigint", 64, 0, "out",
"sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname
varchar(1024)) 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\";", "sql", "MAL", "Function returning a
table", false, false, false, true, "schema", "varchar", 1024,
0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "mode", "varchar", 15, 0, "out",
"location", "varchar", 1024, 0, "out", "count",
"bigint", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "pha
sh", "boolean", 1, 0, "out", "imprints", "bigint",
64, 0, "out", "sorted", "boolean", 1, 0, "out",
"revsorted", "boolean", 1, 0, "out", "unique",
"boolean", 1, 0, "out" ]
@@ -4120,8 +4120,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "sum", "SYSTEM", "sum", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "sum", "SYSTEM", "sum", "sql",
"Internal C", "Analytic function", false, false, false, true,
"res_0", "sec_interval", 13, 0, "out", "arg_1",
"sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "suspend_log_flushing", "SYSTEM", "create
procedure sys.suspend_log_flushing() external name sql.suspend_log_flushing;",
"sql", "MAL", "Procedure", true, false, false, true, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "sys_update_schemas", "SYSTEM",
"update_schemas", "sql", "Internal C", "Procedure", false, false,
false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "sys_update_tables", "SYSTEM",
"update_tables", "sql", "Internal C", "Procedure", false, false,
false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "sys_update_schemas", "SYSTEM",
"update_schemas", "sql", "Internal C", "Procedure", true, false,
false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "sys_update_tables", "SYSTEM",
"update_tables", "sql", "Internal C", "Procedure", true, false,
false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "tan", "SYSTEM", "tan", "mmath",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "tan", "SYSTEM", "tan", "mmath",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "tanh", "SYSTEM", "tanh", "mmath",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -4129,7 +4129,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "text", "SYSTEM", "create function
\"text\" (p inet) returns clob external name inet.\"text\";", "inet", "MAL",
"Scalar function", false, false, false, true, "result", "clob",
0, 0, "out", "p", "inet", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "time_to_str", "SYSTEM", "create
function time_to_str(d time with time zone, format string) returns string
external name mtime.\"time_to_str\";", "mtime", "MAL", "Scalar
function", false, false, false, true, "result", "clob", 0,
0, "out", "d", "timetz", 1, 0, "in", "format",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "timestamp_to_str", "SYSTEM", "create
function timestamp_to_str(d timestamp with time zone, format string) returns
string external name mtime.\"timestamp_to_str\";", "mtime", "MAL",
"Scalar function", false, false, false, true, "result", "clob",
0, 0, "out", "d", "timestamptz", 7, 0, "in",
"format", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys.functions", "sys", "tracelog", "SYSTEM", "create
function sys.tracelog() returns table (ticks bigint, stmt string, event string)
external name sql.dump_trace;", "sql", "MAL", "Function returning a table",
true, false, false, true, "ticks", "bigint", 64, 0,
"out", "stmt", "clob", 0, 0, "out", "event", "clob", 0,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "tracelog", "SYSTEM", "create
function sys.tracelog() returns table (ticks bigint, stmt string, event string)
external name sql.dump_trace;", "sql", "MAL", "Function returning a table",
false, false, false, true, "ticks", "bigint", 64, 0,
"out", "stmt", "clob", 0, 0, "out", "event", "clob", 0,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "trim", "SYSTEM", "trim", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "char", 0, 0, "out", "arg_1", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "trim", "SYSTEM", "trim", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "trim", "SYSTEM", "trim", "str",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -4145,7 +4145,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "upper", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "char", 0, 0, "out", "arg_1", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "upper", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "clob", 0, 0, "out", "arg_1", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "upper", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "user_statistics", "SYSTEM", "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;", "sysmon",
"MAL", "Function returning a table", true, false, false, true,
"username", "clob", 0, 0, "out", "querycount", "bigint",
64, 0, "out", "totalticks", "bigint", 64, 0, "out",
"started", "timestamp", 7, 0, "out", "finished",
"timestamp", 7, 0, "out", "maxticks", "bigint", 64,
0, "out", "maxquery", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys.functions", "sys", "user_statistics", "SYSTEM", "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;", "sysmon",
"MAL", "Function returning a table", false, false, false, true,
"username", "clob", 0, 0, "out", "querycount", "bigint",
64, 0, "out", "totalticks", "bigint", 64, 0, "out",
"started", "timestamp", 7, 0, "out", "finished",
"timestamp", 7, 0, "out", "maxticks", "bigint", 64,
0, "out", "maxquery", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "date",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -4211,15 +4211,15 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "year", "SYSTEM", "year", "mtime",
"Internal C", "Scalar function", false, false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "timestamptz",
7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "zero_or_one", "SYSTEM", "zero_or_one",
"aggr", "Internal C", "Aggregate function", false, false, false, true,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "wlc", "beat", "SYSTEM", "create procedure
wlc.beat(duration int) external name wlc.\"setbeat\";", "wlc", "MAL",
"Procedure", true, false, false, true, "duration", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "wlc", "clock", "SYSTEM", "create
function wlc.clock() returns string external name wlc.\"getclock\";", "wlc",
"MAL", "Scalar function", true, false, false, true, "result",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "wlc", "clock", "SYSTEM", "create
function wlc.clock() returns string external name wlc.\"getclock\";", "wlc",
"MAL", "Scalar function", false, false, false, true, "result",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlc", "flush", "SYSTEM", "create
procedure wlc.flush() external name wlc.flush;", "wlc", "MAL",
"Procedure", true, false, false, true, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlc", "master", "SYSTEM", "create
procedure wlc.master() external name wlc.master;", "wlc", "MAL",
"Procedure", true, false, false, true, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlc", "master", "SYSTEM", "create
procedure wlc.master(path string) external name wlc.master;", "wlc", "MAL",
"Procedure", true, false, false, true, "path", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlc", "stop", "SYSTEM", "create procedure
wlc.stop() external name wlc.stop;", "wlc", "MAL", "Procedure", true,
false, false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys.functions", "wlc", "tick", "SYSTEM", "create function
wlc.tick() returns bigint external name wlc.\"gettick\";", "wlc", "MAL",
"Scalar function", true, false, false, true, "result",
"bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys.functions", "wlc", "tick", "SYSTEM", "create function
wlc.tick() returns bigint external name wlc.\"gettick\";", "wlc", "MAL",
"Scalar function", false, false, false, true, "result",
"bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "wlr", "accept", "SYSTEM", "create
procedure wlr.accept() external name wlr.accept;", "wlr", "MAL",
"Procedure", true, false, false, true, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlr", "beat", "SYSTEM", "create procedure
wlr.beat(duration integer) external name wlr.\"setbeat\";", "wlr", "MAL",
"Procedure", true, false, false, true, "duration", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "wlr", "clock", "SYSTEM", "create
function wlr.clock() returns string external name wlr.\"getclock\";", "wlr",
"MAL", "Scalar function", true, false, false, true, "result",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "wlr", "clock", "SYSTEM", "create
function wlr.clock() returns string external name wlr.\"getclock\";", "wlr",
"MAL", "Scalar function", false, false, false, true, "result",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlr", "master", "SYSTEM", "create
procedure wlr.master(dbname string) external name wlr.master;", "wlr", "MAL",
"Procedure", true, false, false, true, "dbname", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlr", "replicate", "SYSTEM", "create
procedure wlr.replicate() external name wlr.replicate;", "wlr", "MAL",
"Procedure", true, false, false, true, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlr", "replicate", "SYSTEM", "create
procedure wlr.replicate(id bigint) external name wlr.replicate;", "wlr",
"MAL", "Procedure", true, false, false, true, "id", "bigint",
64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -4228,7 +4228,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "wlr", "replicate", "SYSTEM", "create
procedure wlr.replicate(id tinyint) external name wlr.replicate;", "wlr",
"MAL", "Procedure", true, false, false, true, "id", "tinyint",
8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "wlr", "replicate", "SYSTEM", "create
procedure wlr.replicate(pointintime timestamp) external name wlr.replicate;",
"wlr", "MAL", "Procedure", true, false, false, true, "pointintime",
"timestamp", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "wlr", "stop", "SYSTEM", "create procedure
wlr.stop() external name wlr.stop;", "wlr", "MAL", "Procedure", true,
false, false, true, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys.functions", "wlr", "tick", "SYSTEM", "create function
wlr.tick() returns bigint external name wlr.\"gettick\";", "wlr", "MAL",
"Scalar function", true, false, false, true, "result",
"bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys.functions", "wlr", "tick", "SYSTEM", "create function
wlr.tick() returns bigint external name wlr.\"gettick\";", "wlr", "MAL",
"Scalar function", false, false, false, true, "result",
"bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
% .%1, sys.auths, sys.auths # table_name
% %1, name, grantor # name
% char, varchar, int # type
diff --git
a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -2860,7 +2860,7 @@ insert into sys.args values (39377, 777,
insert into sys.functions values (778, 'epoch_ms', 'epoch_ms', 'mtime', 0, 1,
false, false, false, 2000, true, false);
insert into sys.args values (39378, 778, 'res_0', 'decimal', 18, 3, 0, 0);
insert into sys.args values (39379, 778, 'arg_1', 'sec_interval', 13, 0, 1, 1);
-insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (779, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (39380, 779, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39381, 779, 'arg_1', 'clob', 0, 0, 1, 1);
insert into sys.args values (39382, 779, 'arg_2', 'clob', 0, 0, 1, 2);
@@ -3081,7 +3081,7 @@ insert into sys.args values (39542, 833,
insert into sys.args values (39543, 833, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (39544, 833, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (39545, 833, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (834, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (39546, 834, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39547, 834, 'arg_1', 'varchar', 0, 0, 1, 1);
insert into sys.args values (39548, 834, 'arg_2', 'varchar', 0, 0, 1, 2);
@@ -3302,7 +3302,7 @@ insert into sys.args values (39708, 888,
insert into sys.args values (39709, 888, 'arg_3', 'int', 32, 0, 1, 3);
insert into sys.args values (39710, 888, 'arg_4', 'int', 32, 0, 1, 4);
insert into sys.args values (39711, 888, 'arg_5', 'int', 32, 0, 1, 5);
-insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, false, false, false, 2000, true, true);
+insert into sys.functions values (889, 'next_value_for', 'next_value', 'sql',
0, 1, true, false, false, 2000, true, true);
insert into sys.args values (39712, 889, 'res_0', 'bigint', 64, 0, 0, 0);
insert into sys.args values (39713, 889, 'arg_1', 'char', 0, 0, 1, 1);
insert into sys.args values (39714, 889, 'arg_2', 'char', 0, 0, 1, 2);
@@ -5470,4 +5470,5 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'profiler') and name = 'getlimit';
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlc') and name in ('clock', 'tick');
update sys.functions set system = true where system <> true and schema_id =
(select id from sys.schemas where name = 'wlr') and name in ('clock', 'tick');
+drop view sys.systemfunctions;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
