Changeset: 87bd202a9757 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/87bd202a9757
Modified Files:
sql/test/emptydb/Tests/check.stable.out.32bit
Branch: default
Log Message:
32 bit approvals.
diffs (279 lines):
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
@@ -118,6 +118,8 @@ select 'duplicates in range_partitions',
select 'duplicates in value_partitions', count(*), table_id, partition_id,
"value" from sys.value_partitions group by table_id, partition_id, "value"
having count(*) > 1;
select 'duplicates in queue', count(*), tag from sys.queue group by tag having
count(*) > 1;
select 'duplicates in sessions', count(*), sessionid from sys.sessions group
by sessionid having count(*) > 1;
+select 'duplicates in fkey_actions', count(*), action_id from sys.fkey_actions
group by action_id having count(*) > 1;
+select 'duplicates in fkeys', count(*), id from sys.fkeys group by id having
count(*) > 1;
select 'duplicates in schemas', count(*), name from sys.schemas group by name
having count(*) > 1;
select 'duplicates in _tables', count(*), schema_id, name from sys._tables
group by schema_id, name having count(*) > 1;
select 'duplicates in tables', count(*), schema_id, name from sys.tables group
by schema_id, name having count(*) > 1;
@@ -148,6 +150,8 @@ select 'duplicates in comments', count(*
select 'duplicates in table_partitions WHERE column_id IS NOT NULL', count(*),
table_id, column_id from sys.table_partitions WHERE column_id IS NOT NULL group
by table_id, column_id having count(*) > 1;
select 'duplicates in table_partitions WHERE expression IS NOT NULL',
count(*), table_id, "expression" from sys.table_partitions WHERE "expression"
IS NOT NULL group by table_id, "expression" having count(*) > 1;
select 'duplicates in range_partitions', count(*), table_id, partition_id,
"maximum" from sys.range_partitions group by table_id, partition_id, "maximum"
having count(*) > 1;
+select 'duplicates in fkey_actions', count(*), action_name from
sys.fkey_actions group by action_name having count(*) > 1;
+select 'duplicates in fkeys', count(*), table_id, name from sys.fkeys group by
table_id, name having count(*) > 1;
select 'missing reference in schemas authorization', authorization, * from
sys.schemas where (authorization) not in (select id from sys.auths);
select 'missing reference in schemas owner', owner, * from sys.schemas where
(owner) not in (select id from sys.auths);
select 'missing reference in _tables schema_id', schema_id, * from sys._tables
where (schema_id) not in (select id from sys.schemas);
@@ -241,6 +245,11 @@ select 'missing reference in range_parti
select 'missing reference in range_partitions partition_id', partition_id, *
from sys.range_partitions where (partition_id) not in (select id from
sys.table_partitions);
select 'missing reference in value_partitions table_id', table_id, * from
sys.value_partitions where (table_id) not in (select id from sys._tables);
select 'missing reference in value_partitions partition_id', partition_id, *
from sys.value_partitions where (partition_id) not in (select id from
sys.table_partitions);
+select 'missing reference in keys cast(((action >> 8) & 255) as smallint)',
cast(((action >> 8) & 255) as smallint), * from sys.keys WHERE action >= 0 AND
(cast(((action >> 8) & 255) as smallint)) not in (select action_id from
sys.fkey_actions);
+select 'missing reference in keys cast((action & 255) as smallint)',
cast((action & 255) as smallint), * from sys.keys WHERE action >= 0 AND
(cast((action & 255) as smallint)) not in (select action_id from
sys.fkey_actions);
+select 'missing reference in fkeys id, table_id, type, name, rkey', id,
table_id, type, name, rkey, * from sys.fkeys where (id, table_id, type, name,
rkey) not in (select id, table_id, type, name, rkey from sys.keys);
+select 'missing reference in fkeys update_action_id', update_action_id, * from
sys.fkeys where (update_action_id) not in (select action_id from
sys.fkey_actions);
+select 'missing reference in fkeys delete_action_id', delete_action_id, * from
sys.fkeys where (delete_action_id) not in (select action_id from
sys.fkey_actions);
select 'null in _columns.id', id, * from sys._columns where id is null;
select 'null in _columns.name', name, * from sys._columns where name is null;
select 'null in _columns.type', type, * from sys._columns where type is null;
@@ -411,6 +420,17 @@ select 'null in table_partitions.type',
select 'null in value_partitions.table_id', table_id, * from
sys.value_partitions where table_id is null;
select 'null in value_partitions.partition_id', partition_id, * from
sys.value_partitions where partition_id is null;
select 'null in value_partitions.value', value, * from sys.value_partitions
where value is null;
+select 'null in fkey_actions.action_id', action_id, * from sys.fkey_actions
where action_id is null;
+select 'null in fkey_actions.action_name', action_name, * from
sys.fkey_actions where action_name is null;
+select 'null in fkeys.id', id, * from sys.fkeys where id is null;
+select 'null in fkeys.table_id', table_id, * from sys.fkeys where table_id is
null;
+select 'null in fkeys.type', type, * from sys.fkeys where type is null;
+select 'null in fkeys.name', name, * from sys.fkeys where name is null;
+select 'null in fkeys.rkey', rkey, * from sys.fkeys where rkey is null;
+select 'null in fkeys.update_action_id', update_action_id, * from sys.fkeys
where update_action_id is null;
+select 'null in fkeys.update_action', update_action, * from sys.fkeys where
update_action is null;
+select 'null in fkeys.delete_action_id', delete_action_id, * from sys.fkeys
where delete_action_id is null;
+select 'null in fkeys.delete_action', delete_action, * from sys.fkeys where
delete_action is null;
% .%1, .s, ., ., .s, . # table_name
% %1, name, authorization, owner, system, comment # name
% char, varchar, varchar, varchar, boolean,
varchar # type
@@ -1415,6 +1435,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "atan", "SYSTEM", "atan", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"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", "atan", "SYSTEM", "atan2",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "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", "atan", "SYSTEM", "atan2",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "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", "atan2", "SYSTEM", "atan2",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "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", "atan2", "SYSTEM", "atan2",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "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", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, false, NULL,
"res_0", "day_interval", 4, 0, "out", "arg_1",
"day_interval", 4, 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", "aggr",
"Internal C", "Aggregate function", false, false, false, false, NULL,
"res_0", "decimal", 2, 0, "out", "arg_1",
"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,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, false, NULL,
"res_0", "decimal", 4, 0, "out", "arg_1",
"decimal", 4, 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 ]
@@ -1543,6 +1565,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "current_time", "SYSTEM", "current_time",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "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, NULL, "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, NULL, "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", "database", "SYSTEM", "create
function sys.database () returns string external name
inspect.\"getDatabaseName\";", "inspect", "MAL", "Scalar function",
false, false, false, true, NULL, "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", "sys", "date_to_str", "SYSTEM", "create
function date_to_str(d date, format string) returns string external name
mtime.\"date_to_str\";", "mtime", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "clob", 0, 0,
"out", "d", "date", 0, 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", "date_trunc", "SYSTEM", "create
function sys.date_trunc(txt string, t timestamp with time zone) returns
timestamp with time zone external name sql.date_trunc;", "sql", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"timestamptz", 7, 0, "out", "txt", "clob", 0, 0, "in",
"t", "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 ]
[ "sys.functions", "sys", "date_trunc", "SYSTEM", "create
function sys.date_trunc(txt string, t timestamp) returns timestamp external
name sql.date_trunc;", "sql", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "timestamp", 7, 0,
"out", "txt", "clob", 0, 0, "in", "t", "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 ]
@@ -1864,6 +1887,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "patindex", "SYSTEM", "patindex",
"pcre", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "int", 32, 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", "patindex", "SYSTEM", "patindex",
"pcre", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "int", 32, 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", "pause", "SYSTEM", "create
procedure sys.pause(tag bigint) external name sysmon.pause;", "sysmon",
"MAL", "Procedure", true, false, false, true, NULL, "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", "pause", "SYSTEM", "create
procedure sys.pause(tag bigint, username string) external name sysmon.pause;",
"sysmon", "MAL", "Procedure", true, false, false, true, NULL,
"tag", "bigint", 64, 0, "in", "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", "pcre_replace", "", "create function
pcre_replace(origin string, pat string, repl string, flags string) returns
string external name pcre.replace;", "pcre", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "clob", 0, 0,
"out", "origin", "clob", 0, 0, "in", "pat", "clob", 0,
0, "in", "repl", "clob", 0, 0, "in", "flags",
"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 ]
[ "sys.functions", "sys", "percent_rank", "SYSTEM", "percent_rank",
"sql", "Internal C", "Analytic function", false, false, false, true,
NULL, "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", "pi", "SYSTEM", "pi", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 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 ]
@@ -1919,6 +1943,7 @@ select 'null in value_partitions.value',
[ "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, 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, NULL, "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",
false, false, false, true, NULL, "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(username string) 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, NULL, "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", "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 ]
[ "sys.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "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, NULL, "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, NULL,
"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 ]
@@ -1938,6 +1963,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "restart", "SYSTEM", "restart",
"sql", "Internal C", "Scalar function", true, false, false, true,
NULL, "res_0", "bigint", 64, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "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 ]
[ "sys.functions", "sys", "restart", "SYSTEM", "restart",
"sql", "Internal C", "Scalar function", true, false, false, true,
NULL, "res_0", "bigint", 64, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", "arg_3", "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 ]
[ "sys.functions", "sys", "resume", "SYSTEM", "create
procedure sys.resume(tag bigint) external name sysmon.resume;", "sysmon",
"MAL", "Procedure", true, false, false, true, NULL, "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", "resume", "SYSTEM", "create
procedure sys.resume(tag bigint, username string) external name
sysmon.resume;", "sysmon", "MAL", "Procedure", true, false,
false, true, NULL, "tag", "bigint", 64, 0, "in",
"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", "resume_log_flushing", "SYSTEM", "create
procedure sys.resume_log_flushing() external name sql.resume_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, NULL ]
[ "sys.functions", "sys", "right", "SYSTEM", "stringright",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "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", "right", "SYSTEM", "stringright",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "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 ]
@@ -2387,6 +2413,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val smallint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "val", "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 ]
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "val", "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", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, NULL, "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", "SYSTEM", "create procedure
sys.stop(tag bigint, username string) external name sysmon.stop;", "sysmon",
"MAL", "Procedure", true, false, false, true, NULL, "tag",
"bigint", 64, 0, "in", "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", "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, NULL, "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, NULL, "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", false, false, false, true, NULL, "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" ]
@@ -2445,6 +2472,65 @@ 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, NULL, "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, NULL, "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, NULL, "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", "timestampadd", "SYSTEM",
"odbc_timestamp_add_month_time", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamp", 7, 0, "out", "arg_1", "time", 7, 0,
"in", "arg_2", "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 ]
+[ "sys.functions", "sys", "timestampadd", "SYSTEM",
"odbc_timestamp_add_msec_date", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamp", 7, 0, "out", "arg_1", "date", 0, 0,
"in", "arg_2", "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 ]
+[ "sys.functions", "sys", "timestampadd", "SYSTEM",
"odbc_timestamp_add_msec_time", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamp", 7, 0, "out", "arg_1", "time", 7, 0,
"in", "arg_2", "day_interval", 4, 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", "timestampadd", "SYSTEM",
"timestamp_add_month_interval", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamp", 7, 0, "out", "arg_1", "timestamp", 7,
0, "in", "arg_2", "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 ]
+[ "sys.functions", "sys", "timestampadd", "SYSTEM",
"timestamp_add_month_interval", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamptz", 7, 0, "out", "arg_1", "timestamptz", 7,
0, "in", "arg_2", "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 ]
+[ "sys.functions", "sys", "timestampadd", "SYSTEM",
"timestamp_add_msec_interval", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamp", 7, 0, "out", "arg_1", "timestamp", 7,
0, "in", "arg_2", "day_interval", 4, 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", "timestampadd", "SYSTEM",
"timestamp_add_msec_interval", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamp", 7, 0, "out", "arg_1", "timestamp", 7,
0, "in", "arg_2", "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 ]
+[ "sys.functions", "sys", "timestampadd", "SYSTEM",
"timestamp_add_msec_interval", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamptz", 7, 0, "out", "arg_1", "timestamptz", 7,
0, "in", "arg_2", "day_interval", 4, 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", "timestampadd", "SYSTEM",
"timestamp_add_msec_interval", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0",
"timestamptz", 7, 0, "out", "arg_1", "timestamptz", 7,
0, "in", "arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff", "SYSTEM", "diff",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "sec_interval", 13, 0, "out",
"arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff", "SYSTEM", "diff",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "sec_interval", 13, 0, "out",
"arg_1", "timestamptz", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_day", "SYSTEM",
"timestampdiff_day", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_day", "SYSTEM",
"timestampdiff_day", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_day", "SYSTEM",
"timestampdiff_day", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_day", "SYSTEM",
"timestampdiff_day", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_day", "SYSTEM",
"timestampdiff_day", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_day", "SYSTEM",
"timestampdiff_day", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_hour", "SYSTEM",
"timestampdiff_hour", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "date", 0, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_hour", "SYSTEM",
"timestampdiff_hour", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "date", 0, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_hour", "SYSTEM",
"timestampdiff_hour", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_hour", "SYSTEM",
"timestampdiff_hour", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_hour", "SYSTEM",
"timestampdiff_hour", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_hour", "SYSTEM",
"timestampdiff_hour", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_min", "SYSTEM",
"timestampdiff_min", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "date", 0, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_min", "SYSTEM",
"timestampdiff_min", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "date", 0, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_min", "SYSTEM",
"timestampdiff_min", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_min", "SYSTEM",
"timestampdiff_min", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_min", "SYSTEM",
"timestampdiff_min", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_min", "SYSTEM",
"timestampdiff_min", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_month", "SYSTEM",
"timestampdiff_month", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_month", "SYSTEM",
"timestampdiff_month", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_month", "SYSTEM",
"timestampdiff_month", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_month", "SYSTEM",
"timestampdiff_month", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_month", "SYSTEM",
"timestampdiff_month", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_month", "SYSTEM",
"timestampdiff_month", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_quarter", "SYSTEM",
"timestampdiff_quarter", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0", "int",
32, 0, "out", "arg_1", "time", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_quarter", "SYSTEM",
"timestampdiff_quarter", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0", "int",
32, 0, "out", "arg_1", "time", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_quarter", "SYSTEM",
"timestampdiff_quarter", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0", "int",
32, 0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_quarter", "SYSTEM",
"timestampdiff_quarter", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0", "int",
32, 0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_quarter", "SYSTEM",
"timestampdiff_quarter", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0", "int",
32, 0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_quarter", "SYSTEM",
"timestampdiff_quarter", "mtime", "Internal C", "Scalar
function", false, false, false, false, NULL, "res_0", "int",
32, 0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_sec", "SYSTEM",
"timestampdiff_sec", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "date", 0, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_sec", "SYSTEM",
"timestampdiff_sec", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "date", 0, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_sec", "SYSTEM",
"timestampdiff_sec", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_sec", "SYSTEM",
"timestampdiff_sec", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamp", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_sec", "SYSTEM",
"timestampdiff_sec", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_sec", "SYSTEM",
"timestampdiff_sec", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "bigint", 64,
0, "out", "arg_1", "timestamptz", 7, 0, "in",
"arg_2", "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 ]
+[ "sys.functions", "sys", "timestampdiff_week", "SYSTEM",
"timestampdiff_week", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_week", "SYSTEM",
"timestampdiff_week", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_week", "SYSTEM",
"timestampdiff_week", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_week", "SYSTEM",
"timestampdiff_week", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_week", "SYSTEM",
"timestampdiff_week", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_week", "SYSTEM",
"timestampdiff_week", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "time", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
+[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"time", 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 ]
+[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"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
]
[ "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, NULL, "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, NULL,
"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, NULL,
"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 ]
@@ -4160,6 +4246,7 @@ select 'null in value_partitions.value',
[ "grant on function", "sys", "covar_samp", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "covar_samp", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "current_sessionid", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "database", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "date_to_str", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "date_trunc", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "date_trunc", "public", "EXECUTE",
"monetdb", 0 ]
@@ -5102,6 +5189,14 @@ select 'null in value_partitions.value',
% %3, %2, sessionid # name
% char, bigint, int # type
% 22, 1, 1 # length
+% .%2, sys.%1, sys.fkey_actions # table_name
+% %2, %1, action_id # name
+% char, bigint, smallint # type
+% 26, 1, 1 # length
+% .%13, .%12, .fkeys # table_name
+% %13, %12, id # name
+% char, bigint, int # type
+% 19, 1, 1 # length
% .%2, sys.%1, sys.schemas # table_name
% %2, %1, name # name
% char, bigint, varchar # type
@@ -5222,6 +5317,14 @@ select 'null in value_partitions.value',
% %2, %1, table_id, partition_id, maximum # name
% char, bigint, int, int, varchar # type
% 30, 1, 1, 1, 0 # length
+% .%2, sys.%1, sys.fkey_actions # table_name
+% %2, %1, action_name # name
+% char, bigint, varchar # type
+% 26, 1, 0 # length
+% .%13, .%12, .fkeys, .fkeys # table_name
+% %13, %12, table_id, name # name
+% char, bigint, int, varchar # type
+% 19, 1, 1, 0 # length
% .%5, sys.schemas, sys.schemas, sys.schemas, sys.schemas,
sys.schemas, sys.schemas # table_name
% %5, authorization, id, name, authorization, owner, system # name
% char, int, int, varchar, int, int, boolean # type
@@ -5594,6 +5697,26 @@ select 'null in value_partitions.value',
% %5, partition_id, table_id, partition_id, value # name
% char, int, int, int, varchar # type
% 50, 1, 1, 1, 0 # length
+% .%10, .%4, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
+% %10, %4, id, table_id, type, name, rkey, action # name
+% char, smallint, int, int, int, varchar, int,
int # type
+% 65, 1, 1, 1, 1, 0, 1, 1 # length
+% .%10, .%4, .keys, .keys, .keys, .keys, .keys, .keys #
table_name
+% %10, %4, id, table_id, type, name, rkey, action # name
+% char, smallint, int, int, int, varchar, int,
int # type
+% 58, 1, 1, 1, 1, 0, 1, 1 # length
+% .%30, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys # table_name
+% %30, id, table_id, type, name, rkey, id, table_id,
type, name, rkey, update_action_id, update_action,
delete_action_id, delete_action # name
+% char, int, int, int, varchar, int, int, int,
int, varchar, int, smallint, varchar, smallint,
varchar # type
+% 57, 1, 1, 1, 0, 1, 1, 1, 1, 0,
1, 1, 0, 1, 0 # length
+% .%16, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %16, update_action_id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, smallint, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 43, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%16, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %16, delete_action_id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, smallint, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 43, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
% .%1, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns, sys._columns, sys._columns, sys._columns,
sys._columns, sys._columns # table_name
% %1, id, id, name, type, type_digits, type_scale,
table_id, default, null, number, storage # name
% char, int, int, varchar, varchar, int, int,
int, varchar, boolean, int, varchar # type
@@ -6274,3 +6397,47 @@ select 'null in value_partitions.value',
% %1, value, table_id, partition_id, value # name
% char, varchar, int, int, varchar # type
% 30, 0, 1, 1, 0 # length
+% .%1, .fkey_actions, .fkey_actions, .fkey_actions # table_name
+% %1, action_id, action_id, action_name # name
+% char, smallint, smallint, varchar # type
+% 30, 1, 1, 0 # length
+% .%1, .fkey_actions, .fkey_actions, .fkey_actions # table_name
+% %1, action_name, action_id, action_name # name
+% char, varchar, smallint, varchar # type
+% 32, 0, 1, 0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, int, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 16, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, table_id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, int, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 22, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, type, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, int, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 18, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, name, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, varchar, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 18, 0, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, rkey, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, int, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 18, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, update_action_id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, smallint, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 30, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%12, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %12, update_action, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, varchar, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 27, 0, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%14, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %14, delete_action_id, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, smallint, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 30, 1, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
+% .%12, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys, .fkeys,
.fkeys, .fkeys # table_name
+% %12, delete_action, id, table_id, type, name, rkey,
update_action_id, update_action, delete_action_id, delete_action #
name
+% char, varchar, int, int, int, varchar, int,
smallint, varchar, smallint, varchar # type
+% 27, 0, 1, 1, 1, 0, 1, 1, 0, 1,
0 # length
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
