Changeset: c6efc22e6551 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c6efc22e6551
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
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
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: default
Log Message:
Merge with Jun2020 branch.
diffs (truncated from 737 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2093,6 +2093,18 @@ sql_update_jun2020(Client c, mvc *sql, c
* see also function load_func() in store.c */
pos += snprintf(buf + pos, bufsize - pos,
"update sys.functions set language = language - 2 where
language in (8, 9);\n");
+ sql_subtype tp;
+ sql_find_subtype(&tp, "varchar", 0, 0);
+ sql_subfunc *f = sql_bind_func(sql->sa, sys, "listagg", &tp, &tp,
F_AGGR);
+ pos += snprintf(buf + pos, bufsize - pos,
+ "insert into sys.args values"
+ " (%d, %d, 'arg_2', 'varchar', 0, 0, %d, 2);\n",
+ store_next_oid(), f->func->base.id, ARG_IN);
+
+ pos += snprintf(buf + pos, bufsize - pos,
+ "update sys.args set name = name || '_' || cast(number
as string) where name in ('arg', 'res') and func_id in (select id from
sys.functions f where f.system);\n");
+ pos += snprintf(buf + pos, bufsize - pos,
+ "insert into sys.dependencies values ((select id from
sys.functions where name = 'ms_round' and schema_id = (select id from
sys.schemas where name = 'sys')), (select id from sys.functions where name =
'ms_trunc' and schema_id = (select id from sys.schemas where name = 'sys')),
(select dependency_type_id from sys.dependency_types where dependency_type_name
= 'FUNCTION'));\n");
/* 12_url */
pos += snprintf(buf + pos, bufsize - pos,
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -5905,6 +5905,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (34148, 147, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
---
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
+++
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64.int128
@@ -5905,6 +5905,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (34143, 147, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -5118,6 +5118,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (30284, 138, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -5118,6 +5118,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (30284, 138, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -5951,6 +5951,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (30935, 147, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
@@ -5118,6 +5118,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (30279, 138, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
@@ -5951,6 +5951,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (30930, 147, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -5905,6 +5905,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (13525, 147, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
@@ -5118,6 +5118,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (12285, 138, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -5118,6 +5118,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (12285, 138, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -5951,6 +5951,9 @@ set schema "sys";
Running database upgrade commands:
set schema "sys";
update sys.functions set language = language - 2 where language in (8, 9);
+insert into sys.args values (12936, 147, 'arg_2', 'varchar', 0, 0, 1, 2);
+update sys.args set name = name || '_' || cast(number as string) where name in
('arg', 'res') and func_id in (select id from sys.functions f where f.system);
+insert into sys.dependencies values ((select id from sys.functions where name
= 'ms_round' and schema_id = (select id from sys.schemas where name = 'sys')),
(select id from sys.functions where name = 'ms_trunc' and schema_id = (select
id from sys.schemas where name = 'sys')), (select dependency_type_id from
sys.dependency_types where dependency_type_name = 'FUNCTION'));
drop function isaURL(url);
CREATE function isaURL(theUrl string) RETURNS BOOL
EXTERNAL NAME url."isaURL";
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
@@ -88,7 +88,7 @@ MAXARGS = 16
# columns of the args table we're interested in
args = ['name', 'type', 'type_digits', 'type_scale', 'inout']
-out += r"select 'sys.functions', s.name, f.name, case f.system when true then
'SYSTEM' else '' end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
E'--.*\n', '', ''), E'[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name, f.side_effect, f.varres, f.vararg"
+out += r"select 'sys.functions', s.name, f.name, case f.system when true then
'SYSTEM' else '' end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
E'--.*\n', '', ''), E'[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name as func_type, 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)
@@ -99,10 +99,10 @@ out += " left outer join sys.function_ty
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"
+out += " order by s.name, f.name, query, func_type"
for i in range(0, MAXARGS):
for a in args:
- out += ", %s%d" % (a, i)
+ out += ", %s%d nulls first" % (a, i)
out += ";"
out += '''
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
@@ -1431,7 +1431,7 @@ select 'sys.value_partitions', t.name, p
-- external functions that don't reference existing MAL function (should be
empty)
with funcs as (select name, pcre_replace(func, E'--.*\n*', '', '') as func,
schema_id from sys.functions), x (sname, name, modfunc) as (select s.name,
f.name, replace(pcre_replace(f.func, '.*external name (.*);.*', '$1', 'ims'),
'"', '') from funcs f left outer join sys.schemas s on f.schema_id = s.id where
f.func ilike '% external name %') select 'dangling external functions', * from
x where x.modfunc not in (select m.module || '.' || m."function" from
sys.malfunctions() m);
-- args
-select 'sys.functions', s.name, f.name, case f.system when true then 'SYSTEM'
else '' end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
E'--.*\n', '', ''), E'[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') 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 inout
9, 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 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, type
12, 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;
+select 'sys.functions', s.name, f.name, case f.system when true then 'SYSTEM'
else '' end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
E'--.*\n', '', ''), E'[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name as func_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 th
en '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 outer 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, func_type, name0 nulls first, type0 nulls first, type_digits0
nulls first, type_scale0 nulls first, inout0 nulls first, name1 nulls first,
type1 nulls first, type_digits1 nulls first, type_scale1 nulls first, inout1
nulls first, name2 nulls first, type2 nulls first, type_digits2 nulls first,
type_scale2 nulls first, inout2 nulls first, name3 nulls first, type3 nulls
first, type_digits3 nulls first, type_scale3 nulls first, inout3 nulls first,
name4 nulls first, type4 nulls first, type_digits4 nulls first, type_scale4
nulls first, inout4 nulls first, name5 nulls first, type5 nulls first, typ
e_digits5 nulls first, type_scale5 nulls first, inout5 nulls first, name6
nulls first, type6 nulls first, type_digits6 nulls first, type_scale6 nulls
first, inout6 nulls first, name7 nulls first, type7 nulls first, type_digits7
nulls first, type_scale7 nulls first, inout7 nulls first, name8 nulls first,
type8 nulls first, type_digits8 nulls first, type_scale8 nulls first, inout8
nulls first, name9 nulls first, type9 nulls first, type_digits9 nulls first,
type_scale9 nulls first, inout9 nulls first, name10 nulls first, type10 nulls
first, type_digits10 nulls first, type_scale10 nulls first, inout10 nulls
first, name11 nulls first, type11 nulls first, type_digits11 nulls first,
type_scale11 nulls first, inout11 nulls first, name12 nulls first, type12 nulls
first, type_digits12 nulls first, type_scale12 nulls first, inout12 nulls
first, name13 nulls first, type13 nulls first, type_digits13 nulls first,
type_scale13 nulls first, inout13 nulls first, name14 nulls first, type14 nulls
firs
t, type_digits14 nulls first, type_scale14 nulls first, inout14 nulls first,
name15 nulls first, type15 nulls first, type_digits15 nulls first, type_scale15
nulls first, inout15 nulls first;
-- auths
select 'sys.auths', name, grantor from sys.auths;
-- comments
@@ -2221,9 +2221,9 @@ drop function pcre_replace(string, strin
% single_value, sname, name, modfunc # name
% char, varchar, varchar, varchar # type
% 27, 0, 0, 0 # length
-#select 'sys.functions', s.name, f.name, case f.system when true then 'SYSTEM'
else '' end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
E'--.*\n', '', ''), E'[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') 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' whe
n 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 inou
t9, 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 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, typ
e12, 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;
-% .%50, .s, .f, ., ., .f, .fl, .ft, .f,
.f, .f, ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., . # table_name
-% %50, name, name, system, query, mod, language_name,
function_type_name, 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
+#select 'sys.functions', s.name, f.name, case f.system when true then 'SYSTEM'
else '' end as system,
replace(replace(replace(pcre_replace(pcre_replace(pcre_replace(f.func,
E'--.*\n', '', ''), E'[ \t\n]+', ' ', 'm'), '^ ', '', ''), '( ', '('), ' )',
')'), 'create system ', 'create ') as query, f.mod, fl.language_name,
ft.function_type_name as func_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 t
hen '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 outer 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 a1
0.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, func_type, name0 nulls first,
type0 nulls first, type_digits0 nulls first, type_scale0 nulls first, inout0
nulls first, name1 nulls first, type1 nulls first, type_digits1 nulls first,
type_scale1 nulls first, inout1 nulls first, name2 nulls first, type2 nulls
first, type_digits2 nulls first, type_scale2 nulls first, inout2 nulls first,
name3 nulls first, type3 nulls first, type_digits3 nulls first, type_scale3
nulls first, inout3 nulls first, name4 nulls first, type4 nulls first,
type_digits4 nulls first, type_scale4 nulls first, inout4 nulls first, name5
nulls first, type5 nulls first, ty
pe_digits5 nulls first, type_scale5 nulls first, inout5 nulls first, name6
nulls first, type6 nulls first, type_digits6 nulls first, type_scale6 nulls
first, inout6 nulls first, name7 nulls first, type7 nulls first, type_digits7
nulls first, type_scale7 nulls first, inout7 nulls first, name8 nulls first,
type8 nulls first, type_digits8 nulls first, type_scale8 nulls first, inout8
nulls first, name9 nulls first, type9 nulls first, type_digits9 nulls first,
type_scale9 nulls first, inout9 nulls first, name10 nulls first, type10 nulls
first, type_digits10 nulls first, type_scale10 nulls first, inout10 nulls
first, name11 nulls first, type11 nulls first, type_digits11 nulls first,
type_scale11 nulls first, inout11 nulls first, name12 nulls first, type12 nulls
first, type_digits12 nulls first, type_scale12 nulls first, inout12 nulls
first, name13 nulls first, type13 nulls first, type_digits13 nulls first,
type_scale13 nulls first, inout13 nulls first, name14 nulls first, type14 nulls
fir
st, type_digits14 nulls first, type_scale14 nulls first, inout14 nulls first,
name15 nulls first, type15 nulls first, type_digits15 nulls first, type_scale15
nulls first, inout15 nulls first;
+% .%50, .s, .f, ., ., .f, .fl, ., .f,
.f, .f, ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., ., ., ., ., ., ., ., ., .,
., . # table_name
+% %50, name, name, system, query, mod, language_name, func_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
% char, varchar, varchar, char, varchar,
varchar, varchar, varchar, 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
% 13, 8, 24, 6, 1362, 9, 10, 26, 5, 5,
5, 11, 14, 4, 1, 3, 16, 14, 4, 1,
3, 16, 14, 4, 1, 3, 27, 12, 4, 1,
3, 9, 9, 2, 1, 3, 14, 14, 4, 1,
3, 12, 14, 2, 1, 3, 11, 7, 2, 1,
3, 11, 7, 2, 1, 3, 8, 6, 2, 1,
3, 6, 6, 2, 1, 3, 6, 7, 2, 1,
3, 8, 7, 2, 1, 3, 6, 7, 1, 1,
3, 9, 7, 1, 1, 3, 6, 7, 1, 1,
3 # length
[ "sys.functions", "json", "filter", "SYSTEM", "create
function json.filter(js json, name bigint) returns json external name
json.filter;", "json", "MAL", "Scalar function", false, false,
false, "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 ]
@@ -2303,20 +2303,20 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "atan", "SYSTEM", "atan", "mmath",
"Internal C", "Scalar 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.functions", "sys", "atan", "SYSTEM", "atan2",
"mmath", "Internal C", "Scalar 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.functions", "sys", "atan", "SYSTEM", "atan2",
"mmath", "Internal C", "Scalar 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "real", 24, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate 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.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 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.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "real", 24, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "real", 24, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 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.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 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.functions", "sys", "avg", "SYSTEM", "avg", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "avg", "SYSTEM", "avg", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"double", 53, 0, "out", "arg_1", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "bbp", "SYSTEM", "create function
sys.bbp () returns table (id int, name string, ttype string, count bigint,
refcnt int, lrefcnt int, location string, heat int, dirty string, status
string, kind string) external name bbp.get;", "bbp", "MAL", "Function
returning a table", true, false, false, "id", "int", 32, 0,
"out", "name", "clob", 0, 0, "out", "ttype", "clob", 0,
0, "out", "count", "bigint", 64, 0, "out",
"refcnt", "int", 32, 0, "out", "lrefcnt", "int", 32,
0, "out", "location", "clob", 0, 0, "out", "heat", "int",
32, 0, "out", "dirty", "clob", 0, 0, "out",
"status", "clob", 0, 0, "out", "kind", "clob", 0, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "between", "SYSTEM", "between",
"calc", "Internal C", "Scalar function", false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1", "any",
0, 0, "in", "arg_2", "any", 0, 0, "in",
"arg_3", "any", 0, 0, "in", "arg_4", "boolean",
1, 0, "in", "arg_5", "boolean", 1, 0, "in",
"arg_6", "boolean", 1, 0, "in", "arg_7",
"boolean", 1, 0, "in", "arg_8", "boolean", 1,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "bit_and", "SYSTEM", "and", "calc",
"Internal C", "Scalar function", false, false, false, "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 ]
@@ -2627,10 +2627,10 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "lidarload", "SYSTEM", "create
procedure lidarload(tname string) external name lidar.load;", "lidar",
"MAL", "Procedure", true, false, false, "tname", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "like", "SYSTEM", "create filter function
\"like\"(val string, pat string) external name algebra.\"like\";",
"algebra", "MAL", "Filter function", false, false, false, "val",
"clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "like", "SYSTEM", "create filter function
\"like\"(val string, pat string, esc string) external name algebra.\"like\";",
"algebra", "MAL", "Filter function", false, false, false, "val",
"clob", 0, 0, "in", "pat", "clob", 0, 0, "in", "esc",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "listagg", "SYSTEM",
"str_group_concat", "aggr", "Internal C", "Aggregate function", false,
false, false, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "listagg", "SYSTEM",
"str_group_concat", "aggr", "Internal C", "Aggregate function", false,
false, false, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "listagg", "SYSTEM",
"str_group_concat", "sql", "Internal C", "Analytic function", false,
false, false, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "listagg", "SYSTEM",
"str_group_concat", "aggr", "Internal C", "Aggregate function", false,
false, false, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "listagg", "SYSTEM",
"str_group_concat", "sql", "Internal C", "Analytic function", false,
false, false, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys.functions", "sys", "listagg", "SYSTEM",
"str_group_concat", "aggr", "Internal C", "Aggregate function", false,
false, false, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "listdir", "SYSTEM", "create
procedure listdir(dirname string) external name fits.listdir;", "fits", "MAL",
"Procedure", true, false, false, "dirname", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "listdirpat", "SYSTEM", "create
procedure listdirpat(dirname string,pat string) external name
fits.listdirpattern;", "fits", "MAL", "Procedure", true, false,
false, "dirname", "clob", 0, 0, "in", "pat", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "ln", "SYSTEM", "log", "mmath",
"Internal C", "Scalar 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 ]
@@ -2669,8 +2669,8 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "ltrim", "SYSTEM", "ltrim",
"str", "Internal C", "Scalar function", false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "malfunctions", "SYSTEM", "create
function sys.malfunctions() returns table(\"module\" string, \"function\"
string, \"signature\" string, \"address\" string, \"comment\" string) external
name \"manual\".\"functions\";", "manual", "MAL", "Function
returning a table", true, false, false, "module", "clob", 0,
0, "out", "function", "clob", 0, 0, "out", "signature",
"clob", 0, 0, "out", "address", "clob", 0, 0, "out",
"comment", "clob", 0, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "masklen", "SYSTEM", "create
function \"masklen\" (p inet) returns int external name inet.\"masklen\";",
"inet", "MAL", "Scalar function", false, false, false, "result",
"int", 32, 0, "out", "p", "inet", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "max", "SYSTEM", "max", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"any", 0, 0, "out", "arg_1", "any", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "max", "SYSTEM", "max", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"any", 0, 0, "out", "arg_1", "any", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys.functions", "sys", "max", "SYSTEM", "max", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"any", 0, 0, "out", "arg_1", "any", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "mbr", "SYSTEM", "create function
mbr(geom geometry) returns mbr external name geom.\"mbr\";", "geom", "MAL",
"Scalar function", false, false, false, "result", "mbr", 0,
0, "out", "geom", "geometry", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "mbr_above", "SYSTEM", "mbrAbove",
"geom", "Internal C", "Scalar function", false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1",
"geometry", 0, 0, "in", "arg_2", "geometry", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "mbr_above", "SYSTEM", "mbrAbove",
"geom", "Internal C", "Scalar function", false, false, false,
"res_0", "boolean", 1, 0, "out", "arg_1", "mbr",
0, 0, "in", "arg_2", "mbr", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
@@ -2718,8 +2718,8 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "median_avg", "SYSTEM", "create
aggregate median_avg(val real) returns double external name
\"aggr\".\"median_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, "result", "double", 53, 0, "out", "val",
"real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "median_avg", "SYSTEM", "create
aggregate median_avg(val smallint) returns double external name
\"aggr\".\"median_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, "result", "double", 53, 0, "out", "val",
"smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "median_avg", "SYSTEM", "create
aggregate median_avg(val tinyint) returns double external name
\"aggr\".\"median_avg\";", "aggr", "MAL", "Aggregate function", false,
false, false, "result", "double", 53, 0, "out", "val",
"tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "min", "SYSTEM", "min", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"any", 0, 0, "out", "arg_1", "any", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "min", "SYSTEM", "min", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"any", 0, 0, "out", "arg_1", "any", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys.functions", "sys", "min", "SYSTEM", "min", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"any", 0, 0, "out", "arg_1", "any", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "minute", "SYSTEM", "minutes",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "sec_interval",
13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "minute", "SYSTEM", "minutes",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "time", 7,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "minute", "SYSTEM", "minutes",
"mtime", "Internal C", "Scalar function", false, false, false,
"res_0", "int", 32, 0, "out", "arg_1", "timestamp",
7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -2795,16 +2795,16 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "prepared_statements", "SYSTEM", "create
function sys.prepared_statements() returns table(\"sessionid\" int,
\"username\" string, \"statementid\" int, \"statement\" string, \"created\"
timestamp) external name sql.prepared_statements;", "sql", "MAL",
"Function returning a table", true, false, false, "sessionid", "int",
32, 0, "out", "username", "clob", 0, 0, "out",
"statementid", "int", 32, 0, "out", "statement", "clob", 0,
0, "out", "created", "timestamp", 7, 0, "out", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "prepared_statements_args", "SYSTEM",
"create function sys.prepared_statements_args() returns table(\"statementid\"
int, \"type\" string, \"type_digits\" int, \"type_scale\" int, \"inout\"
tinyint, \"number\" int, \"schema\" string, \"table\" string, \"column\"
string) external name sql.prepared_statements_args;", "sql", "MAL",
"Function returning a table", true, false, false, "statementid", "int",
32, 0, "out", "type", "clob", 0, 0, "out", "type_digits",
"int", 32, 0, "out", "type_scale", "int", 32, 0, "out",
"inout", "tinyint", 8, 0, "out", "number", "int",
32, 0, "out", "schema", "clob", 0, 0, "out",
"table", "clob", 0, 0, "out", "column", "clob", 0,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "bigint", 64,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic 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.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "smallint", 16,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate 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.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate 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.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic 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.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "smallint", 16,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "tinyint", 8,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic 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.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate 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.functions", "sys", "prod", "SYSTEM", "prod", "aggr",
"Internal C", "Aggregate 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.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic 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.functions", "sys", "qgramnormalize", "SYSTEM",
"qgramnormalize", "txtsim", "Internal C", "Scalar function",
false, false, false, "res_0", "char", 0, 0, "out",
"arg_1", "char", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "qgramnormalize", "SYSTEM",
"qgramnormalize", "txtsim", "Internal C", "Scalar function",
false, false, false, "res_0", "clob", 0, 0, "out",
"arg_1", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -3866,29 +3866,29 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "substring", "SYSTEM", "substring",
"str", "Internal C", "Scalar function", false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
