Changeset: 0c74f8862049 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0c74f8862049
Modified Files:
        sql/test/emptydb/Tests/check.stable.out.32bit
Branch: Dec2025
Log Message:

Approve 32 bit output.


diffs (232 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
@@ -505,7 +505,7 @@ select 'null in fkeys.delete_action', de
 [ "sys._tables",       "sys",  "describe_sequences",   "create view 
sys.describe_sequences as select s.name sch, seq.name seq, seq.\"start\" s, 
get_value_for(s.name, seq.name) rs, seq.\"minvalue\" mi, seq.\"maxvalue\" ma, 
seq.\"increment\" inc, seq.\"cacheinc\" cache, seq.\"cycle\" cycle, case when 
seq.\"minvalue\" = -9223372036854775807 and seq.\"increment\" > 0 and 
seq.\"start\" = 1 then true else false end nomin, case when seq.\"maxvalue\" = 
9223372036854775807 and seq.\"increment\" < 0 and seq.\"start\" = -1 then true 
else false end nomax, case when seq.\"minvalue\" = 0 and seq.\"increment\" > 0 
then null when seq.\"minvalue\" <> -9223372036854775807 then seq.\"minvalue\" 
else case when seq.\"increment\" < 0 then null else case when seq.\"start\" = 1 
then null else seq.\"maxvalue\" end end end rmi, case when seq.\"maxvalue\" = 0 
and seq.\"increment\" < 0 then null when seq.\"maxvalue\" <> 
9223372036854775807 then seq.\"maxvalue\" else case when seq.\"increment\" > 0 
then null else case w
 hen seq.\"start\" = -1 then null else seq.\"maxvalue\" end end end rma from 
sys.sequences seq, sys.schemas s where s.id = seq.schema_id and s.name <> 'tmp' 
order by s.name, seq.name;",       "VIEW", true,   "COMMIT",       "WRITABLE",  
   NULL    ]
 [ "sys._tables",       "sys",  "describe_tables",      "create view 
sys.describe_tables as select t.id o, s.name sch, t.name tab, 
ts.table_type_name typ, (select ' (' || group_concat(sys.dq(c.name) || ' ' || 
sys.describe_type(c.type, c.type_digits, c.type_scale) || ifthenelse(c.\"null\" 
= 'false', ' NOT NULL', '') , ', ') || ')' from sys._columns c where c.table_id 
= t.id) col, case ts.table_type_name when 'REMOTE TABLE' then 
sys.get_remote_table_expressions(s.name, t.name) when 'MERGE TABLE' then 
sys.get_merge_table_partition_expressions(t.id) when 'VIEW' then 
sys.schema_guard(s.name, t.name, t.query) else '' end opt from sys.schemas s, 
sys.table_types ts, sys.tables t where ts.table_type_name in ('TABLE', 'VIEW', 
'MERGE TABLE', 'REMOTE TABLE', 'REPLICA TABLE', 'UNLOGGED TABLE') and t.system 
= false and s.id = t.schema_id and ts.table_type_id = t.type and s.name <> 
'tmp';",        "VIEW", true,   "COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "describe_triggers",    "create view 
sys.describe_triggers as select s.name sch, t.name tab, tr.name tri, 
tr.statement def from sys.schemas s, sys.tables t, sys.triggers tr where s.id = 
t.schema_id and t.id = tr.table_id and not t.system;",        "VIEW", true,   
"COMMIT",       "WRITABLE",     NULL    ]
-[ "sys._tables",       "sys",  "describe_user_defined_types",  "create view 
sys.describe_user_defined_types as select s.name sch, t.sqlname sql_tpe, 
t.systemname ext_tpe from sys.types t join sys.schemas s on t.schema_id = s.id 
where t.eclass = 18 and ((s.name = 'sys' and t.sqlname not in ('geometrya', 
'mbr', 'url', 'inet', 'json', 'uuid', 'xml')) or (s.name <> 'sys'));", "VIEW", 
true,   "COMMIT",       "WRITABLE",     NULL    ]
+[ "sys._tables",       "sys",  "describe_user_defined_types",  "create view 
sys.describe_user_defined_types as select s.name sch, t.sqlname sql_tpe, 
t.systemname ext_tpe from sys.types t join sys.schemas s on t.schema_id = s.id 
where t.eclass = 18 and ((s.name = 'sys' and t.sqlname not in ('geometrya', 
'mbr', 'url', 'inet', 'json', 'uuid', 'xml', 'inet4', 'inet6')) or (s.name <> 
'sys'));",       "VIEW", true,   "COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "dump_add_schemas_to_users",    "create view 
sys.dump_add_schemas_to_users as select 'ALTER USER ' || sys.dq(ui.name) || ' 
SET SCHEMA ' || sys.dq(s.name) || ';' stmt, s.name schema_name, ui.name 
user_name from sys.db_user_info ui, sys.schemas s where ui.default_schema = 
s.id and ui.name <> 'monetdb' and ui.name <> '.snapshot' and s.name <> 'sys';", 
 "VIEW", true,   "COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "dump_column_defaults", "create view 
sys.dump_column_defaults as select 'ALTER TABLE ' || sys.fqn(sch, tbl) || ' 
ALTER COLUMN ' || sys.dq(col) || ' SET DEFAULT ' || def || ';' stmt, sch 
schema_name, tbl table_name, col column_name from 
sys.describe_column_defaults;",     "VIEW", true,   "COMMIT",       "WRITABLE", 
    NULL    ]
 [ "sys._tables",       "sys",  "dump_column_grants",   "create view 
sys.dump_column_grants as select 'GRANT ' || pc.privilege_code_name || '(' || 
sys.dq(c.name) || ') ON ' || sys.fqn(s.name, t.name) || ' TO ' || 
ifthenelse(a.name = 'public', 'PUBLIC', sys.dq(a.name)) || case when 
p.grantable = 1 then ' WITH GRANT OPTION' else '' end || ';' stmt, s.name 
schema_name, t.name table_name, c.name column_name, a.name grantee from 
sys.schemas s, sys.tables t, sys.columns c, sys.auths a, sys.privileges p, 
sys.auths g, sys.privilege_codes pc where p.obj_id = c.id and c.table_id = t.id 
and p.auth_id = a.id and t.schema_id = s.id and not t.system and p.grantor = 
g.id and p.privileges = pc.privilege_code_id order by s.name, t.name, c.name, 
a.name, g.name, p.grantable;",        "VIEW", true,   "COMMIT",       
"WRITABLE",     NULL    ]
@@ -535,7 +535,7 @@ select 'null in fkeys.delete_action', de
 [ "sys._tables",       "sys",  "function_types",       NULL,   "TABLE",        
true,   "COMMIT",       "READONLY",     NULL    ]
 [ "sys._tables",       "sys",  "functions",    NULL,   "TABLE",        true,   
"COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "geometry_columns",     "create view 
sys.geometry_columns as select cast(null as varchar(1)) as f_table_catalog, 
s.name as f_table_schema, t.name as f_table_name, c.name as f_geometry_column, 
cast(has_z(c.type_digits) + has_m(c.type_digits) +2 as integer) as 
coord_dimension, c.type_scale as srid, get_type(c.type_digits, 0) as 
geometry_type from sys.columns c, sys.tables t, sys.schemas s where c.table_id 
= t.id and t.schema_id = s.id and c.type in (select sqlname from sys.types 
where systemname = 'wkb');",  "VIEW", true,   "COMMIT",       "WRITABLE",     
NULL    ]
-[ "sys._tables",       "sys",  "ids",  "create view sys.ids (id, name, 
schema_id, table_id, table_name, obj_type, sys_table, system) as select id, 
name, cast(null as int) as schema_id, cast(null as int) as table_id, cast(null 
as varchar(124)) as table_name, 'author' as obj_type, 'sys.auths' as sys_table, 
(name in ('public','sysadmin','monetdb','.snapshot')) as system from sys.auths 
union all select id, name, cast(null as int) as schema_id, cast(null as int) as 
table_id, cast(null as varchar(124)) as table_name, ifthenelse(system, 'system 
schema', 'schema'), 'sys.schemas', system from sys.schemas union all select 
t.id, name, t.schema_id, t.id as table_id, t.name as table_name, 
cast(lower(tt.table_type_name) as varchar(40)), 'sys.tables', t.system from 
sys.tables t left outer join sys.table_types tt on t.type = tt.table_type_id 
union all select c.id, c.name, t.schema_id, c.table_id, t.name as table_name, 
ifthenelse(t.system, 'system column', 'column'), 'sys._columns', t.system from 
sys._colum
 ns c join sys._tables t on c.table_id = t.id union all select c.id, c.name, 
t.schema_id, c.table_id, t.name as table_name, 'column', 'tmp._columns', 
t.system from tmp._columns c join tmp._tables t on c.table_id = t.id union all 
select k.id, k.name, t.schema_id, k.table_id, t.name as table_name, 
ifthenelse(t.system, 'system key', 'key'), 'sys.keys', t.system from sys.keys k 
join sys._tables t on k.table_id = t.id union all select k.id, k.name, 
t.schema_id, k.table_id, t.name as table_name, 'key', 'tmp.keys', t.system from 
tmp.keys k join tmp._tables t on k.table_id = t.id union all select i.id, 
i.name, t.schema_id, i.table_id, t.name as table_name, ifthenelse(t.system, 
'system index', 'index'), 'sys.idxs', t.system from sys.idxs i join sys._tables 
t on i.table_id = t.id union all select i.id, i.name, t.schema_id, i.table_id, 
t.name as table_name, 'index' , 'tmp.idxs', t.system from tmp.idxs i join 
tmp._tables t on i.table_id = t.id union all select g.id, g.name, t.schema_id, 
g.table_
 id, t.name as table_name, ifthenelse(t.system, 'system trigger', 'trigger'), 
'sys.triggers', t.system from sys.triggers g join sys._tables t on g.table_id = 
t.id union all select g.id, g.name, t.schema_id, g.table_id, t.name as 
table_name, 'trigger', 'tmp.triggers', t.system from tmp.triggers g join 
tmp._tables t on g.table_id = t.id union all select f.id, f.name, f.schema_id, 
cast(null as int) as table_id, cast(null as varchar(124)) as table_name, 
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) as 
varchar(40)), 'sys.functions', f.system from sys.functions f left outer join 
sys.function_types ft on f.type = ft.function_type_id union all select a.id, 
a.name, f.schema_id, a.func_id as table_id, f.name as table_name, 
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) || 
' arg' as varchar(44)), 'sys.args', f.system from sys.args a join sys.functions 
f on a.func_id = f.id left outer join sys.function_types ft on f.type = 
ft.function_ty
 pe_id union all select id, name, schema_id, cast(null as int) as table_id, 
