Changeset: 2ac331f5e28f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2ac331f5e28f
Modified Files:
sql/test/emptydb/Tests/check.SQL.py
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: default
Log Message:
Use symbolic names, using sys_schema_extensions when possible.
diffs (truncated from 13092 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.SQL.py
b/sql/test/emptydb/Tests/check.SQL.py
--- a/sql/test/emptydb/Tests/check.SQL.py
+++ b/sql/test/emptydb/Tests/check.SQL.py
@@ -67,7 +67,7 @@ create function pcre_replace(origin stri
-- schemas
select name, authorization, owner, system from sys.schemas order by name;
-- _tables
-select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
coalesce(tt.table_type_name, cast(t.type as string)) as type, t.system,
coalesce(ca.action_name, cast(t.commit_action as string)) as commit_action,
coalesce(at.value, cast(t.access as string)) as access from sys._tables t left
outer join sys.schemas s on t.schema_id = s.id left outer join sys.table_types
tt on t.type = tt.table_type_id left outer join (values (0, 'COMMIT'), (1,
'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4, 'ABORT')) as ca (action_id,
action_name) on t.commit_action = ca.action_id left outer join (values (0,
'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at (id, value) on t.access
= at.id order by s.name, t.name;
+select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t left outer join sys.schemas s on t.schema_id =
s.id left outer join sys.table_types tt on t.type = tt.table_type_id left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
-- external functions that don't reference existing MAL function (should be
empty)
@@ -84,12 +84,15 @@ MAXARGS = 16
# columns of the args table we're interested in
args = ['name', 'type', 'type_digits', 'type_scale', 'inout']
-out += r"select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, f.language, ft.type, f.side_effect, f.varres, f.vararg"
+out += r"select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, fl.language_name, ft.function_type_name, f.side_effect, f.varres,
f.vararg"
for i in range(0, MAXARGS):
for a in args[:-1]:
out += ", a%d.%s as %s%d" % (i, a, a, i)
out += ", case a%d.inout when 0 then 'out' when 1 then 'in' end as
inout%d" % (i, i)
-out += " from sys.functions f left outer join sys.schemas s on f.schema_id =
s.id left outer join (values ('function', 1), ('procedure', 2), ('aggregate',
3), ('filter function', 4), ('table function', 5), ('analytic function', 6),
('loader function', 7)) as ft (type, id) on f.type = ft.id"
+out += " from sys.functions f"
+out += " left outer join sys.schemas s on f.schema_id = s.id"
+out += " left outer join sys.function_types as ft on f.type =
ft.function_type_id"
+out += " left outer join sys.function_languages fl on f.language =
fl.language_id"
for i in range(0, MAXARGS):
out += " left outer join sys.args a%d on a%d.func_id = f.id and a%d.number
= %d" % (i, i, i, i)
out += " order by s.name, f.name, query"
@@ -105,30 +108,30 @@ select name, grantor from sys.auths;
-- db_user_info
select u.name, u.fullname, s.name from sys.db_user_info u left outer join
sys.schemas s on u.default_schema = s.id order by u.name;
-- dependencies
-select s1.name, f1.name, s2.name, f2.name, dt.dependency_type_name from
sys.dependency_types dt, sys.dependencies d, sys.functions f1, sys.functions
f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.dependency_type_id
and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and
f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name;
-select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from
sys.dependency_types dt, sys.dependencies d, sys._tables t, sys.schemas s1,
sys.functions f, sys.schemas s2 where d.depend_type = dt.dependency_type_id and
d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id =
s2.id order by s2.name, f.name, s1.name, t.name;
-select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from
sys.dependency_types dt, sys.dependencies d, sys._columns c, sys._tables t,
sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type =
dt.dependency_type_id and d.id = c.id and d.depend_id = f.id and c.table_id =
t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name,
s1.name, t.name, c.name;
-select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependency_types dt, schemas s1, functions f1, schemas s2, _tables t2,
dependencies d where d.depend_type = dt.dependency_type_id and d.id = f1.id and
f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by
s2.name, t2.name, s1.name, f1.name;
-select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependency_types dt, schemas s1, _tables t1, schemas s2, _tables t2,
dependencies d where d.depend_type = dt.dependency_type_id and d.id = t1.id and
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by
s2.name, t2.name, s1.name, t1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name
from sys.dependency_types dt, schemas s1, _tables t1, _columns c1, schemas s2,
_tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id
= c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id =
t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name,
dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables
t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where
d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = k2.id
and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and
t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name,
c1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name,
dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables
t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where
d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = i2.id
and c1.table_id = t1.id and t1.schema_id = s1.id and i2.table_id = t2.id and
t2.schema_id = s2.id order by s2.name, t2.name, i2.name, s1.name, t1.name,
c1.name;
-select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from
sys.dependency_types dt, types t, functions f, schemas s, dependencies d where
d.depend_type = dt.dependency_type_id and d.id = t.id and d.depend_id = f.id
and f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname;
+select s1.name, f1.name, s2.name, f2.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, sys.functions f1, sys.functions f2, sys.schemas s1,
sys.schemas s2 where d.id = f1.id and d.depend_id = f2.id and f1.schema_id =
s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name;
+select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, sys._tables t, sys.schemas s1, sys.functions f,
sys.schemas s2 where d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id
and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name;
+select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, sys._columns c, sys._tables t, sys.schemas s1,
sys.functions f, sys.schemas s2 where d.id = c.id and d.depend_id = f.id and
c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by
s2.name, f.name, s1.name, t.name, c.name;
+select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, schemas s1, functions f1, schemas s2, _tables t2 where
d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id
= s2.id order by s2.name, t2.name, s1.name, f1.name;
+select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where
d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id
= s2.id order by s2.name, t2.name, s1.name, t1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name
from sys.dependencies d left outer join sys.dependency_types dt on
d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1,
schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by
s2.name, t2.name, s1.name, t1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name,
dt.dependency_type_name from sys.dependencies d left outer join
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1,
_tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and
d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and
k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name,
k2.name, s1.name, t1.name, c1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name,
dt.dependency_type_name from sys.dependencies d left outer join
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1,
_tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.id = c1.id and
d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and
i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name,
i2.name, s1.name, t1.name, c1.name;
+select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, types t, functions f, schemas s where d.id = t.id and
d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name,
t.systemname, t.sqlname;
-- idxs
-select t.name, i.name, it.name from sys.idxs i left outer join sys._tables t
on t.id = i.table_id left outer join (values (0, 'hash'), (1, 'join'), (2,
'oph'), (3, 'no'), (4, 'imprints'), (5, 'ordered'), (6, 'new')) as it (id,
name) on i.type = it.id order by t.name, i.name;
+select t.name, i.name, it.index_type_name from sys.idxs i left outer join
sys._tables t on t.id = i.table_id left outer join sys.index_types as it on
i.type = it.index_type_id order by t.name, i.name;
-- keys
-with x as (select k.id as id, t.name as tname, k.name as kname, k.type as
type, k.rkey as rkey, k.action as action from sys.keys k left outer join
sys._tables t on t.id = k.table_id) select x.tname, x.kname, x.type, y.kname,
x.action from x left outer join x y on x.rkey = y.id order by x.tname, x.kname;
+select t.name, k.name, kt.key_type_name, k2.name, k.action from sys.keys k
left outer join sys.keys k2 on k.rkey = k2.id left outer join sys._tables t on
k.table_id = t.id left outer join sys.key_types kt on k.type = kt.key_type_id
order by t.name, k.name;
-- objects
select name, nr from sys.objects order by name, nr;
-- privileges
-- schemas
select s.name, u.name from sys.schemas s, sys.users u where s.id =
u.default_schema order by s.name, u.name;
-- tables
-select t.name, a.name, p.privileges, g.name, p.grantable from sys._tables t,
sys.privileges p left outer join sys.auths g on p.grantor = g.id, sys.auths a
where t.id = p.obj_id and p.auth_id = a.id order by t.name, a.name;
+select t.name, a.name, pc.privilege_code_name, g.name, p.grantable from
sys._tables t, sys.privileges p left outer join sys.auths g on p.grantor = g.id
left outer join sys.privilege_codes pc on p.privileges = pc.privilege_code_id,
sys.auths a where t.id = p.obj_id and p.auth_id = a.id order by t.name, a.name;
-- columns
-select t.name, c.name, a.name, p.privileges, g.name, p.grantable from
sys._tables t, sys._columns c, sys.privileges p left outer join sys.auths g on
p.grantor = g.id, sys.auths a where c.id = p.obj_id and c.table_id = t.id and
p.auth_id = a.id order by t.name, c.name, a.name;
+select t.name, c.name, a.name, pc.privilege_code_name, g.name, p.grantable
from sys._tables t, sys._columns c, sys.privileges p left outer join sys.auths
g on p.grantor = g.id left outer join sys.privilege_codes pc on p.privileges =
pc.privilege_code_id, sys.auths a where c.id = p.obj_id and c.table_id = t.id
and p.auth_id = a.id order by t.name, c.name, a.name;
-- functions
-select f.name, a.name, p.privileges, g.name, p.grantable from sys.functions f,
sys.privileges p left outer join sys.auths g on p.grantor = g.id, sys.auths a
where f.id = p.obj_id and p.auth_id = a.id order by f.name, a.name;
+select f.name, a.name, pc.privilege_code_name, g.name, p.grantable from
sys.functions f, sys.privileges p left outer join sys.auths g on p.grantor =
g.id left outer join sys.privilege_codes pc on p.privileges =
pc.privilege_code_id, sys.auths a where f.id = p.obj_id and p.auth_id = a.id
order by f.name, a.name;
-- sequences
select s.name, q.name, q.start, q.minvalue, q.maxvalue, q.increment,
q.cacheinc, q.cycle from sys.sequences q left outer join sys.schemas s on
q.schema_id = s.id order by s.name, q.name;
-- statistics (expect empty)
@@ -138,9 +141,9 @@ select count(*) from sys.storagemodelinp
-- systemfunctions
select f.name from sys.systemfunctions s left outer join sys.functions f on
s.function_id = f.id order by f.name;
-- triggers
-select t.name, g.name, g.time, g.orientation, g.event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
+select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-- types
-select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass
from sys.types t left outer join sys.schemas s on s.id = t.schema_id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
+select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
-- user_role
select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur
where a1.id = ur.login_id and a2.id = ur.role_id order by a1.name, a2.name;
-- keywords
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -1225,42 +1225,42 @@ create function pcre_replace(origin stri
-- schemas
select name, authorization, owner, system from sys.schemas order by name;
-- _tables
-select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
coalesce(tt.table_type_name, cast(t.type as string)) as type, t.system,
coalesce(ca.action_name, cast(t.commit_action as string)) as commit_action,
coalesce(at.value, cast(t.access as string)) as access from sys._tables t left
outer join sys.schemas s on t.schema_id = s.id left outer join sys.table_types
tt on t.type = tt.table_type_id left outer join (values (0, 'COMMIT'), (1,
'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4, 'ABORT')) as ca (action_id,
action_name) on t.commit_action = ca.action_id left outer join (values (0,
'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at (id, value) on t.access
= at.id order by s.name, t.name;
+select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t left outer join sys.schemas s on t.schema_id =
s.id left outer join sys.table_types tt on t.type = tt.table_type_id left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
-- _columns
select t.name, c.name, c.type, c.type_digits, c.type_scale, c."default",
c."null", c.number, c.storage from sys._tables t, sys._columns c where t.id =
c.table_id order by t.name, c.number;
-- external functions that don't reference existing MAL function (should be
empty)
with x(name,func,schema_id) as (select name, split_part(func, ' external name
', 2), schema_id from sys.functions where func like '% external name %' union
select name, split_part(func, ' EXTERNAL NAME ', 2), schema_id from
sys.functions where func like '% EXTERNAL NAME %'), y(name,func,schema_id) as
(select name, trim(split_part(func, ';', 1)), schema_id from x), z(name, mod,
func, schema_id) as (select name, trim(split_part(func, '.', 1), '"'),
trim(split_part(func, '.', 2), '"'), schema_id from y) select s.name, z.name,
z.mod, z.func from z, sys.schemas s where z.mod || '.' || z.func not in (select
m.module || '.' || m."function" from sys.malfunctions() m) and z.schema_id =
s.id;
-- args
-select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, f.language, ft.type, f.side_effect, f.varres, f.vararg, a0.name as
name0, a0.type as type0, a0.type_digits as type_digits0, a0.type_scale as
type_scale0, case a0.inout when 0 then 'out' when 1 then 'in' end as inout0,
a1.name as name1, a1.type as type1, a1.type_digits as type_digits1,
a1.type_scale as type_scale1, case a1.inout when 0 then 'out' when 1 then 'in'
end as inout1, a2.name as name2, a2.type as type2, a2.type_digits as
type_digits2, a2.type_scale as type_scale2, case a2.inout when 0 then 'out'
when 1 then 'in' end as inout2, a3.name as name3, a3.type as type3,
a3.type_digits as type_digits3, a3.type_scale as type_scale3, case a3.inout
when 0 then 'out' when 1 then 'in' end as inout3, a4.name as name4, a4.type as
type4, a4.type_digits as type_digits4, a4.type_scale as type_scale4, case
a4.inou
t when 0 then 'out' when 1 then 'in' end as inout4, a5.name as name5, a5.type
as type5, a5.type_digits as type_digits5, a5.type_scale as type_scale5, case
a5.inout when 0 then 'out' when 1 then 'in' end as inout5, a6.name as name6,
a6.type as type6, a6.type_digits as type_digits6, a6.type_scale as type_scale6,
case a6.inout when 0 then 'out' when 1 then 'in' end as inout6, a7.name as
name7, a7.type as type7, a7.type_digits as type_digits7, a7.type_scale as
type_scale7, case a7.inout when 0 then 'out' when 1 then 'in' end as inout7,
a8.name as name8, a8.type as type8, a8.type_digits as type_digits8,
a8.type_scale as type_scale8, case a8.inout when 0 then 'out' when 1 then 'in'
end as inout8, a9.name as name9, a9.type as type9, a9.type_digits as
type_digits9, a9.type_scale as type_scale9, case a9.inout when 0 then 'out'
when 1 then 'in' end as inout9, a10.name as name10, a10.type as type10,
a10.type_digits as type_digits10, a10.type_scale as type_scale10, case
a10.inout when 0 then 'o
ut' when 1 then 'in' end as inout10, a11.name as name11, a11.type as type11,
a11.type_digits as type_digits11, a11.type_scale as type_scale11, case
a11.inout when 0 then 'out' when 1 then 'in' end as inout11, a12.name as
name12, a12.type as type12, a12.type_digits as type_digits12, a12.type_scale as
type_scale12, case a12.inout when 0 then 'out' when 1 then 'in' end as inout12,
a13.name as name13, a13.type as type13, a13.type_digits as type_digits13,
a13.type_scale as type_scale13, case a13.inout when 0 then 'out' when 1 then
'in' end as inout13, a14.name as name14, a14.type as type14, a14.type_digits as
type_digits14, a14.type_scale as type_scale14, case a14.inout when 0 then 'out'
when 1 then 'in' end as inout14, a15.name as name15, a15.type as type15,
a15.type_digits as type_digits15, a15.type_scale as type_scale15, case
a15.inout when 0 then 'out' when 1 then 'in' end as inout15 from sys.functions
f left outer join sys.schemas s on f.schema_id = s.id left outer join (values
('fu
nction', 1), ('procedure', 2), ('aggregate', 3), ('filter function', 4),
('table function', 5), ('analytic function', 6), ('loader function', 7)) as ft
(type, id) on f.type = ft.id left outer join sys.args a0 on a0.func_id = f.id
and a0.number = 0 left outer join sys.args a1 on a1.func_id = f.id and
a1.number = 1 left outer join sys.args a2 on a2.func_id = f.id and a2.number =
2 left outer join sys.args a3 on a3.func_id = f.id and a3.number = 3 left outer
join sys.args a4 on a4.func_id = f.id and a4.number = 4 left outer join
sys.args a5 on a5.func_id = f.id and a5.number = 5 left outer join sys.args a6
on a6.func_id = f.id and a6.number = 6 left outer join sys.args a7 on
a7.func_id = f.id and a7.number = 7 left outer join sys.args a8 on a8.func_id =
f.id and a8.number = 8 left outer join sys.args a9 on a9.func_id = f.id and
a9.number = 9 left outer join sys.args a10 on a10.func_id = f.id and a10.number
= 10 left outer join sys.args a11 on a11.func_id = f.id and a11.number = 11 left
outer join sys.args a12 on a12.func_id = f.id and a12.number = 12 left outer
join sys.args a13 on a13.func_id = f.id and a13.number = 13 left outer join
sys.args a14 on a14.func_id = f.id and a14.number = 14 left outer join sys.args
a15 on a15.func_id = f.id and a15.number = 15 order by s.name, f.name, query,
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, ty
pe_scale13, inout13, name14, type14, type_digits14, type_scale14, inout14,
name15, type15, type_digits15, type_scale15, inout15;
+select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, fl.language_name, ft.function_type_name, f.side_effect, f.varres,
f.vararg, a0.name as name0, a0.type as type0, a0.type_digits as type_digits0,
a0.type_scale as type_scale0, case a0.inout when 0 then 'out' when 1 then 'in'
end as inout0, a1.name as name1, a1.type as type1, a1.type_digits as
type_digits1, a1.type_scale as type_scale1, case a1.inout when 0 then 'out'
when 1 then 'in' end as inout1, a2.name as name2, a2.type as type2,
a2.type_digits as type_digits2, a2.type_scale as type_scale2, case a2.inout
when 0 then 'out' when 1 then 'in' end as inout2, a3.name as name3, a3.type as
type3, a3.type_digits as type_digits3, a3.type_scale as type_scale3, case
a3.inout when 0 then 'out' when 1 then 'in' end as inout3, a4.name as name4,
a4.type as type4, a4.type_digits as type_digits4, a4.type_scale as type_
scale4, case a4.inout when 0 then 'out' when 1 then 'in' end as inout4,
a5.name as name5, a5.type as type5, a5.type_digits as type_digits5,
a5.type_scale as type_scale5, case a5.inout when 0 then 'out' when 1 then 'in'
end as inout5, a6.name as name6, a6.type as type6, a6.type_digits as
type_digits6, a6.type_scale as type_scale6, case a6.inout when 0 then 'out'
when 1 then 'in' end as inout6, a7.name as name7, a7.type as type7,
a7.type_digits as type_digits7, a7.type_scale as type_scale7, case a7.inout
when 0 then 'out' when 1 then 'in' end as inout7, a8.name as name8, a8.type as
type8, a8.type_digits as type_digits8, a8.type_scale as type_scale8, case
a8.inout when 0 then 'out' when 1 then 'in' end as inout8, a9.name as name9,
a9.type as type9, a9.type_digits as type_digits9, a9.type_scale as type_scale9,
case a9.inout when 0 then 'out' when 1 then 'in' end as inout9, a10.name as
name10, a10.type as type10, a10.type_digits as type_digits10, a10.type_scale as
type_scale10, case a10.
inout when 0 then 'out' when 1 then 'in' end as inout10, a11.name as name11,
a11.type as type11, a11.type_digits as type_digits11, a11.type_scale as
type_scale11, case a11.inout when 0 then 'out' when 1 then 'in' end as inout11,
a12.name as name12, a12.type as type12, a12.type_digits as type_digits12,
a12.type_scale as type_scale12, case a12.inout when 0 then 'out' when 1 then
'in' end as inout12, a13.name as name13, a13.type as type13, a13.type_digits as
type_digits13, a13.type_scale as type_scale13, case a13.inout when 0 then 'out'
when 1 then 'in' end as inout13, a14.name as name14, a14.type as type14,
a14.type_digits as type_digits14, a14.type_scale as type_scale14, case
a14.inout when 0 then 'out' when 1 then 'in' end as inout14, a15.name as
name15, a15.type as type15, a15.type_digits as type_digits15, a15.type_scale as
type_scale15, case a15.inout when 0 then 'out' when 1 then 'in' end as inout15
from sys.functions f left outer join sys.schemas s on f.schema_id = s.id left
out
er join sys.function_types as ft on f.type = ft.function_type_id left outer
join sys.function_languages fl on f.language = fl.language_id left outer join
sys.args a0 on a0.func_id = f.id and a0.number = 0 left outer join sys.args a1
on a1.func_id = f.id and a1.number = 1 left outer join sys.args a2 on
a2.func_id = f.id and a2.number = 2 left outer join sys.args a3 on a3.func_id =
f.id and a3.number = 3 left outer join sys.args a4 on a4.func_id = f.id and
a4.number = 4 left outer join sys.args a5 on a5.func_id = f.id and a5.number =
5 left outer join sys.args a6 on a6.func_id = f.id and a6.number = 6 left outer
join sys.args a7 on a7.func_id = f.id and a7.number = 7 left outer join
sys.args a8 on a8.func_id = f.id and a8.number = 8 left outer join sys.args a9
on a9.func_id = f.id and a9.number = 9 left outer join sys.args a10 on
a10.func_id = f.id and a10.number = 10 left outer join sys.args a11 on
a11.func_id = f.id and a11.number = 11 left outer join sys.args a12 on
a12.func_id = f
.id and a12.number = 12 left outer join sys.args a13 on a13.func_id = f.id and
a13.number = 13 left outer join sys.args a14 on a14.func_id = f.id and
a14.number = 14 left outer join sys.args a15 on a15.func_id = f.id and
a15.number = 15 order by s.name, f.name, query, 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_d
igits14, type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15;
-- auths
select name, grantor from sys.auths;
-- db_user_info
select u.name, u.fullname, s.name from sys.db_user_info u left outer join
sys.schemas s on u.default_schema = s.id order by u.name;
-- dependencies
-select s1.name, f1.name, s2.name, f2.name, dt.dependency_type_name from
sys.dependency_types dt, sys.dependencies d, sys.functions f1, sys.functions
f2, sys.schemas s1, sys.schemas s2 where d.depend_type = dt.dependency_type_id
and d.id = f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and
f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name;
-select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from
sys.dependency_types dt, sys.dependencies d, sys._tables t, sys.schemas s1,
sys.functions f, sys.schemas s2 where d.depend_type = dt.dependency_type_id and
d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id =
s2.id order by s2.name, f.name, s1.name, t.name;
-select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from
sys.dependency_types dt, sys.dependencies d, sys._columns c, sys._tables t,
sys.schemas s1, sys.functions f, sys.schemas s2 where d.depend_type =
dt.dependency_type_id and d.id = c.id and d.depend_id = f.id and c.table_id =
t.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name,
s1.name, t.name, c.name;
-select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependency_types dt, schemas s1, functions f1, schemas s2, _tables t2,
dependencies d where d.depend_type = dt.dependency_type_id and d.id = f1.id and
f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by
s2.name, t2.name, s1.name, f1.name;
-select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependency_types dt, schemas s1, _tables t1, schemas s2, _tables t2,
dependencies d where d.depend_type = dt.dependency_type_id and d.id = t1.id and
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by
s2.name, t2.name, s1.name, t1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name
from sys.dependency_types dt, schemas s1, _tables t1, _columns c1, schemas s2,
_tables t2, dependencies d where d.depend_type = dt.dependency_type_id and d.id
= c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id =
t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name,
dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables
t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where
d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = k2.id
and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and
t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name,
c1.name;
-select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name,
dt.dependency_type_name from sys.dependency_types dt, dependencies d, _tables
t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where
d.depend_type = dt.dependency_type_id and d.id = c1.id and d.depend_id = i2.id
and c1.table_id = t1.id and t1.schema_id = s1.id and i2.table_id = t2.id and
t2.schema_id = s2.id order by s2.name, t2.name, i2.name, s1.name, t1.name,
c1.name;
-select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from
sys.dependency_types dt, types t, functions f, schemas s, dependencies d where
d.depend_type = dt.dependency_type_id and d.id = t.id and d.depend_id = f.id
and f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname;
+select s1.name, f1.name, s2.name, f2.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, sys.functions f1, sys.functions f2, sys.schemas s1,
sys.schemas s2 where d.id = f1.id and d.depend_id = f2.id and f1.schema_id =
s1.id and f2.schema_id = s2.id order by s2.name, f2.name, s1.name, f1.name;
+select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, sys._tables t, sys.schemas s1, sys.functions f,
sys.schemas s2 where d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id
and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name;
+select s1.name, t.name, c.name, s2.name, f.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, sys._columns c, sys._tables t, sys.schemas s1,
sys.functions f, sys.schemas s2 where d.id = c.id and d.depend_id = f.id and
c.table_id = t.id and t.schema_id = s1.id and f.schema_id = s2.id order by
s2.name, f.name, s1.name, t.name, c.name;
+select s1.name, f1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, schemas s1, functions f1, schemas s2, _tables t2 where
d.id = f1.id and f1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id
= s2.id order by s2.name, t2.name, s1.name, f1.name;
+select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where
d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id
= s2.id order by s2.name, t2.name, s1.name, t1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name
from sys.dependencies d left outer join sys.dependency_types dt on
d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1,
schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and
t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by
s2.name, t2.name, s1.name, t1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name,
dt.dependency_type_name from sys.dependencies d left outer join
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1,
_tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and
d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and
k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name,
k2.name, s1.name, t1.name, c1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name,
dt.dependency_type_name from sys.dependencies d left outer join
sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1,
_tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where d.id = c1.id and
d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id = s1.id and
i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name,
i2.name, s1.name, t1.name, c1.name;
+select t.systemname, t.sqlname, s.name, f.name, dt.dependency_type_name from
sys.dependencies d left outer join sys.dependency_types dt on d.depend_type =
dt.dependency_type_id, types t, functions f, schemas s where d.id = t.id and
d.depend_id = f.id and f.schema_id = s.id order by s.name, f.name,
t.systemname, t.sqlname;
-- idxs
-select t.name, i.name, it.name from sys.idxs i left outer join sys._tables t
on t.id = i.table_id left outer join (values (0, 'hash'), (1, 'join'), (2,
'oph'), (3, 'no'), (4, 'imprints'), (5, 'ordered'), (6, 'new')) as it (id,
name) on i.type = it.id order by t.name, i.name;
+select t.name, i.name, it.index_type_name from sys.idxs i left outer join
sys._tables t on t.id = i.table_id left outer join sys.index_types as it on
i.type = it.index_type_id order by t.name, i.name;
-- keys
-with x as (select k.id as id, t.name as tname, k.name as kname, k.type as
type, k.rkey as rkey, k.action as action from sys.keys k left outer join
sys._tables t on t.id = k.table_id) select x.tname, x.kname, x.type, y.kname,
x.action from x left outer join x y on x.rkey = y.id order by x.tname, x.kname;
+select t.name, k.name, kt.key_type_name, k2.name, k.action from sys.keys k
left outer join sys.keys k2 on k.rkey = k2.id left outer join sys._tables t on
k.table_id = t.id left outer join sys.key_types kt on k.type = kt.key_type_id
order by t.name, k.name;
-- objects
select name, nr from sys.objects order by name, nr;
-- privileges
-- schemas
select s.name, u.name from sys.schemas s, sys.users u where s.id =
u.default_schema order by s.name, u.name;
-- tables
-select t.name, a.name, p.privileges, g.name, p.grantable from sys._tables t,
sys.privileges p left outer join sys.auths g on p.grantor = g.id, sys.auths a
where t.id = p.obj_id and p.auth_id = a.id order by t.name, a.name;
+select t.name, a.name, pc.privilege_code_name, g.name, p.grantable from
sys._tables t, sys.privileges p left outer join sys.auths g on p.grantor = g.id
left outer join sys.privilege_codes pc on p.privileges = pc.privilege_code_id,
sys.auths a where t.id = p.obj_id and p.auth_id = a.id order by t.name, a.name;
-- columns
-select t.name, c.name, a.name, p.privileges, g.name, p.grantable from
sys._tables t, sys._columns c, sys.privileges p left outer join sys.auths g on
p.grantor = g.id, sys.auths a where c.id = p.obj_id and c.table_id = t.id and
p.auth_id = a.id order by t.name, c.name, a.name;
+select t.name, c.name, a.name, pc.privilege_code_name, g.name, p.grantable
from sys._tables t, sys._columns c, sys.privileges p left outer join sys.auths
g on p.grantor = g.id left outer join sys.privilege_codes pc on p.privileges =
pc.privilege_code_id, sys.auths a where c.id = p.obj_id and c.table_id = t.id
and p.auth_id = a.id order by t.name, c.name, a.name;
-- functions
-select f.name, a.name, p.privileges, g.name, p.grantable from sys.functions f,
sys.privileges p left outer join sys.auths g on p.grantor = g.id, sys.auths a
where f.id = p.obj_id and p.auth_id = a.id order by f.name, a.name;
+select f.name, a.name, pc.privilege_code_name, g.name, p.grantable from
sys.functions f, sys.privileges p left outer join sys.auths g on p.grantor =
g.id left outer join sys.privilege_codes pc on p.privileges =
pc.privilege_code_id, sys.auths a where f.id = p.obj_id and p.auth_id = a.id
order by f.name, a.name;
-- sequences
select s.name, q.name, q.start, q.minvalue, q.maxvalue, q.increment,
q.cacheinc, q.cycle from sys.sequences q left outer join sys.schemas s on
q.schema_id = s.id order by s.name, q.name;
-- statistics (expect empty)
@@ -1270,9 +1270,9 @@ select count(*) from sys.storagemodelinp
-- systemfunctions
select f.name from sys.systemfunctions s left outer join sys.functions f on
s.function_id = f.id order by f.name;
-- triggers
-select t.name, g.name, g.time, g.orientation, g.event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
+select t.name, g.name, case g.time when 0 then 'BEFORE' when 1 then 'AFTER'
when 2 then 'INSTEAD OF' end as time, case g.orientation when 0 then 'ROW' when
1 then 'STATEMENT' end as orientation, case g.event when 0 then 'insert' when 1
then 'DELETE' when 2 then 'UPDATE' end as event, g.old_name, g.new_name,
g.condition, g.statement from sys.triggers g left outer join sys._tables t on
g.table_id = t.id order by t.name, g.name;
-- types
-select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass
from sys.types t left outer join sys.schemas s on s.id = t.schema_id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
+select s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, et.value
as eclass from sys.types t left outer join sys.schemas s on s.id = t.schema_id
left outer join (values (0, 'ANY'), (1, 'TABLE'), (2, 'BIT'), (3, 'CHAR'), (4,
'STRING'), (5, 'BLOB'), (6, 'POS'), (7, 'NUM'), (8, 'MONTH'), (9, 'SEC'), (10,
'DEC'), (11, 'FLT'), (12, 'TIME'), (13, 'DATE'), (14, 'TIMESTAMP'), (15,
'GEOM'), (16, 'EXTERNAL')) as et (id, value) on t.eclass = et.id order by
s.name, t.systemname, t.sqlname, t.digits, t.scale, t.radix, t.eclass;
-- user_role
select a1.name, a2.name from sys.auths a1, sys.auths a2, sys.user_role ur
where a1.id = ur.login_id and a2.id = ur.role_id order by a1.name, a2.name;
-- keywords
@@ -1294,11 +1294,11 @@ drop function pcre_replace(string, strin
[ "profiler", 3, 3, true ]
[ "sys", 2, 3, true ]
[ "tmp", 2, 3, true ]
-#select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
coalesce(tt.table_type_name, cast(t.type as string)) as type, t.system,
coalesce(ca.action_name, cast(t.commit_action as string)) as commit_action,
coalesce(at.value, cast(t.access as string)) as access from sys._tables t left
outer join sys.schemas s on t.schema_id = s.id left outer join sys.table_types
tt on t.type = tt.table_type_id left outer join (values (0, 'COMMIT'), (1,
'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4, 'ABORT')) as ca (action_id,
action_name) on t.commit_action = ca.action_id left outer join (values (0,
'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at (id, value) on t.access
= at.id order by s.name, t.name;
-% .s, .t, .L10, .L13, .t, .L17, .L22 # table_name
+#select s.name, t.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(t.query, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
tt.table_type_name as type, t.system, ca.action_name as commit_action, at.value
as access from sys._tables t left outer join sys.schemas s on t.schema_id =
s.id left outer join sys.table_types tt on t.type = tt.table_type_id left outer
join (values (0, 'COMMIT'), (1, 'DELETE'), (2, 'PRESERVE'), (3, 'DROP'), (4,
'ABORT')) as ca (action_id, action_name) on t.commit_action = ca.action_id left
outer join (values (0, 'WRITABLE'), (1, 'READONLY'), (2, 'APPENDONLY')) as at
(id, value) on t.access = at.id order by s.name, t.name;
+% .s, .t, .L10, .L12, .t, .L15, .L17 # table_name
% name, name, query, type, system, commit_action, access # name
-% varchar, varchar, varchar, clob, boolean, clob,
clob # type
-% 3, 29, 1545, 5, 5, 8, 8 # length
+% varchar, varchar, varchar, varchar, boolean,
char, char # type
+% 3, 29, 1545, 5, 5, 8, 10 # length
[ "bam", "export", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
[ "bam", "files", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
[ "bam", "pg", NULL, "TABLE", true, "COMMIT",
"WRITABLE" ]
@@ -1777,1588 +1777,1588 @@ drop function pcre_replace(string, strin
% name, name, mod, func # name
% varchar, varchar, varchar, varchar # type
% 0, 0, 0, 0 # length
-#select s.name, f.name,
replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func, '--.*\n', '',
''), '[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )', ')') as query,
f.mod, f.language, ft.type, f.side_effect, f.varres, f.vararg, a0.name as
name0, a0.type as type0, a0.type_digits as type_digits0, a0.type_scale as
type_scale0, case a0.inout when 0 then 'out' when 1 then 'in' end as inout0,
a1.name as name1, a1.type as type1, a1.type_digits as type_digits1,
a1.type_scale as type_scale1, case a1.inout when 0 then 'out' when 1 then 'in'
end as inout1, a2.name as name2, a2.type as type2, a2.type_digits as
type_digits2, a2.type_scale as type_scale2, case a2.inout when 0 then 'out'
when 1 then 'in' end as inout2, a3.name as name3, a3.type as type3,
a3.type_digits as type_digits3, a3.type_scale as type_scale3, case a3.inout
when 0 then 'out' when 1 then 'in' end as inout3, a4.name as name4, a4.type as
type4, a4.type_digits as type_digits4, a4.type_scale as type_scale4, case a4.ino
ut when 0 then 'out' when 1 then 'in' end as inout4, a5.name as name5, a5.type
as type5, a5.type_digits as type_digits5, a5.type_scale as type_scale5, case
a5.inout when 0 then 'out' when 1 then 'in' end as inout5, a6.name as name6,
a6.type as type6, a6.type_digits as type_digits6, a6.type_scale as type_scale6,
case a6.inout when 0 then 'out' when 1 then 'in' end as inout6, a7.name as
name7, a7.type as type7, a7.type_digits as type_digits7, a7.type_scale as
type_scale7, case a7.inout when 0 then 'out' when 1 then 'in' end as inout7,
a8.name as name8, a8.type as type8, a8.type_digits as type_digits8,
a8.type_scale as type_scale8, case a8.inout when 0 then 'out' when 1 then 'in'
end as inout8, a9.name as name9, a9.type as type9, a9.type_digits as
type_digits9, a9.type_scale as type_scale9, case a9.inout when 0 then 'out'
when 1 then 'in' end as inout9, a10.name as name10, a10.type as type10,
a10.type_digits as type_digits10, a10.type_scale as type_scale10, case
a10.inout when 0 then '
out' when 1 then 'in' end as inout10, a11.name as name11, a11.type as type11,
a11.type_digits as type_digits11, a11.type_scale as type_scale11, case
a11.inout when 0 then 'out' when 1 then 'in' end as inout11, a12.name as
name12, a12.type as type12, a12.type_digits as type_digits12, a12.type_scale as
type_scale12, case a12.inout when 0 then 'out' when 1 then 'in' end as inout12,
a13.name as name13, a13.type as type13, a13.type_digits as type_digits13,
a13.type_scale as type_scale13, case a13.inout when 0 then 'out' when 1 then
'in' end as inout13, a14.name as name14, a14.type as type14, a14.type_digits as
type_digits14, a14.type_scale as type_scale14, case a14.inout when 0 then 'out'
when 1 then 'in' end as inout14, a15.name as name15, a15.type as type15,
a15.type_digits as type_digits15, a15.type_scale as type_scale15, case
a15.inout when 0 then 'out' when 1 then 'in' end as inout15 from sys.functions
f left outer join sys.schemas s on f.schema_id = s.id left outer join (values
('f
unction', 1), ('procedure', 2), ('aggregate', 3), ('filter function', 4),
('table function', 5), ('analytic function', 6), ('loader function', 7)) as ft
(type, id) on f.type = ft.id left outer join sys.args a0 on a0.func_id = f.id
and a0.number = 0 left outer join sys.args a1 on a1.func_id = f.id and
a1.number = 1 left outer join sys.args a2 on a2.func_id = f.id and a2.number =
2 left outer join sys.args a3 on a3.func_id = f.id and a3.number = 3 left outer
join sys.args a4 on a4.func_id = f.id and a4.number = 4 left outer join
sys.args a5 on a5.func_id = f.id and a5.number = 5 left outer join sys.args a6
on a6.func_id = f.id and a6.number = 6 left outer join sys.args a7 on
a7.func_id = f.id and a7.number = 7 left outer join sys.args a8 on a8.func_id =
f.id and a8.number = 8 left outer join sys.args a9 on a9.func_id = f.id and
a9.number = 9 left outer join sys.args a10 on a10.func_id = f.id and a10.number
= 10 left outer join sys.args a11 on a11.func_id = f.id and a11.number = 11 lef
t outer join sys.args a12 on a12.func_id = f.id and a12.number = 12 left outer
join sys.args a13 on a13.func_id = f.id and a13.number = 13 left outer join
sys.args a14 on a14.func_id = f.id and a14.number = 14 left outer join sys.args
a15 on a15.func_id = f.id and a15.number = 15 order by s.name, f.name, query,
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, t
ype_scale13, inout13, name14, type14, type_digits14, type_scale14, inout14,
name15, type15, type_digits15, type_scale15, inout15;
-% .s, .f, .L6, .f, .f, .ft, .f, .f, .f, .L16,
.L20, .L22, .L24, .L26, .L30, .L32, .L34, .L36, .L40, .L42,
.L44, .L46, .L50, .L52, .L54, .L56, .L60, .L62, .L64, .L66,
.L70, .L72, .L74, .L76, .L100, .L102, .L104, .L106, .L110, .L112,
.L114, .L116, .L120, .L122, .L124, .L126, .L130, .L132, .L134, .L136,
.L140, .L142, .L144, .L146, .L150, .L152, .L154, .L156, .L160, .L162,
.L164, .L166, .L170, .L172, .L174, .L176, .L200, .L202, .L204, .L206,
.L210, .L212, .L214, .L216, .L220, .L222, .L224, .L226, .L230, .L232,
.L234, .L236, .L240, .L242, .L244, .L246, .L250, .L252, .L254 #
table_name
-% name, name, query, mod, language, type, side_effect,
varres, vararg, 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, int, char,
boolean, boolean, boolean, varchar, varchar,
int, int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char # type
-% 8, 35, 831, 9, 1, 17, 5, 5, 5, 11,
14, 4, 1, 3, 16, 14, 5, 1, 3, 16,
14, 2, 1, 3, 27, 12, 2, 1, 3, 12,
7, 2, 1, 3, 10, 7, 2, 1, 3, 8,
7, 2, 1, 3, 9, 6, 2, 1, 3, 10,
6, 2, 1, 3, 8, 7, 2, 1, 3, 9,
7, 2, 1, 3, 6, 7, 2, 1, 3, 8,
6, 2, 1, 3, 6, 7, 1, 1, 3, 9,
7, 1, 1, 3, 6, 7, 1, 1, 3 # length
-[ "bam", "bam_drop_file", "create procedure
bam.bam_drop_file(file_id bigint, dbschema smallint) external name
bam.bam_drop_file;", "bam", 1, "procedure", true, false,
false, "file_id", "bigint", 64, 0, "in", "dbschema",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "bam_export", "create procedure bam.bam_export(output_path
string) external name bam.bam_export;", "bam", 1, "procedure",
true, false, false, "output_path", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "bam", "bam_flag", "create function bam.bam_flag(flag smallint,
name string) returns boolean external name bam.bam_flag;", "bam", 1,
"function", false, false, false, "result", "boolean", 1,
0, "out", "flag", "smallint", 16, 0, "in", "name", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "bam_loader_file", "create procedure
bam.bam_loader_file(bam_file string, dbschema smallint) external name
bam.bam_loader_file;", "bam", 1, "procedure", true, false, false,
"bam_file", "clob", 0, 0, "in", "dbschema", "smallint",
16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "bam", "bam_loader_files", "create procedure
bam.bam_loader_files(bam_files string, dbschema smallint) external name
bam.bam_loader_files;", "bam", 1, "procedure", true, false,
false, "bam_files", "clob", 0, 0, "in", "dbschema",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "bam_loader_repos", "create procedure
bam.bam_loader_repos(bam_repos string, dbschema smallint) external name
bam.bam_loader_repos;", "bam", 1, "procedure", true, false,
false, "bam_repos", "clob", 0, 0, "in", "dbschema",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "reverse_qual", "create function bam.reverse_qual(qual string)
returns string external name bam.reverse_qual;", "bam", 1, "function",
false, false, false, "result", "clob", 0, 0, "out",
"qual", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "reverse_seq", "create function bam.reverse_seq(seq string)
returns string external name bam.reverse_seq;", "bam", 1, "function",
false, false, false, "result", "clob", 0, 0, "out",
"seq", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "sam_export", "create procedure bam.sam_export(output_path
string) external name bam.sam_export;", "bam", 1, "procedure",
true, false, false, "output_path", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "bam", "seq_char", "create function bam.seq_char(ref_pos int,
alg_seq string, alg_pos int, alg_cigar string) returns char(1) external name
bam.seq_char;", "bam", 1, "function", false, false, false,
"result", "char", 1, 0, "out", "ref_pos", "int", 32,
0, "in", "alg_seq", "clob", 0, 0, "in", "alg_pos",
"int", 32, 0, "in", "alg_cigar", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "bam", "seq_length", "create function bam.seq_length(cigar string)
returns int external name bam.seq_length;", "bam", 1, "function",
false, false, false, "result", "int", 32, 0, "out",
"cigar", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "filter", "create function json.filter(js json, name
bigint) returns json external name json.filter;", "json", 1,
"function", false, false, false, "result", "json", 0, 0,
"out", "js", "json", 0, 0, "in", "name", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "filter", "create function json.filter(js json, name
integer) returns json external name json.filter;", "json", 1,
"function", false, false, false, "result", "json", 0, 0,
"out", "js", "json", 0, 0, "in", "name", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "filter", "create function json.filter(js json, name
tinyint) returns json external name json.filter;", "json", 1,
"function", false, false, false, "result", "json", 0, 0,
"out", "js", "json", 0, 0, "in", "name", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "filter", "create function json.filter(js json, pathexpr
string) returns json external name json.filter;", "json", 1,
"function", false, false, false, "result", "json", 0, 0,
"out", "js", "json", 0, 0, "in", "pathexpr", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "integer", "create function json.\"integer\"(js json)
returns bigint external name json.\"integer\";", "json", 1,
"function", false, false, false, "result", "bigint", 64,
0, "out", "js", "json", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "isarray", "create function json.isarray(js json) returns
bool external name json.isarray;", "json", 1, "function", false,
false, false, "result", "boolean", 1, 0, "out", "js",
"json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "json", "isarray", "create function json.isarray(js string)
returns bool external name json.isarray;", "json", 1, "function",
false, false, false, "result", "boolean", 1, 0, "out",
"js", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "json", "isobject", "create function json.isobject(js json) returns
bool external name json.isobject;", "json", 1, "function", false,
false, false, "result", "boolean", 1, 0, "out", "js",
"json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "json", "isobject", "create function json.isobject(js string)
returns bool external name json.isobject;", "json", 1, "function",
false, false, false, "result", "boolean", 1, 0, "out",
"js", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "json", "isvalid", "create function json.isvalid(js json) returns
bool external name json.isvalid;", "json", 1, "function", false,
false, false, "result", "boolean", 1, 0, "out", "js",
"json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "json", "isvalid", "create function json.isvalid(js string)
returns bool external name json.isvalid;", "json", 1, "function",
false, false, false, "result", "boolean", 1, 0, "out",
"js", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "json", "keyarray", "create function json.keyarray(js json) returns
json external name json.keyarray;", "json", 1, "function", false,
false, false, "result", "json", 0, 0, "out", "js", "json",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "json", "length", "create function json.length(js json) returns
integer external name json.length;", "json", 1, "function",
false, false, false, "result", "int", 32, 0, "out", "js",
"json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "json", "number", "create function json.number(js json) returns
float external name json.number;", "json", 1, "function",
false, false, false, "result", "double", 53, 0, "out",
"js", "json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "json", "output", "create aggregate json.output(js json) returns
string external name json.output;", "json", 1, "aggregate", false,
false, false, "result", "clob", 0, 0, "out", "js",
"json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "json", "text", "create function json.text(js int) returns string
external name json.text;", "json", 1, "function", false, false,
false, "result", "clob", 0, 0, "out", "js", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "json", "text", "create function json.text(js json) returns string
external name json.text;", "json", 1, "function", false, false,
false, "result", "clob", 0, 0, "out", "js", "json", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "json", "text", "create function json.text(js json, e string) returns
string external name json.text;", "json", 1, "function", false,
false, false, "result", "clob", 0, 0, "out", "js", "json",
0, 0, "in", "e", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "json", "text", "create function json.text(js string) returns string
external name json.text;", "json", 1, "function", false, false,
false, "result", "clob", 0, 0, "out", "js", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "json", "tojsonarray", "create aggregate json.tojsonarray(x double)
returns string external name aggr.jsonaggr;", "aggr", 1, "aggregate",
false, false, false, "result", "clob", 0, 0, "out", "x",
"double", 53, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "json", "tojsonarray", "create aggregate json.tojsonarray(x string)
returns string external name aggr.jsonaggr;", "aggr", 1, "aggregate",
false, false, false, "result", "clob", 0, 0, "out", "x",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "json", "valuearray", "create function json.valuearray(js json)
returns json external name json.valuearray;", "json", 1, "function",
false, false, false, "result", "json", 0, 0, "out", "js",
"json", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "profiler", "getlimit", "create function profiler.getlimit() returns
integer external name profiler.getlimit;", "profiler", 1, "function",
false, false, false, "result", "int", 32, 0, "out",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "profiler", "setheartbeat", "create procedure profiler.setheartbeat(beat
int) external name profiler.setheartbeat;", "profiler", 1,
"procedure", true, false, false, "beat", "int", 32, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "profiler", "setlimit", "create procedure profiler.setlimit(lim
integer) external name profiler.setlimit;", "profiler", 1,
"procedure", true, false, false, "lim", "int", 32, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "profiler", "start", "create procedure profiler.start() external
name profiler.\"start\";", "profiler", 1, "procedure", true,
false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "profiler", "stop", "create procedure profiler.stop() external name
profiler.stop;", "profiler", 1, "procedure", true, false,
false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "profiler", "sync", "create procedure profiler.sync() external name
profiler.sync;", "profiler", 1, "procedure", true, false,
false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys", "<", "<", "calc", 0, "function", false, false,
false, "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", "<=", "<=", "calc", 0, "function", false, false,
false, "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", "<>", "!=", "calc", 0, "function", false, false,
false, "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", "=", "=", "calc", 0, "function", false, false,
false, "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", ">", ">", "calc", 0, "function", false, false,
false, "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", ">=", ">=", "calc", 0, "function", false, false,
false, "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", "abbrev", "create function \"abbrev\" (p inet) returns
clob external name inet.\"abbrev\";", "inet", 1, "function",
false, false, false, "result", "clob", 0, 0, "out", "p",
"inet", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "bigint", 64, 0, "out", "arg_1",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "decimal", 2, 0, "out", "arg_1",
"decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "decimal", 4, 0, "out", "arg_1",
"decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "decimal", 9, 0, "out", "arg_1",
"decimal", 9, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "decimal", 18, 0, "out", "arg_1",
"decimal", 18, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "int",
32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "month_interval", 32, 0, "out",
"arg_1", "month_interval", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "oid", 63, 0, "out", "arg_1", "oid",
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", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "real", 24, 0, "out", "arg_1", "real",
24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "sec_interval", 13, 0, "out", "arg_1",
"sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "smallint", 16, 0, "out", "arg_1",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "abs", "abs", "calc", 0, "function", false, false,
false, "res_0", "tinyint", 8, 0, "out", "arg_1",
"tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "acos", "acos", "mmath", 0, "function", false,
false, false, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "acos", "acos", "mmath", 0, "function", false,
false, false, "res_0", "real", 24, 0, "out", "arg_1",
"real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "all", "all", "sql", 0, "aggregate", false, false,
false, "res", "any", 0, 0, "out", "arg", "any", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys", "alpha", "create function alpha(pdec double, pradius
double) returns double external name sql.alpha;", "sql", 1, "function",
false, false, false, "result", "double", 53, 0,
"out", "pdec", "double", 53, 0, "in", "pradius",
"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", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint) external name sql.analyze;", "sql", 1,
"procedure", true, false, false, "MinMax", "int", 32, 0,
"in", "sample", "bigint", 64, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint, sch string) external name sql.analyze;", "sql", 1,
"procedure", true, false, false, "MinMax", "int", 32, 0,
"in", "sample", "bigint", 64, 0, "in", "sch", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint, sch string, tbl string) external name sql.analyze;",
"sql", 1, "procedure", true, false, false, "MinMax", "int",
32, 0, "in", "sample", "bigint", 64, 0, "in",
"sch", "clob", 0, 0, "in", "tbl", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "analyze", "create procedure sys.analyze(minmax int,
\"sample\" bigint, sch string, tbl string, col string) external name
sql.analyze;", "sql", 1, "procedure", true, false, false,
"MinMax", "int", 32, 0, "in", "sample", "bigint",
64, 0, "in", "sch", "clob", 0, 0, "in", "tbl", "clob",
0, 0, "in", "col", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "and", "and", "calc", 0, "function", false, false,
false, "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", "ascii", "ascii", "str", 0, "function",
false, false, false, "res_0", "int", 32, 0, "out",
"arg_1", "char", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "ascii", "ascii", "str", 0, "function",
false, false, false, "res_0", "int", 32, 0, "out",
"arg_1", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "ascii", "ascii", "str", 0, "function",
false, false, false, "res_0", "int", 32, 0, "out",
"arg_1", "varchar", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "asin", "asin", "mmath", 0, "function", false,
false, false, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "asin", "asin", "mmath", 0, "function", false,
false, false, "res_0", "real", 24, 0, "out", "arg_1",
"real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "atan", "atan", "mmath", 0, "function", false,
false, false, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "atan", "atan", "mmath", 0, "function", false,
false, false, "res_0", "real", 24, 0, "out", "arg_1",
"real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "atan", "atan2", "mmath", 0, "function",
false, false, false, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", "arg_2",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "atan", "atan2", "mmath", 0, "function",
false, false, false, "res_0", "real", 24, 0, "out",
"arg_1", "real", 24, 0, "in", "arg_2", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "avg", "avg", "aggr", 0, "aggregate", false, false,
false, "res", "double", 53, 0, "out", "arg", "bigint",
64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "avg", "avg", "aggr", 0, "aggregate", false, false,
false, "res", "double", 53, 0, "out", "arg", "double",
53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "avg", "avg", "aggr", 0, "aggregate", false, false,
false, "res", "double", 53, 0, "out", "arg", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys", "avg", "avg", "aggr", 0, "aggregate", false, false,
false, "res", "double", 53, 0, "out", "arg", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys", "avg", "avg", "aggr", 0, "aggregate", false, false,
false, "res", "double", 53, 0, "out", "arg", "smallint",
16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "avg", "avg", "aggr", 0, "aggregate", false, false,
false, "res", "double", 53, 0, "out", "arg", "tinyint",
8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys", "bbp", "create function sys.bbp () returns table (id int, name
string, ttype string, count bigint, refcnt int, lrefcnt int, location string,
heat int, dirty string, status string, kind string) external name bbp.get;",
"bbp", 1, "table function", false, false, false, "id",
"int", 32, 0, "out", "name", "clob", 0, 0, "out",
"ttype", "clob", 0, 0, "out", "count", "bigint",
64, 0, "out", "refcnt", "int", 32, 0, "out",
"lrefcnt", "int", 32, 0, "out", "location", "clob", 0,
0, "out", "heat", "int", 32, 0, "out", "dirty", "clob",
0, 0, "out", "status", "clob", 0, 0, "out", "kind",
"clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "bigint", 64, 0, "out",
"arg_1", "bigint", 64, 0, "in", "arg_2",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "decimal", 2, 0, "out",
"arg_1", "decimal", 2, 0, "in", "arg_2",
"decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "decimal", 4, 0, "out",
"arg_1", "decimal", 4, 0, "in", "arg_2",
"decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "decimal", 9, 0, "out",
"arg_1", "decimal", 9, 0, "in", "arg_2",
"decimal", 9, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "decimal", 18, 0, "out",
"arg_1", "decimal", 18, 0, "in", "arg_2",
"decimal", 18, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "int", 32, 0, "out", "arg_1",
"int", 32, 0, "in", "arg_2", "int", 32, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "oid", 63, 0, "out", "arg_1",
"oid", 63, 0, "in", "arg_2", "oid", 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", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "smallint", 16, 0, "out",
"arg_1", "smallint", 16, 0, "in", "arg_2",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_and", "and", "calc", 0, "function", false,
false, false, "res_0", "tinyint", 8, 0, "out",
"arg_1", "tinyint", 8, 0, "in", "arg_2",
"tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "bigint", 64, 0, "out",
"arg_1", "bigint", 64, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "decimal", 2, 0, "out",
"arg_1", "decimal", 2, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "decimal", 4, 0, "out",
"arg_1", "decimal", 4, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "decimal", 9, 0, "out",
"arg_1", "decimal", 9, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "decimal", 18, 0, "out",
"arg_1", "decimal", 18, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "int", 32, 0, "out", "arg_1",
"int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "oid", 63, 0, "out", "arg_1",
"oid", 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", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "smallint", 16, 0, "out",
"arg_1", "smallint", 16, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_not", "not", "calc", 0, "function", false,
false, false, "res_0", "tinyint", 8, 0, "out",
"arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "bigint", 64, 0, "out",
"arg_1", "bigint", 64, 0, "in", "arg_2",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "decimal", 2, 0, "out",
"arg_1", "decimal", 2, 0, "in", "arg_2",
"decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "decimal", 4, 0, "out",
"arg_1", "decimal", 4, 0, "in", "arg_2",
"decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "decimal", 9, 0, "out",
"arg_1", "decimal", 9, 0, "in", "arg_2",
"decimal", 9, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "decimal", 18, 0, "out",
"arg_1", "decimal", 18, 0, "in", "arg_2",
"decimal", 18, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "int", 32, 0, "out", "arg_1",
"int", 32, 0, "in", "arg_2", "int", 32, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "oid", 63, 0, "out", "arg_1",
"oid", 63, 0, "in", "arg_2", "oid", 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", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "smallint", 16, 0, "out",
"arg_1", "smallint", 16, 0, "in", "arg_2",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_or", "or", "calc", 0, "function", false,
false, false, "res_0", "tinyint", 8, 0, "out",
"arg_1", "tinyint", 8, 0, "in", "arg_2",
"tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_xor", "xor", "calc", 0, "function", false,
false, false, "res_0", "bigint", 64, 0, "out",
"arg_1", "bigint", 64, 0, "in", "arg_2",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_xor", "xor", "calc", 0, "function", false,
false, false, "res_0", "decimal", 2, 0, "out",
"arg_1", "decimal", 2, 0, "in", "arg_2",
"decimal", 2, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bit_xor", "xor", "calc", 0, "function", false,
false, false, "res_0", "decimal", 4, 0, "out",
"arg_1", "decimal", 4, 0, "in", "arg_2",
"decimal", 4, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