cast(null as varchar(124)) as table_name, 'sequence', 'sys.sequences', false 
from sys.sequences union all select o.id, o.name, pt.schema_id, pt.id, pt.name, 
'partition of merge table', 'sys.objects', false from sys.objects o join 
sys._tables pt on o.sub = pt.id join sys._tables mt on o.nr = mt.id where 
mt.type = 3 union all select id, sqlname, schema_id, cast(null as int) as 
table_id, cast(null as varchar(124)) as table_name, 'type', 'sys.types', 
(sqlname in ('inet','json','url','uuid')) from sys.types order by id;",  
"VIEW", true,   "COMMIT",       "WRITABLE",     NULL    ]
+[ "sys._tables",       "sys",  "ids",  "create view sys.ids (id, name, 
schema_id, table_id, table_name, obj_type, sys_table, system) as select id, 
name, cast(null as int) as schema_id, cast(null as int) as table_id, cast(null 
as varchar(124)) as table_name, 'author' as obj_type, 'sys.auths' as sys_table, 
(name in ('public','sysadmin','monetdb','.snapshot')) as system from sys.auths 
union all select id, name, cast(null as int) as schema_id, cast(null as int) as 
table_id, cast(null as varchar(124)) as table_name, ifthenelse(system, 'system 
schema', 'schema'), 'sys.schemas', system from sys.schemas union all select 
t.id, name, t.schema_id, t.id as table_id, t.name as table_name, 
cast(lower(tt.table_type_name) as varchar(40)), 'sys.tables', t.system from 
sys.tables t left outer join sys.table_types tt on t.type = tt.table_type_id 
union all select c.id, c.name, t.schema_id, c.table_id, t.name as table_name, 
ifthenelse(t.system, 'system column', 'column'), 'sys._columns', t.system from 
sys._colum
 ns c join sys._tables t on c.table_id = t.id union all select c.id, c.name, 
t.schema_id, c.table_id, t.name as table_name, 'column', 'tmp._columns', 
t.system from tmp._columns c join tmp._tables t on c.table_id = t.id union all 
select k.id, k.name, t.schema_id, k.table_id, t.name as table_name, 
ifthenelse(t.system, 'system key', 'key'), 'sys.keys', t.system from sys.keys k 
join sys._tables t on k.table_id = t.id union all select k.id, k.name, 
t.schema_id, k.table_id, t.name as table_name, 'key', 'tmp.keys', t.system from 
tmp.keys k join tmp._tables t on k.table_id = t.id union all select i.id, 
i.name, t.schema_id, i.table_id, t.name as table_name, ifthenelse(t.system, 
'system index', 'index'), 'sys.idxs', t.system from sys.idxs i join sys._tables 
t on i.table_id = t.id union all select i.id, i.name, t.schema_id, i.table_id, 
t.name as table_name, 'index' , 'tmp.idxs', t.system from tmp.idxs i join 
tmp._tables t on i.table_id = t.id union all select g.id, g.name, t.schema_id, 
g.table_
 id, t.name as table_name, ifthenelse(t.system, 'system trigger', 'trigger'), 
'sys.triggers', t.system from sys.triggers g join sys._tables t on g.table_id = 
t.id union all select g.id, g.name, t.schema_id, g.table_id, t.name as 
table_name, 'trigger', 'tmp.triggers', t.system from tmp.triggers g join 
tmp._tables t on g.table_id = t.id union all select f.id, f.name, f.schema_id, 
cast(null as int) as table_id, cast(null as varchar(124)) as table_name, 
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) as 
varchar(40)), 'sys.functions', f.system from sys.functions f left outer join 
sys.function_types ft on f.type = ft.function_type_id union all select a.id, 
a.name, f.schema_id, a.func_id as table_id, f.name as table_name, 
cast(ifthenelse(f.system, 'system ', '') || lower(ft.function_type_keyword) || 
' arg' as varchar(44)), 'sys.args', f.system from sys.args a join sys.functions 
f on a.func_id = f.id left outer join sys.function_types ft on f.type = 
ft.function_ty
 pe_id union all select id, name, schema_id, cast(null as int) as table_id, 
cast(null as varchar(124)) as table_name, 'sequence', 'sys.sequences', false 
from sys.sequences union all select o.id, o.name, pt.schema_id, pt.id, pt.name, 
'partition of merge table', 'sys.objects', false from sys.objects o join 
sys._tables pt on o.sub = pt.id join sys._tables mt on o.nr = mt.id where 
mt.type = 3 union all select id, sqlname, schema_id, cast(null as int) as 
table_id, cast(null as varchar(124)) as table_name, 'type', 'sys.types', 
(sqlname in ('inet','json','url','uuid','inet4','inet6')) from sys.types order 
by id;",  "VIEW", true,   "COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "idxs", NULL,   "TABLE",        true,   
"COMMIT",       "WRITABLE",     NULL    ]
 [ "sys._tables",       "sys",  "index_types",  NULL,   "TABLE",        true,   
"COMMIT",       "READONLY",     NULL    ]
 [ "sys._tables",       "sys",  "key_types",    NULL,   "TABLE",        true,   
"COMMIT",       "READONLY",     NULL    ]
@@ -1710,7 +1710,7 @@ select 'null in fkeys.delete_action', de
 % .%1, .s,     .f,     .,      .,      .f,     .fl,    .,      .f,     .f,     
.f,     .f,     .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      .,      .,      .,      .,      .,      .,      .,      .,      
.,      .,      . # table_name
 % %1,  name,   name,   system, query,  mod,    language_name,  func_type,      
side_effect,    varres, vararg, semantics,      comment,        name0,  type0,  
type_digits0,   type_scale0,    inout0, name1,  type1,  type_digits1,   
type_scale1,    inout1, name2,  type2,  type_digits2,   type_scale2,    inout2, 
name3,  type3,  type_digits3,   type_scale3,    inout3, name4,  type4,  
type_digits4,   type_scale4,    inout4, name5,  type5,  type_digits5,   
type_scale5,    inout5, name6,  type6,  type_digits6,   type_scale6,    inout6, 
name7,  type7,  type_digits7,   type_scale7,    inout7, name8,  type8,  
type_digits8,   type_scale8,    inout8, name9,  type9,  type_digits9,   
type_scale9,    inout9, name10, type10, type_digits10,  type_scale10,   
inout10,        name11, type11, type_digits11,  type_scale11,   inout11,        
name12, type12, type_digits12,  type_scale12,   inout12,        name13, type13, 
type_digits13,  type_scale13,   inout13,        name14, type14, type_digits14,  
type_scale14,   inout14,        name15, type15, type_digits15,  type_scale15,   
inout15 # name
 % varchar,     varchar,        varchar,        varchar,        varchar,        
varchar,        varchar,        varchar,        boolean,        boolean,        
boolean,        boolean,        varchar,        varchar,        varchar,        
int,    int,    varchar,        varchar,        varchar,        int,    int,    
varchar,        varchar,        varchar,        int,    int,    varchar,        
varchar,        varchar,        int,    int,    varchar,        varchar,        
varchar,        int,    int,    varchar,        varchar,        varchar,        
int,    int,    varchar,        varchar,        varchar,        int,    int,    
varchar,        varchar,        varchar,        int,    int,    varchar,        
varchar,        varchar,        int,    int,    varchar,        varchar,        
varchar,        int,    int,    varchar,        varchar,        varchar,        
int,    int,    varchar,        varchar,        varchar,        int,    int,    
varchar,        varchar,        varchar,        int,    int,    varchar,        
varchar,        varchar,        int,    int,    varchar,        varchar,        
varchar,        int,    int,    varchar,        varchar,        varchar,        
int,    int,    varchar # type
-% 13,  8,      37,     6,      3806,   9,      10,     26,     5,      5,      
5,      5,      0,      11,     14,     4,      1,      3,      16,     14,     
4,      1,      3,      16,     14,     4,      1,      3,      27,     14,     
4,      1,      3,      9,      9,      4,      1,      3,      14,     7,      
4,      1,      3,      12,     9,      2,      1,      3,      11,     7,      
2,      1,      3,      11,     7,      2,      1,      3,      10,     7,      
2,      1,      3,      9,      7,      2,      1,      3,      8,      7,      
1,      1,      3,      11,     7,      2,      1,      3,      6,      7,      
4,      1,      3,      9,      7,      4,      1,      3,      6,      7,      
4,      1,      3 # length
+% 13,  7,      37,     6,      3806,   9,      10,     26,     5,      5,      
5,      5,      0,      11,     14,     4,      1,      3,      16,     14,     
4,      1,      3,      16,     14,     4,      1,      3,      27,     14,     
4,      1,      3,      9,      9,      4,      1,      3,      14,     7,      
4,      1,      3,      12,     9,      2,      1,      3,      11,     7,      
2,      1,      3,      11,     7,      2,      1,      3,      10,     7,      
2,      1,      3,      9,      7,      2,      1,      3,      8,      7,      
1,      1,      3,      11,     7,      2,      1,      3,      6,      7,      
4,      1,      3,      9,      7,      4,      1,      3,      6,      7,      
4,      1,      3 # length
 [ "sys.functions",     "json", "filter",       "SYSTEM",       "create 
function json.filter(js json, name bigint) returns json external name 
json.filter;",    "json", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "json", 0,      0,      "out",  "js",   
"json", 0,      0,      "in",   "name", "bigint",       63,     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",     "json", "filter",       "SYSTEM",       "create 
function json.filter(js json, name integer) returns json external name 
json.filter;",   "json", "MAL",  "Scalar function",      false,  false,  false, 
 true,   NULL,   "result",       "json", 0,      0,      "out",  "js",   
"json", 0,      0,      "in",   "name", "int",  31,     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",     "json", "filter",       "SYSTEM",       "create 
function json.filter(js json, name tinyint) returns json external name 
json.filter;",   "json", "MAL",  "Scalar function",      false,  false,  false, 
 true,   NULL,   "result",       "json", 0,      0,      "out",  "js",   
"json", 0,      0,      "in",   "name", "tinyint",      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    ]
@@ -1738,11 +1738,6 @@ select 'null in fkeys.delete_action', de
 [ "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,   NULL,   "comp_id",      "varchar",      0,      0,      
"in",   "lvl_id",       "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",     "logging",      "setflushlevel",        "SYSTEM",       
"create procedure logging.setflushlevel(lvl_id string) external name 
logging.setflushlevel;",   "logging",      "MAL",  "Procedure",    true,   
false,  false,  true,   NULL,   "lvl_id",       "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,   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,   NULL,   "layer_id",     "varchar",      0,      
0,      "in",   "lvl_id",       "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",     "profiler",     "getlimit",     "SYSTEM",       "create 
function profiler.getlimit() returns integer external name profiler.getlimit;", 
"profiler",     "MAL",  "Scalar function",      false,  false,  false,  true,   
NULL,   "result",       "int",  31,     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,   NULL,   "beat", "int",  31,     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,   NULL,   
"lim",  "int",  31,     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,   NULL    ]
-[ "sys.functions",     "profiler",     "stop", "SYSTEM",       "create 
procedure profiler.stop() external name profiler.stop;",        "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,   NULL    ]
 [ "sys.functions",     "sys",  "<",    "SYSTEM",       "<",    "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "boolean",      1,      0,      "out",  "arg_1",        "any",  
0,      0,      "in",   "arg_2",        "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    ]
 [ "sys.functions",     "sys",  "<=",   "SYSTEM",       "<=",   "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "boolean",      1,      0,      "out",  "arg_1",        "any",  
0,      0,      "in",   "arg_2",        "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    ]
 [ "sys.functions",     "sys",  "<>",   "SYSTEM",       "!=",   "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "boolean",      1,      0,      "out",  "arg_1",        "any",  
0,      0,      "in",   "arg_2",        "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    ]
@@ -1815,14 +1810,22 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "bit_and",      "SYSTEM",       "and",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "int",  31,     0,      "out",  "arg_1",        "int",  31,     
0,      "in",   "arg_2",        "int",  31,     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,  NULL,   
"res_0",        "smallint",     15,     0,      "out",  "arg_1",        
"smallint",     15,     0,      "in",   "arg_2",        "smallint",     15,     
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,  NULL,   
"res_0",        "tinyint",      7,      0,      "out",  "arg_1",        
"tinyint",      7,      0,      "in",   "arg_2",        "tinyint",      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",  "bit_and",      "SYSTEM",       "create 
function bit_and(ip1 inet4, ip2 inet4) returns inet4 external name 
\"calc\".\"and\";",  "calc", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "inet4",        0,      0,      "out",  
"ip1",  "inet4",        0,      0,      "in",   "ip2",  "inet4",        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",  "bit_and",      "SYSTEM",       "create 
function bit_and(ip1 inet6, ip2 inet6) returns inet6 external name 
\"calc\".\"and\";",  "calc", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "inet6",        0,      0,      "out",  
"ip1",  "inet6",        0,      0,      "in",   "ip2",  "inet6",        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",  "bit_not",      "SYSTEM",       "create 
function bit_not(ip1 inet4) returns inet4 external name \"calc\".\"not\";",     
"calc", "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "inet4",        0,      0,      "out",  "ip1",  "inet4",        
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",  "bit_not",      "SYSTEM",       "create 
function bit_not(ip1 inet6) returns inet6 external name \"calc\".\"not\";",     
"calc", "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "inet6",        0,      0,      "out",  "ip1",  "inet6",        
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",  "bit_not",      "SYSTEM",       "not",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "bigint",       63,     0,      "out",  "arg_1",        
"bigint",       63,     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",  "bit_not",      "SYSTEM",       "not",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "int",  31,     0,      "out",  "arg_1",        "int",  31,     
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",  "bit_not",      "SYSTEM",       "not",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "smallint",     15,     0,      "out",  "arg_1",        
"smallint",     15,     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",  "bit_not",      "SYSTEM",       "not",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "tinyint",      7,      0,      "out",  "arg_1",        
"tinyint",      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",  "bit_or",       "SYSTEM",       "create 
function bit_or(ip1 inet4, ip2 inet4) returns inet4 external name 
\"calc\".\"or\";",    "calc", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "inet4",        0,      0,      "out",  
"ip1",  "inet4",        0,      0,      "in",   "ip2",  "inet4",        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",  "bit_or",       "SYSTEM",       "create 
function bit_or(ip1 inet6, ip2 inet6) returns inet6 external name 
\"calc\".\"or\";",    "calc", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "inet6",        0,      0,      "out",  
"ip1",  "inet6",        0,      0,      "in",   "ip2",  "inet6",        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",  "bit_or",       "SYSTEM",       "or",   "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "bigint",       63,     0,      "out",  "arg_1",        
"bigint",       63,     0,      "in",   "arg_2",        "bigint",       63,     
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_or",       "SYSTEM",       "or",   "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "int",  31,     0,      "out",  "arg_1",        "int",  31,     
0,      "in",   "arg_2",        "int",  31,     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_or",       "SYSTEM",       "or",   "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "smallint",     15,     0,      "out",  "arg_1",        
"smallint",     15,     0,      "in",   "arg_2",        "smallint",     15,     
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_or",       "SYSTEM",       "or",   "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "tinyint",      7,      0,      "out",  "arg_1",        
"tinyint",      7,      0,      "in",   "arg_2",        "tinyint",      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",  "bit_xor",      "SYSTEM",       "create 
function bit_xor(ip1 inet4, ip2 inet4) returns inet4 external name 
\"calc\".\"xor\";",  "calc", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "inet4",        0,      0,      "out",  
"ip1",  "inet4",        0,      0,      "in",   "ip2",  "inet4",        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",  "bit_xor",      "SYSTEM",       "create 
function bit_xor(ip1 inet6, ip2 inet6) returns inet6 external name 
\"calc\".\"xor\";",  "calc", "MAL",  "Scalar function",      false,  false,  
false,  true,   NULL,   "result",       "inet6",        0,      0,      "out",  
"ip1",  "inet6",        0,      0,      "in",   "ip2",  "inet6",        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",  "bit_xor",      "SYSTEM",       "xor",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "bigint",       63,     0,      "out",  "arg_1",        
"bigint",       63,     0,      "in",   "arg_2",        "bigint",       63,     
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_xor",      "SYSTEM",       "xor",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "int",  31,     0,      "out",  "arg_1",        "int",  31,     
0,      "in",   "arg_2",        "int",  31,     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_xor",      "SYSTEM",       "xor",  "calc", 
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "smallint",     15,     0,      "out",  "arg_1",        
"smallint",     15,     0,      "in",   "arg_2",        "smallint",     15,     
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    ]
@@ -1845,13 +1848,23 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "check_constraint",     "SYSTEM",       "create 
function sys.check_constraint(sname string, cname string) returns string 
external name sql.\"check\";", "sql",  "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "varchar",      0,      0,      
"out",  "sname",        "varchar",      0,      0,      "in",   "cname",        
"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",  "clearrejects", "SYSTEM",       "create 
procedure sys.clearrejects() external name sql.copy_rejects_clear;",    "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",  "code", "SYSTEM",       "unicode",      "str",  
"Internal C",   "Scalar function",      false,  false,  false,  false,  NULL,   
"res_0",        "varchar",      0,      0,      "out",  "arg_1",        "int",  
31,     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",  "columnsize",   "SYSTEM",       "create 
function sys.columnsize(tpe varchar(1024), count bigint) returns bigint begin 
if tpe in ('tinyint', 'boolean') then return count; end if; if tpe = 'smallint' 
then return 2 * count; end if; if tpe in ('int', 'real', 'date', 'time', 
'timetz', 'sec_interval', 'day_interval', 'month_interval') then return 4 * 
count; end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 
'inet', 'oid') then return 8 * count; end if; if tpe in ('hugeint', 'decimal', 
'uuid', 'mbr') then return 16 * count; end if; if tpe in ('varchar', 'char', 
'clob', 'json', 'url') then return 4 * count; end if; if tpe in ('blob', 
'geometry', 'geometrya') then return 8 * count; end if; return 8 * count; 
end;",      "sql",  "SQL",  "Scalar function",      false,  false,  false,  
true,   NULL,   "result",       "bigint",       63,     0,      "out",  "tpe",  
"varchar",      1024,   0,      "in",   "count",        "bigint",       63,     
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",  "columnsize",   "SYSTEM",       "create 
function sys.columnsize(tpe varchar(1024), count bigint) returns bigint begin 
if tpe in ('tinyint', 'boolean') then return count; end if; if tpe = 'smallint' 
then return 2 * count; end if; if tpe in ('int', 'real', 'date', 'time', 
'timetz', 'sec_interval', 'day_interval', 'month_interval', 'inet4') then 
return 4 * count; end if; if tpe in ('bigint', 'double', 'timestamp', 
'timestamptz', 'inet', 'oid') then return 8 * count; end if; if tpe in 
('hugeint', 'decimal', 'uuid', 'mbr', 'inet6') then return 16 * count; end if; 
if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 4 * count; end 
if; if tpe in ('blob', 'geometry', 'geometrya') then return 8 * count; end if; 
return 8 * count; end;",    "sql",  "SQL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "bigint",       63,     0,      
"out",  "tpe",  "varchar",      1024,   0,      "in",   "count",        
"bigint",       63,     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,  NULL,   
"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 filter 
function sys.contains(x string, y string) external name str.contains;",  "str", 
 "MAL",  "Filter function",      false,  false,  false,  true,   NULL,   "x",   
 "varchar",      0,      0,      "in",   "y",    "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",  "contains",     "SYSTEM",       "create filter 
function sys.contains(x string, y string, icase boolean) external name 
str.contains;",   "str",  "MAL",  "Filter function",      false,  false,  
false,  true,   NULL,   "x",    "varchar",      0,      0,      "in",   "y",    
"varchar",      0,      0,      "in",   "icase",        "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",  "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,   NULL,   "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",  "contains",     "SYSTEM",       "create 
function contains(ip1 inet4, ip2 inet4, netmask tinyint) returns bool external 
name \"inet46\".\"inet4containsinet4\";",        "inet46",       "MAL",  
"Scalar function",      false,  false,  false,  true,   NULL,   "result",       
"boolean",      1,      0,      "out",  "ip1",  "inet4",        0,      0,      
"in",   "ip2",  "inet4",        0,      0,      "in",   "netmask",      
"tinyint",      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    ]
+[ "sys.functions",     "sys",  "contains",     "SYSTEM",       "create 
function contains(ip1 inet4, netmask1 tinyint, ip2 inet4, netmask2 tinyint) 
returns bool external name \"inet46\".\"inet4containsinet4\";",     "inet46",   
    "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "ip1",  "inet4",        
0,      0,      "in",   "netmask1",     "tinyint",      7,      0,      "in",   
"ip2",  "inet4",        0,      0,      "in",   "netmask2",     "tinyint",      
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    ]
+[ "sys.functions",     "sys",  "contains",     "SYSTEM",       "create 
function contains(ip1 inet6, ip2 inet6, netmask smallint) returns bool external 
name \"inet46\".\"inet6containsinet6\";",       "inet46",       "MAL",  "Scalar 
function",      false,  false,  false,  true,   NULL,   "result",       
"boolean",      1,      0,      "out",  "ip1",  "inet6",        0,      0,      
"in",   "ip2",  "inet6",        0,      0,      "in",   "netmask",      
"smallint",     15,     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",  "contains",     "SYSTEM",       "create 
function contains(ip1 inet6, netmask1 smallint, ip2 inet6, netmask2 smallint) 
returns bool external name \"inet46\".\"inet6containsinet6\";",   "inet46",     
  "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "ip1",  "inet6",        
0,      0,      "in",   "netmask1",     "smallint",     15,     0,      "in",   
"ip2",  "inet6",        0,      0,      "in",   "netmask2",     "smallint",     
15,     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",  "contains",     "SYSTEM",       "create 
function sys.contains(x string, y string) returns boolean external name 
str.contains;", "str",  "MAL",  "Scalar function",      false,  false,  false,  
true,   NULL,   "result",       "boolean",      1,      0,      "out",  "x",    
"varchar",      0,      0,      "in",   "y",    "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 sys.contains(x string, y string, icase boolean) returns boolean 
external name str.contains;",  "str",  "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "boolean",      1,      0,      
"out",  "x",    "varchar",      0,      0,      "in",   "y",    "varchar",      
0,      0,      "in",   "icase",        "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    
]
+[ "sys.functions",     "sys",  "containsorequal",      "SYSTEM",       "create 
function containsorequal(ip1 inet4, ip2 inet4, netmask tinyint) returns bool 
external name \"inet46\".\"inet4containsorequalinet4\";",  "inet46",       
"MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "ip1",  "inet4",        
0,      0,      "in",   "ip2",  "inet4",        0,      0,      "in",   
"netmask",      "tinyint",      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    ]
+[ "sys.functions",     "sys",  "containsorequal",      "SYSTEM",       "create 
function containsorequal(ip1 inet4, netmask1 tinyint, ip2 inet4, netmask2 
tinyint) returns bool external name \"inet46\".\"inet4containsorequalinet4\";", 
      "inet46",       "MAL",  "Scalar function",      false,  false,  false,  
true,   NULL,   "result",       "boolean",      1,      0,      "out",  "ip1",  
"inet4",        0,      0,      "in",   "netmask1",     "tinyint",      7,      
0,      "in",   "ip2",  "inet4",        0,      0,      "in",   "netmask2",     
"tinyint",      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    
]
+[ "sys.functions",     "sys",  "containsorequal",      "SYSTEM",       "create 
function containsorequal(ip1 inet6, ip2 inet6, netmask smallint) returns bool 
external name \"inet46\".\"inet6containsorequalinet6\";", "inet46",       
"MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "ip1",  "inet6",        
0,      0,      "in",   "ip2",  "inet6",        0,      0,      "in",   
"netmask",      "smallint",     15,     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",  "containsorequal",      "SYSTEM",       "create 
function containsorequal(ip1 inet6, netmask1 smallint, ip2 inet6, netmask2 
smallint) returns bool external name 
\"inet46\".\"inet6containsorequalinet6\";",     "inet46",       "MAL",  "Scalar 
function",      false,  false,  false,  true,   NULL,   "result",       
"boolean",      1,      0,      "out",  "ip1",  "inet6",        0,      0,      
"in",   "netmask1",     "smallint",     15,     0,      "in",   "ip2",  
"inet6",        0,      0,      "in",   "netmask2",     "smallint",     15,     
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",  "containssymmetric",    "SYSTEM",       "create 
function containssymmetric(ip1 inet4, netmask1 tinyint, ip2 inet4, netmask2 
tinyint) returns bool external name 
\"inet46\".\"inet4containssymmetricinet4\";",   "inet46",       "MAL",  "Scalar 
function",      false,  false,  false,  true,   NULL,   "result",       
"boolean",      1,      0,      "out",  "ip1",  "inet4",        0,      0,      
"in",   "netmask1",     "tinyint",      7,      0,      "in",   "ip2",  
"inet4",        0,      0,      "in",   "netmask2",     "tinyint",      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    ]
+[ "sys.functions",     "sys",  "containssymmetric",    "SYSTEM",       "create 
function containssymmetric(ip1 inet6, netmask1 smallint, ip2 inet6, netmask2 
smallint) returns bool external name 
\"inet46\".\"inet6containssymmetricinet6\";", "inet46",       "MAL",  "Scalar 
function",      false,  false,  false,  true,   NULL,   "result",       
"boolean",      1,      0,      "out",  "ip1",  "inet6",        0,      0,      
"in",   "netmask1",     "smallint",     15,     0,      "in",   "ip2",  
"inet6",        0,      0,      "in",   "netmask2",     "smallint",     15,     
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",  "corr", "SYSTEM",       "create aggregate 
corr(e1 bigint, e2 bigint) returns double external name \"aggr\".\"corr\";",  
"aggr", "MAL",  "Aggregate function",   false,  false,  false,  true,   NULL,   
"result",       "double",       53,     0,      "out",  "e1",   "bigint",       
63,     0,      "in",   "e2",   "bigint",       63,     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,   NULL,   
"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,   
NULL,   "result",       "double",       53,     0,      "out",  "e1",   "int",  
31,     0,      "in",   "e2",   "int",  31,     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    ]
@@ -2195,7 +2208,6 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "ntile",        "SYSTEM",       "ntile",        
"sql",  "Internal C",   "Analytic function",    false,  false,  false,  true,   
NULL,   "res_0",        "tinyint",      7,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   "arg_2",        "tinyint",      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",  "octet_length", "SYSTEM",       "nbytes",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "int",  31,     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,  
NULL,   "res_0",        "int",  31,     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",   false,  false,  false,  true,   NULL,   
"optname",      "varchar",      0,      0,      "out",  "count",        "int",  
31,     0,      "out",  "timing",       "bigint",       63,     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,   NULL,   "name", 
"varchar",      0,      0,      "out",  "def",  "varchar",      0,      0,      
"out",  "status",       "varchar",      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,   NULL,   
"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,   NULL,   "result",       "varchar",      0,      0,      "out",  
"username",     "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    ]
@@ -2285,6 +2297,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "right_shift",  "SYSTEM",       "mbrRight",     
"geom", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"geometry",     0,      0,      "in",   "arg_2",        "geometry",     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",  "right_shift",  "SYSTEM",       "mbrRight",     
"geom", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"mbr",  0,      0,      "in",   "arg_2",        "mbr",  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",  "right_shift_assign",   "SYSTEM",       "create 
function \"right_shift_assign\"(i1 inet, i2 inet) returns boolean external name 
inet.\">>=\";", "inet", "MAL",  "Scalar function",      false,  false,  false,  
true,   NULL,   "result",       "boolean",      1,      0,      "out",  "i1",   
"inet", 0,      0,      "in",   "i2",   "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    ]
+[ "sys.functions",     "sys",  "ripemd160",    "SYSTEM",       "create 
aggregate ripemd160(val string) returns string with order external name 
aggr.ripemd160;",       "aggr", "MAL",  "Aggregate function",   false,  false,  
false,  true,   NULL,   "result",       "varchar",      0,      0,      "out",  
"val",  "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",  "round",        "SYSTEM",       "round",        
"calc", "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "decimal",      2,      0,      "out",  "arg_1",        
"decimal",      2,      0,      "in",   "arg_2",        "tinyint",      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",  "round",        "SYSTEM",       "round",        
"calc", "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "decimal",      4,      0,      "out",  "arg_1",        
"decimal",      4,      0,      "in",   "arg_2",        "tinyint",      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",  "round",        "SYSTEM",       "round",        
"calc", "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "decimal",      9,      0,      "out",  "arg_1",        
"decimal",      9,      0,      "in",   "arg_2",        "tinyint",      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    ]
@@ -2315,6 +2328,11 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "setsessiontimeout",    "SYSTEM",       "create 
procedure sys.setsessiontimeout(\"timeout\" int) external name 
clients.setsessiontimeout;",     "clients",      "MAL",  "Procedure",    true,  
 false,  false,  true,   NULL,   "timeout",      "int",  31,     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",  "setworkerlimit",       "SYSTEM",       "create 
procedure sys.setworkerlimit(\"limit\" int) external name 
clients.setworkerlimit;",     "clients",      "MAL",  "Procedure",    true,   
false,  false,  true,   NULL,   "limit",        "int",  31,     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",  "setworkerlimit",       "SYSTEM",       "create 
procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name 
clients.setworkerlimit;",  "clients",      "MAL",  "Procedure",    true,   
false,  false,  true,   NULL,   "sessionid",    "int",  31,     0,      "in",   
"limit",        "int",  31,     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",  "sha1", "SYSTEM",       "create aggregate 
sha1(val string) returns string with order external name aggr.sha1;", "aggr", 
"MAL",  "Aggregate function",   false,  false,  false,  true,   NULL,   
"result",       "varchar",      0,      0,      "out",  "val",  "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",  "sha224",       "SYSTEM",       "create 
aggregate sha224(val string) returns string with order external name 
aggr.sha224;",     "aggr", "MAL",  "Aggregate function",   false,  false,  
false,  true,   NULL,   "result",       "varchar",      0,      0,      "out",  
"val",  "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",  "sha256",       "SYSTEM",       "create 
aggregate sha256(val string) returns string with order external name 
aggr.sha256;",     "aggr", "MAL",  "Aggregate function",   false,  false,  
false,  true,   NULL,   "result",       "varchar",      0,      0,      "out",  
"val",  "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",  "sha384",       "SYSTEM",       "create 
aggregate sha384(val string) returns string with order external name 
aggr.sha384;",     "aggr", "MAL",  "Aggregate function",   false,  false,  
false,  true,   NULL,   "result",       "varchar",      0,      0,      "out",  
"val",  "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",  "sha512",       "SYSTEM",       "create 
aggregate sha512(val string) returns string with order external name 
aggr.sha512;",     "aggr", "MAL",  "Aggregate function",   false,  false,  
false,  true,   NULL,   "result",       "varchar",      0,      0,      "out",  
"val",  "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",  "shpload",      "SYSTEM",       "create 
procedure shpload(fname string, schemaname string, tablename string) external 
name shp.load;",  "shp",  "MAL",  "Procedure",    false,  false,  false,  true, 
  NULL,   "fname",        "varchar",      0,      0,      "in",   "schemaname", 
  "varchar",      0,      0,      "in",   "tablename",    "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",  "shpload",      "SYSTEM",       "create 
procedure shpload(fname string, tablename string) external name shp.load;",     
"shp",  "MAL",  "Procedure",    false,  false,  false,  true,   NULL,   
"fname",        "varchar",      0,      0,      "in",   "tablename",    
"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",  "shutdown",     "SYSTEM",       "create 
procedure sys.shutdown(delay tinyint) external name sql.shutdown;",     "sql",  
"MAL",  "Procedure",    true,   false,  false,  true,   NULL,   "delay",        
"tinyint",      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    
]
@@ -2807,6 +2825,8 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "timestampdiff_year",   "SYSTEM",       
"timestampdiff_year",   "mtime",        "Internal C",   "Scalar function",      
false,  false,  false,  false,  NULL,   "res_0",        "int",  31,     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",  31,     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",  31,     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",  "to_hex",       "SYSTEM",       "create 
function to_hex(n bigint) returns text external name \"calc\".\"to_hex\";",     
"calc", "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "varchar",      0,      0,      "out",  "n",    "bigint",       
63,     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",  "to_hex",       "SYSTEM",       "create 
function to_hex(n int) returns text external name \"calc\".\"to_hex\";",        
"calc", "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "varchar",      0,      0,      "out",  "n",    "int",  31,     
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",  "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",       63,     
0,      "out",  "stmt", "varchar",      0,      0,      "out",  "event",        
"varchar",      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",  "truncate",     "SYSTEM",       "stringleft",   
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "varchar",      0,      0,      "out",  "arg_1",        
"varchar",      0,      0,      "in",   "arg_2",        "int",  31,     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",  "ucase",        "SYSTEM",       "toUpper",      
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "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    ]
@@ -4426,7 +4446,7 @@ select 'null in fkeys.delete_action', de
 % .%1, .t,     .t,     .s,     .f,     .dt # table_name
 % %1,  systemname,     sqlname,        name,   name,   dependency_type_name # 
name
 % varchar,     varchar,        varchar,        varchar,        varchar,        
varchar # type
-% 21,  4,      4,      4,      18,     4 # length
+% 21,  5,      5,      4,      18,     4 # length
 [ "type used by function",     "json", "json", "json", "filter",       "TYPE"  
]
 [ "type used by function",     "json", "json", "json", "filter",       "TYPE"  
]
 [ "type used by function",     "json", "json", "json", "filter",       "TYPE"  
]
@@ -4442,7 +4462,25 @@ select 'null in fkeys.delete_action', de
 [ "type used by function",     "json", "json", "json", "text", "TYPE"  ]
 [ "type used by function",     "json", "json", "json", "valuearray",   "TYPE"  
]
 [ "type used by function",     "inet", "inet", "sys",  "abbrev",       "TYPE"  
]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"bit_and",      "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"bit_and",      "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"bit_not",      "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"bit_not",      "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"bit_or",       "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"bit_or",       "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"bit_xor",      "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"bit_xor",      "TYPE"  ]
 [ "type used by function",     "inet", "inet", "sys",  "broadcast",    "TYPE"  
]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"contains",     "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"contains",     "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"contains",     "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"contains",     "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"containsorequal",      "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"containsorequal",      "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"containsorequal",      "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"containsorequal",      "TYPE"  ]
+[ "type used by function",     "inet4",        "inet4",        "sys",  
"containssymmetric",    "TYPE"  ]
+[ "type used by function",     "inet6",        "inet6",        "sys",  
"containssymmetric",    "TYPE"  ]
 [ "type used by function",     "url",  "url",  "sys",  "getanchor",    "TYPE"  
]
 [ "type used by function",     "url",  "url",  "sys",  "getbasename",  "TYPE"  
]
 [ "type used by function",     "url",  "url",  "sys",  "getcontext",   "TYPE"  
]
@@ -4700,6 +4738,14 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "analyze",      "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "analyze",      "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "asciify",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_and",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_and",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_not",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_not",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_or",       "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_or",       "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_xor",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "bit_xor",      "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "broadcast",    "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "check_constraint",     "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
@@ -4707,6 +4753,16 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "contains",     "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "containsorequal",      "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "containsorequal",      "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "containsorequal",      "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "containsorequal",      "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "containssymmetric",    "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "containssymmetric",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "corr", "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "corr", "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "corr", "public",       "EXECUTE",      
"monetdb",      0       ]
@@ -4893,6 +4949,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "resume",       "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "right_shift",  "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "right_shift_assign",   "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "ripemd160",    "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "setclientinfo",        "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "setmasklen",   "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "setmemorylimit",       "public",       
"EXECUTE",      "monetdb",      0       ]
@@ -4900,6 +4957,11 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "setquerytimeout",      "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "setsessiontimeout",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "setworkerlimit",       "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "sha1", "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "sha224",       "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "sha256",       "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "sha384",       "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "sha512",       "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "soundex",      "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "sql_datatype", "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "st_area",      "public",       "EXECUTE",      
"monetdb",      0       ]
@@ -5064,6 +5126,8 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "time_to_str",  "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "timestamp_to_str",     "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "timestamp_to_str",     "public",       
"EXECUTE",      "monetdb",      0       ]
+[ "grant on function", "sys",  "to_hex",       "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "to_hex",       "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "tracelog",     "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "unclosed_result_sets", "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "url_extract_host",     "public",       
"EXECUTE",      "monetdb",      0       ]
@@ -5128,6 +5192,8 @@ select 'null in fkeys.delete_action', de
 [ "sys.types", "sys",  "dbl",  "double",       53,     0,      2,      "FLT"   
]
 [ "sys.types", "sys",  "flt",  "real", 24,     0,      2,      "FLT"   ]
 [ "sys.types", "sys",  "inet", "inet", 0,      0,      0,      "EXTERNAL"      
]
+[ "sys.types", "sys",  "inet4",        "inet4",        0,      0,      0,      
"EXTERNAL"      ]
+[ "sys.types", "sys",  "inet6",        "inet6",        0,      0,      0,      
"EXTERNAL"      ]
 [ "sys.types", "sys",  "int",  "decimal",      9,      1,      10,     "DEC"   
]
 [ "sys.types", "sys",  "int",  "int",  31,     1,      2,      "NUM"   ]
 [ "sys.types", "sys",  "int",  "month_interval",       3,      0,      10,     
"MONTH" ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to