Changeset: a5b757b58cd2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a5b757b58cd2
Modified Files:
sql/test/emptydb/Tests/check.stable.out.32bit
Branch: default
Log Message:
Approve 32 bit output.
diffs (truncated from 504 to 300 lines):
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -545,6 +545,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "queue", "create view sys.queue as
select * from sys.queue();", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "range_partitions", NULL, "TABLE",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "rejects", "create view sys.rejects as
select * from sys.rejects();", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
+[ "sys._tables", "sys", "remote_user_info", NULL, "TABLE",
true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "roles", "create view sys.roles as
select id, name, grantor from sys.auths a where a.name not in (select u.name
from sys.db_user_info u);", "VIEW", true, "COMMIT", "WRITABLE",
NULL ]
[ "sys._tables", "sys", "schemas", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "schemastorage", "create view
sys.\"schemastorage\" as select \"schema\", count(*) as \"storages\",
sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as
hashsize, sum(\"imprints\") as imprintsize, sum(orderidx) as orderidxsize from
sys.\"storage\" group by \"schema\" order by \"schema\";", "VIEW", true,
"COMMIT", "WRITABLE", NULL ]
@@ -573,7 +574,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "tmp", "keys", NULL, "TABLE", true,
"PRESERVE", "WRITABLE", NULL ]
[ "sys._tables", "tmp", "objects", NULL, "TABLE", true,
"PRESERVE", "WRITABLE", NULL ]
[ "sys._tables", "tmp", "triggers", NULL, "TABLE", true,
"PRESERVE", "WRITABLE", NULL ]
-% .%1, sys.t, .c, .c, .c, .c, .c, .c, .c, .c,
. # table_name
+% .%1, .t, .c, .c, .c, .c, .c, .c, .c, .c,
. # table_name
% %1, name, name, type, type_digits, type_scale, default,
null, number, storage, comment # name
% char, varchar, varchar, varchar, int, int,
varchar, boolean, int, varchar, varchar # type
% 12, 34, 26, 9, 7, 1, 5, 5, 2, 0,
0 # length
@@ -1173,6 +1174,9 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "rejects", "fldid", "int", 32, 0,
NULL, true, 1, NULL, NULL ]
[ "sys._columns", "rejects", "message", "clob", 0, 0,
NULL, true, 2, NULL, NULL ]
[ "sys._columns", "rejects", "input", "clob", 0, 0,
NULL, true, 3, NULL, NULL ]
+[ "sys._columns", "remote_user_info", "table_id", "int", 32,
0, NULL, true, 0, NULL, NULL ]
+[ "sys._columns", "remote_user_info", "username", "varchar",
1024, 0, NULL, true, 1, NULL, NULL ]
+[ "sys._columns", "remote_user_info", "password", "varchar",
256, 0, NULL, true, 2, NULL, NULL ]
[ "sys._columns", "roles", "id", "int", 32, 0, NULL,
true, 0, NULL, NULL ]
[ "sys._columns", "roles", "name", "varchar", 1024, 0,
NULL, true, 1, NULL, NULL ]
[ "sys._columns", "roles", "grantor", "int", 32, 0,
NULL, true, 2, NULL, NULL ]
@@ -1429,6 +1433,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "ascii", "SYSTEM", "ascii",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "int", 32, 0, "out", "arg_1", "char",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "ascii", "SYSTEM", "ascii",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "int", 32, 0, "out", "arg_1", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "ascii", "SYSTEM", "ascii",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "asciify", "SYSTEM", "create
function asciify(x string) returns string external name str.\"asciify\";",
"str", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "clob", 0, 0, "out", "x", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "asin", "SYSTEM", "asin", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "asin", "SYSTEM", "asin", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "atan", "SYSTEM", "atan", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -1511,7 +1516,11 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "concat", "SYSTEM", "+", "calc",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "char", 0, 0, "out", "arg_1", "char", 0,
0, "in", "arg_2", "char", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "concat", "SYSTEM", "+", "calc",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "clob", 0, 0, "out", "arg_1", "clob", 0,
0, "in", "arg_2", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "concat", "SYSTEM", "+", "calc",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "contains", "SYSTEM", "create filter
function sys.contains(x string, y string) external name str.\"contains\";",
"str", "MAL", "Filter function", false, false, false, true, NULL,
"x", "clob", 0, 0, "in", "y", "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", "contains", "SYSTEM", "create filter
function sys.contains(x string, y string, icase boolean) external name
str.\"contains\";", "str", "MAL", "Filter function", false,
false, false, true, NULL, "x", "clob", 0, 0, "in", "y",
"clob", 0, 0, "in", "icase", "boolean", 1, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "contains", "SYSTEM", "create
function contains(a geometry, x double, y double) returns boolean external name
geom.\"Contains\";", "geom", "MAL", "Scalar function", false, false,
false, true, NULL, "result", "boolean", 1, 0, "out",
"a", "geometry", 0, 0, "in", "x", "double", 53,
0, "in", "y", "double", 53, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "contains", "SYSTEM", "create
function sys.contains(x string, y string) returns boolean external name
str.\"contains\";", "str", "MAL", "Scalar function", false, false,
false, true, NULL, "result", "boolean", 1, 0, "out",
"x", "clob", 0, 0, "in", "y", "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", "contains", "SYSTEM", "create
function sys.contains(x string, y string, icase boolean) returns boolean
external name str.\"contains\";", "str", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "boolean", 1,
0, "out", "x", "clob", 0, 0, "in", "y", "clob", 0,
0, "in", "icase", "boolean", 1, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 bigint, e2 bigint) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "e1", "bigint",
64, 0, "in", "e2", "bigint", 64, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 double, e2 double) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "e1", "double",
53, 0, "in", "e2", "double", 53, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "corr", "SYSTEM", "create aggregate
corr(e1 integer, e2 integer) returns double external name \"aggr\".\"corr\";",
"aggr", "MAL", "Aggregate function", false, false, false, true,
NULL, "result", "double", 53, 0, "out", "e1", "int",
32, 0, "in", "e2", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -1565,6 +1574,8 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "current_time", "SYSTEM", "current_time",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "timetz", 7, 0, "out", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "current_timestamp", "SYSTEM",
"current_timestamp", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "timestamptz", 7,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "curtime", "SYSTEM", "current_time",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "timetz", 7, 0, "out", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "dameraulevenshtein", "SYSTEM", "create
function sys.dameraulevenshtein(x string, y string) returns int external name
txtsim.dameraulevenshtein;", "txtsim", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "int", 32, 0,
"out", "x", "clob", 0, 0, "in", "y", "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", "dameraulevenshtein", "SYSTEM", "create
function sys.dameraulevenshtein(x string, y string, insdel int, rep int, trans
int) returns int external name txtsim.dameraulevenshtein;", "txtsim",
"MAL", "Scalar function", false, false, false, true, NULL,
"result", "int", 32, 0, "out", "x", "clob", 0, 0,
"in", "y", "clob", 0, 0, "in", "insdel", "int", 32,
0, "in", "rep", "int", 32, 0, "in", "trans", "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 ]
[ "sys.functions", "sys", "database", "SYSTEM", "create
function sys.database () returns string external name
inspect.\"getDatabaseName\";", "inspect", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "clob", 0, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "date_to_str", "SYSTEM", "create
function date_to_str(d date, format string) returns string external name
mtime.\"date_to_str\";", "mtime", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "clob", 0, 0,
"out", "d", "date", 0, 0, "in", "format", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "date_trunc", "SYSTEM", "create
function sys.date_trunc(txt string, t timestamp with time zone) returns
timestamp with time zone external name sql.date_trunc;", "sql", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"timestamptz", 7, 0, "out", "txt", "clob", 0, 0, "in",
"t", "timestamptz", 7, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
@@ -1584,6 +1595,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "decade", "SYSTEM", "decade",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"date", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "decade", "SYSTEM", "decade",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"timestamp", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "decade", "SYSTEM", "decade",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"timestamptz", 7, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "decypher", "SYSTEM", "create
function sys.decypher (cypher string) returns string external name
sql.decypher;", "sql", "MAL", "Scalar function", false, false,
false, true, NULL, "result", "clob", 0, 0, "out",
"cypher", "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", "degrees", "SYSTEM", "degrees",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "degrees", "SYSTEM", "degrees",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "real", 24, 0, "out", "arg_1",
"real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "deltas", "SYSTEM", "create
function sys.deltas (\"schema\" string) returns table (\"id\" int, \"segments\"
bigint, \"all\" bigint, \"inserted\" bigint, \"updates\" bigint, \"deletes\"
bigint, \"level\" int) external name \"sql\".\"deltas\";", "sql", "MAL",
"Function returning a table", false, false, false, true, NULL, "id",
"int", 32, 0, "out", "segments", "bigint", 64, 0,
"out", "all", "bigint", 64, 0, "out", "inserted",
"bigint", 64, 0, "out", "updates", "bigint", 64,
0, "out", "deletes", "bigint", 64, 0, "out",
"level", "int", 32, 0, "out", "schema", "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 ]
@@ -1594,20 +1606,18 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "describe_function", "SYSTEM", "create
function sys.describe_function(schemaname string, functionname string) returns
table(id integer, name string, type string, language string, remark string)
begin return select f.id, f.name, ft.function_type_keyword,
fl.language_keyword, c.remark from sys.functions f join sys.schemas s on
f.schema_id = s.id join sys.function_types 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.comments c on f.id = c.id where f.name=functionname and s.name =
schemaname; end;", "sql", "SQL", "Function returning a table", false,
false, false, true, NULL, "id", "int", 32, 0, "out", "name",
"clob", 0, 0, "out", "type", "clob", 0, 0, "out",
"language", "clob", 0, 0, "out", "remark", "clob", 0,
0, "out", "schemaname", "clob", 0, 0, "in", "functionname",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NUL
L, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "describe_table", "SYSTEM", "create
function sys.describe_table(schemaname string, tablename string) returns
table(name string, query string, type string, id integer, remark string) begin
return select t.name, t.query, tt.table_type_name, t.id, c.remark from
sys.schemas s, sys.table_types tt, sys._tables t left outer join sys.comments c
on t.id = c.id where s.name = schemaname and t.schema_id = s.id and t.name =
tablename and t.type = tt.table_type_id; end;", "sql", "SQL", "Function
returning a table", false, false, false, true, NULL, "name", "clob",
0, 0, "out", "query", "clob", 0, 0, "out", "type",
"clob", 0, 0, "out", "id", "int", 32, 0, "out",
"remark", "clob", 0, 0, "out", "schemaname", "clob", 0,
0, "in", "tablename", "clob", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, N
ULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "describe_type", "SYSTEM", "create
function sys.describe_type(ctype string, digits integer, tscale integer)
returns string begin return case ctype when 'bigint' then 'BIGINT' when 'blob'
then case digits when 0 then 'BINARY LARGE OBJECT' else 'BINARY LARGE OBJECT('
|| digits || ')' end when 'boolean' then 'BOOLEAN' when 'char' then case digits
when 1 then 'CHARACTER' else 'CHARACTER(' || digits || ')' end when 'clob' then
case digits when 0 then 'CHARACTER LARGE OBJECT' else 'CHARACTER LARGE OBJECT('
|| digits || ')' end when 'date' then 'DATE' when 'day_interval' then 'INTERVAL
DAY' when ctype = 'decimal' then case when (digits = 1 and tscale = 0) or
digits = 0 then 'DECIMAL' when tscale = 0 then 'DECIMAL(' || digits || ')' when
digits = 39 then 'DECIMAL(' || 38 || ',' || tscale || ')' when digits = 19 and
(select count(*) = 0 from sys.types where sqlname = 'hugeint') then 'DECIMAL('
|| 18 || ',' || tscale || ')' else 'DECIMAL(' || digits || ',' || tscale
|| ')' end when 'double' then case when digits = 53 and tscale = 0 then
'DOUBLE' when tscale = 0 then 'FLOAT(' || digits || ')' else 'FLOAT(' || digits
|| ',' || tscale || ')' end when 'geometry' then case digits when 4 then
'GEOMETRY(POINT' || case tscale when 0 then '' else ',' || tscale end || ')'
when 8 then 'GEOMETRY(LINESTRING' || case tscale when 0 then '' else ',' ||
tscale end || ')' when 16 then 'GEOMETRY(POLYGON' || case tscale when 0 then ''
else ',' || tscale end || ')' when 20 then 'GEOMETRY(MULTIPOINT' || case tscale
when 0 then '' else ',' || tscale end || ')' when 24 then
'GEOMETRY(MULTILINESTRING' || case tscale when 0 then '' else ',' || tscale end
|| ')' when 28 then 'GEOMETRY(MULTIPOLYGON' || case tscale when 0 then '' else
',' || tscale end || ')' when 32 then 'GEOMETRY(GEOMETRYCOLLECTION' || case
tscale when 0 then '' else ',' || tscale end || ')' else 'GEOMETRY' end when
'hugeint' then 'HUGEINT' when 'int' then 'INTEGER' when 'month_interval' then
case digits
when 1 then 'INTERVAL YEAR' when 2 then 'INTERVAL YEAR TO MONTH' when 3 then
'INTERVAL MONTH' end when 'real' then case when digits = 24 and tscale = 0 then
'REAL' when tscale = 0 then 'FLOAT(' || digits || ')' else 'FLOAT(' || digits
|| ',' || tscale || ')' end when 'sec_interval' then case digits when 4 then
'INTERVAL DAY' when 5 then 'INTERVAL DAY TO HOUR' when 6 then 'INTERVAL DAY TO
MINUTE' when 7 then 'INTERVAL DAY TO SECOND' when 8 then 'INTERVAL HOUR' when 9
then 'INTERVAL HOUR TO MINUTE' when 10 then 'INTERVAL HOUR TO SECOND' when 11
then 'INTERVAL MINUTE' when 12 then 'INTERVAL MINUTE TO SECOND' when 13 then
'INTERVAL SECOND' end when 'smallint' then 'SMALLINT' when 'time' then case
digits when 1 then 'TIME' else 'TIME(' || (digits - 1) || ')' end when
'timestamp' then case digits when 7 then 'TIMESTAMP' else 'TIMESTAMP(' ||
(digits - 1) || ')' end when 'timestamptz' then case digits when 7 then
'TIMESTAMP' else 'TIMESTAMP(' || (digits - 1) || ')' end || ' WITH TIME ZONE'
when 'timetz' then case digits when 1 then 'TIME' else 'TIME(' || (digits -
1) || ')' end || ' WITH TIME ZONE' when 'tinyint' then 'TINYINT' when 'varchar'
then 'CHARACTER VARYING(' || digits || ')' else case when lower(ctype) = ctype
then upper(ctype) else '\"' || ctype || '\"' end || case digits when 0 then ''
else '(' || digits || case tscale when 0 then '' else ',' || tscale end || ')'
end end; end;", "sql", "SQL", "Scalar function", false, false,
false, true, NULL, "result", "clob", 0, 0, "out",
"ctype", "clob", 0, 0, "in", "digits", "int", 32,
0, "in", "tscale", "int", 32, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "difference", "SYSTEM", "stringdiff",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"char", 0, 0, "in", "arg_2", "char", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "difference", "SYSTEM", "stringdiff",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "difference", "SYSTEM", "stringdiff",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "difference", "SYSTEM", "create
function sys.difference(x string, y string) returns int external name
txtsim.stringdiff;", "txtsim", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "int", 32, 0,
"out", "x", "clob", 0, 0, "in", "y", "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", "dq", "SYSTEM", "create function sys.dq
(s string) returns string begin return '\"' || sys.replace(s,'\"','\"\"') ||
'\"'; end;", "sql", "SQL", "Scalar function", false, false,
false, true, NULL, "result", "clob", 0, 0, "out", "s",
"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", "droporderindex", "SYSTEM", "create
procedure sys.droporderindex(sys string, tab string, col string) external name
sql.droporderindex;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sys", "clob", 0, 0, "in", "tab", "clob", 0,
0, "in", "col", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "dump_database", "SYSTEM", "create
function sys.dump_database(describe boolean) returns table(o int, stmt string)
begin set schema sys; truncate sys.dump_statements; insert into
sys.dump_statements values (1, 'START TRANSACTION;'); insert into
sys.dump_statements values (2, 'SET SCHEMA \"sys\";'); insert into
sys.dump_statements select (select count(*) from sys.dump_statements) + rank()
over(), stmt from sys.dump_create_roles; insert into sys.dump_statements select
(select count(*) from sys.dump_statements) + rank() over(), stmt from
sys.dump_create_users; insert into sys.dump_statements select (select count(*)
from sys.dump_statements) + rank() over(), stmt from sys.dump_create_schemas;
insert into sys.dump_statements select (select count(*) from
sys.dump_statements) + rank() over(), stmt from sys.dump_user_defined_types;
insert into sys.dump_statements select (select count(*) from
sys.dump_statements) + rank() over(), stmt from sys.dump_add_schemas_to_use
rs; insert into sys.dump_statements select (select count(*) from
sys.dump_statements) + rank() over(), stmt from sys.dump_grant_user_privileges;
insert into sys.dump_statements select (select count(*) from
sys.dump_statements) + rank() over(), stmt from sys.dump_sequences; insert into
sys.dump_statements select (select count(*) from sys.dump_statements) + rank()
over(order by stmts.o), stmts.s from (select f.o, f.stmt from
sys.dump_functions f union all select t.o, t.stmt from sys.dump_tables t) as
stmts(o, s); if not describe then call sys.dump_table_data(); end if; insert
into sys.dump_statements select (select count(*) from sys.dump_statements) +
rank() over(), stmt from sys.dump_start_sequences; insert into
sys.dump_statements select (select count(*) from sys.dump_statements) + rank()
over(), stmt from sys.dump_column_defaults; insert into sys.dump_statements
select (select count(*) from sys.dump_statements) + rank() over(), stmt from
sys.dump_table_constraint_type; insert into
sys.dump_statements select (select count(*) from sys.dump_statements) + rank()
over(), stmt from sys.dump_indices; insert into sys.dump_statements select
(select count(*) from sys.dump_statements) + rank() over(), stmt from
sys.dump_foreign_keys; insert into sys.dump_statements select (select count(*)
from sys.dump_statements) + rank() over(), stmt from sys.dump_partition_tables;
insert into sys.dump_statements select (select count(*) from
sys.dump_statements) + rank() over(), stmt from sys.dump_triggers; insert into
sys.dump_statements select (select count(*) from sys.dump_statements) + rank()
over(), stmt from sys.dump_comments; insert into sys.dump_statements select
(select count(*) from sys.dump_statements) + rank() over(), stmt from
sys.dump_table_grants; insert into sys.dump_statements select (select count(*)
from sys.dump_statements) + rank() over(), stmt from sys.dump_column_grants;
insert into sys.dump_statements select (select count(*) from
sys.dump_statements) + rank() ov
er(), stmt from sys.dump_function_grants; insert into sys.dump_statements
values ((select count(*) from sys.dump_statements) + 1, 'COMMIT;'); return
sys.dump_statements; end;", "sql", "SQL", "Function returning a table",
false, false, false, true, NULL, "o", "int", 32, 0,
"out", "stmt", "clob", 0, 0, "out", "describe", "boolean",
1, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "dump_table_data", "SYSTEM", "create
procedure sys.dump_table_data() begin declare i int; set i = (select min(t.id)
from sys.tables t, sys.table_types ts where t.type = ts.table_type_id and
ts.table_type_name = 'TABLE' and not t.system); if i is not null then declare m
int; set m = (select max(t.id) from sys.tables t, sys.table_types ts where
t.type = ts.table_type_id and ts.table_type_name = 'TABLE' and not t.system);
declare sch string; declare tbl string; while i is not null and i <= m do set
sch = (select s.name from sys.tables t, sys.schemas s where s.id = t.schema_id
and t.id = i); set tbl = (select t.name from sys.tables t, sys.schemas s where
s.id = t.schema_id and t.id = i); call sys.dump_table_data(sch, tbl); set i =
(select min(t.id) from sys.tables t, sys.table_types ts where t.type =
ts.table_type_id and ts.table_type_name = 'TABLE' and not t.system and t.id >
i); end while; end if; end;", "sql", "SQL", "Procedure", true, false,
false, true, NU
LL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "dump_table_data", "SYSTEM", "create
procedure sys.dump_table_data(sch string, tbl string) begin declare tid int;
set tid = (select min(t.id) from sys.tables t, sys.schemas s where t.name = tbl
and t.schema_id = s.id and s.name = sch); if tid is not null then declare k
int; declare m int; set k = (select min(c.id) from sys.columns c where
c.table_id = tid); set m = (select max(c.id) from sys.columns c where
c.table_id = tid); if k is not null and m is not null then declare cname
string; declare ctype string; declare _cnt int; set cname = (select c.name from
sys.columns c where c.id = k); set ctype = (select c.type from sys.columns c
where c.id = k); set _cnt = (select count from sys.storage(sch, tbl, cname));
if _cnt > 0 then declare copy_into_stmt string; declare select_data_stmt
string; set copy_into_stmt = 'COPY ' || _cnt || ' RECORDS INTO ' ||
sys.fqn(sch, tbl) || '(' || sys.dq(cname); set select_data_stmt = 'SELECT
(SELECT COUNT(*) FROM sys.dump_statem
ents) + RANK() OVER(), ' || sys.prepare_esc(cname, ctype); while (k < m) do
set k = (select min(c.id) from sys.columns c where c.table_id = tid and c.id >
k); set cname = (select c.name from sys.columns c where c.id = k); set ctype =
(select c.type from sys.columns c where c.id = k); set copy_into_stmt =
(copy_into_stmt || ', ' || sys.dq(cname)); set select_data_stmt =
(select_data_stmt || '|| ''|'' || ' || sys.prepare_esc(cname, ctype)); end
while; set copy_into_stmt = (copy_into_stmt || R') FROM STDIN USING DELIMITERS
''|'',E''\\n'',''\"'';'); set select_data_stmt = (select_data_stmt || ' FROM '
|| sys.fqn(sch, tbl)); insert into sys.dump_statements values ((select count(*)
from sys.dump_statements) + 1, copy_into_stmt); call sys.eval('INSERT INTO
sys.dump_statements ' || select_data_stmt || ';'); end if; end if; end if;
end;", "sql", "SQL", "Procedure", true, false, false, true,
NULL, "sch", "clob", 0, 0, "in", "tbl", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys.functions", "sys", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"char", 0, 0, "in", "arg_2", "char", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "editdistance", "SYSTEM", "editdistance",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "editdistance2", "SYSTEM",
"editdistance2", "txtsim", "Internal C", "Scalar function",
false, false, false, true, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "char", 0, 0, "in", "arg_2", "char",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "editdistance2", "SYSTEM",
"editdistance2", "txtsim", "Internal C", "Scalar function",
false, false, false, true, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "clob", 0, 0, "in", "arg_2", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "editdistance2", "SYSTEM",
"editdistance2", "txtsim", "Internal C", "Scalar function",
false, false, false, true, NULL, "res_0", "int", 32, 0,
"out", "arg_1", "varchar", 0, 0, "in", "arg_2",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
+[ "sys.functions", "sys", "editdistance", "SYSTEM", "create
function sys.editdistance(x string, y string) returns int external name
txtsim.editdistance;", "txtsim", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "int", 32, 0, "out",
"x", "clob", 0, 0, "in", "y", "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", "editdistance2", "SYSTEM", "create
function sys.editdistance2(x string, y string) returns int external name
txtsim.editdistance2;", "txtsim", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "int", 32, 0,
"out", "x", "clob", 0, 0, "in", "y", "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", "endswith", "SYSTEM", "create filter
function sys.endswith(s1 string, s2 string) external name str.\"endsWith\";",
"str", "MAL", "Filter function", false, false, false, true, NULL,
"s1", "clob", 0, 0, "in", "s2", "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", "endswith", "SYSTEM", "create filter
function sys.endswith(s1 string, s2 string, icase boolean) external name
str.\"endsWith\";", "str", "MAL", "Filter function", false, false,
false, true, NULL, "s1", "clob", 0, 0, "in", "s2", "clob",
0, 0, "in", "icase", "boolean", 1, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "endswith", "SYSTEM", "create
function sys.endswith(x string, y string) returns boolean external name
str.\"endsWith\";", "str", "MAL", "Scalar function", false, false,
false, true, NULL, "result", "boolean", 1, 0, "out",
"x", "clob", 0, 0, "in", "y", "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", "endswith", "SYSTEM", "create
function sys.endswith(x string, y string, icase boolean) returns boolean
external name str.\"endsWith\";", "str", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "boolean", 1,
0, "out", "x", "clob", 0, 0, "in", "y", "clob", 0,
0, "in", "icase", "boolean", 1, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "env", "SYSTEM", "CREATE FUNCTION env()
RETURNS TABLE(name varchar(1024), value varchar(2048)) EXTERNAL NAME
inspect.\"getEnvironment\";", "inspect", "MAL", "Function returning
a table", false, false, false, true, NULL, "name", "varchar",
1024, 0, "out", "value", "varchar", 2048, 0, "out",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "epoch", "SYSTEM", "create
function sys.epoch(sec decimal(18,3)) returns timestamp with time zone external
name mtime.epoch;", "mtime", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "timestamptz", 7, 0,
"out", "sec", "decimal", 18, 3, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "epoch", "SYSTEM", "create
function sys.epoch(sec int) returns timestamp with time zone external name
mtime.epoch;", "mtime", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "timestamptz", 7, 0,
"out", "sec", "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 ]
@@ -1645,7 +1655,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "generate_series", "SYSTEM", "create
function sys.generate_series(first tinyint, \"limit\" tinyint, stepsize
tinyint) returns table (value tinyint) external name generator.series;",
"generator", "MAL", "Function returning a table", false, false, false,
true, NULL, "value", "tinyint", 8, 0, "out",
"first", "tinyint", 8, 0, "in", "limit",
"tinyint", 8, 0, "in", "stepsize", "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 ]
[ "sys.functions", "sys", "geometrytype", "SYSTEM", "create
function geometrytype(geom geometry) returns string external name
geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "clob", 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", "get_merge_table_partition_expressions",
"SYSTEM", "create function sys.get_merge_table_partition_expressions(tid
int) returns string begin return select case when tp.table_id is not null then
' PARTITION BY ' || ifthenelse(bit_and(tp.type, 2) = 2, 'VALUES ', 'RANGE ') ||
case when bit_and(tp.type, 4) = 4 then 'ON ' || '(' || (select sys.dq(c.name)
|| ')' from sys.columns c where c.id = tp.column_id) else 'USING ' || '(' ||
tp.expression || ')' end else '' end from (values (tid)) t(id) left join
sys.table_partitions tp on t.id = tp.table_id; end;", "sql", "SQL", "Scalar
function", false, false, false, true, NULL, "result", "clob",
0, 0, "out", "tid", "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", "get_remote_table_expressions", "SYSTEM",
"create function sys.get_remote_table_expressions(s string, t string) returns
string begin return select ' ON ' || sys.sq(uri) || ' WITH USER ' ||
sys.sq(username) || ' ENCRYPTED PASSWORD ' || sys.sq(\"hash\") from
sys.remote_table_credentials(s ||'.' || t); end;", "sql", "SQL",
"Scalar function", false, false, false, true, NULL, "result",
"clob", 0, 0, "out", "s", "clob", 0, 0, "in", "t",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "get_remote_table_expressions", "SYSTEM",
"create function sys.get_remote_table_expressions(s string, t string) returns
string begin return select ' ON ' || sys.sq(tt.query) || ' WITH USER ' ||
sys.sq(username) || ' ENCRYPTED PASSWORD ' ||
sys.sq(sys.decypher(\"password\")) from sys.remote_user_info r, sys._tables tt,
sys.schemas ss where tt.name = t and ss.name = s and tt.schema_id = ss.id and
r.table_id = tt.id; end;", "sql", "SQL", "Scalar function", false,
false, false, true, NULL, "result", "clob", 0, 0, "out",
"s", "clob", 0, 0, "in", "t", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "get_type", "SYSTEM", "create
function get_type(info integer, format integer) returns string external name
geom.\"getType\";", "geom", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "clob", 0, 0, "out",
"info", "int", 32, 0, "in", "format", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "get_value_for", "SYSTEM",
"get_value", "sql", "Internal C", "Scalar function", false, false,
false, true, NULL, "res_0", "bigint", 64, 0, "out",
"arg_1", "char", 0, 0, "in", "arg_2", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "get_value_for", "SYSTEM",
"get_value", "sql", "Internal C", "Scalar function", false, false,
false, true, NULL, "res_0", "bigint", 64, 0, "out",
"arg_1", "clob", 0, 0, "in", "arg_2", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -1730,12 +1740,9 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "length", "SYSTEM", "length",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "int", 32, 0, "out", "arg_1", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "length", "SYSTEM", "length",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "length", "SYSTEM", "nitems",
"blob", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "int", 32, 0, "out", "arg_1", "blob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
-[ "sys.functions", "sys", "levenshtein", "SYSTEM", "levenshtein",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"char", 0, 0, "in", "arg_2", "char", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "levenshtein", "SYSTEM", "levenshtein",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"char", 0, 0, "in", "arg_2", "char", 0, 0, "in",
"arg_3", "int", 32, 0, "in", "arg_4", "int", 32,
0, "in", "arg_5", "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 ]
-[ "sys.functions", "sys", "levenshtein", "SYSTEM", "levenshtein",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "levenshtein", "SYSTEM", "levenshtein",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"clob", 0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "int", 32, 0, "in", "arg_4", "int", 32,
0, "in", "arg_5", "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 ]
-[ "sys.functions", "sys", "levenshtein", "SYSTEM", "levenshtein",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "levenshtein", "SYSTEM", "levenshtein",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", "arg_3", "int", 32, 0, "in", "arg_4",
"int", 32, 0, "in", "arg_5", "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
]
+[ "sys.functions", "sys", "levenshtein", "SYSTEM", "create
function sys.levenshtein(x string, y string) returns int external name
txtsim.levenshtein;", "txtsim", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "int", 32, 0, "out",
"x", "clob", 0, 0, "in", "y", "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", "levenshtein", "SYSTEM", "create
function sys.levenshtein(x string, y string, insdel int, rep int) returns int
external name txtsim.levenshtein;", "txtsim", "MAL", "Scalar
function", false, false, false, true, NULL, "result", "int",
32, 0, "out", "x", "clob", 0, 0, "in", "y", "clob",
0, 0, "in", "insdel", "int", 32, 0, "in", "rep",
"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 ]
+[ "sys.functions", "sys", "levenshtein", "SYSTEM", "create
function sys.levenshtein(x string, y string, insdel int, rep int, trans int)
returns int external name txtsim.levenshtein;", "txtsim", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"int", 32, 0, "out", "x", "clob", 0, 0, "in", "y",
"clob", 0, 0, "in", "insdel", "int", 32, 0, "in",
"rep", "int", 32, 0, "in", "trans", "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 ]
[ "sys.functions", "sys", "like", "SYSTEM", "like", "algebra",
"Internal C", "Filter function", false, false, false, false, NULL,
"res_0", "boolean", 1, 0, "out", "arg_1", "char",
0, 0, "in", "arg_2", "char", 0, 0, "in",
"arg_3", "char", 0, 0, "in", "arg_4", "boolean",
1, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "like", "SYSTEM", "like", "algebra",
"Internal C", "Filter function", false, false, false, false, NULL,
"res_0", "boolean", 1, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "clob", 0, 0, "in",
"arg_3", "clob", 0, 0, "in", "arg_4", "boolean",
1, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "like", "SYSTEM", "like", "algebra",
"Internal C", "Filter function", false, false, false, false, NULL,
"res_0", "boolean", 1, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "varchar", 0,
0, "in", "arg_3", "varchar", 0, 0, "in",
"arg_4", "boolean", 1, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
@@ -1783,6 +1790,8 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "masklen", "SYSTEM", "create
function \"masklen\" (p inet) returns int external name inet.\"masklen\";",
"inet", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "int", 32, 0, "out", "p", "inet", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys.functions", "sys", "max", "SYSTEM", "max", "aggr",
"Internal C", "Aggregate function", false, false, false, false, NULL,
"res_0", "any", 0, 0, "out", "arg_1", "any", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "max", "SYSTEM", "max", "sql",
"Internal C", "Analytic function", false, false, false, true, NULL,
"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", "maxlevenshtein", "SYSTEM", "create
filter function sys.maxlevenshtein(x string, y string, k int) external name
txtsim.\"maxlevenshtein\";", "txtsim", "MAL", "Filter function",
false, false, false, true, NULL, "x", "clob", 0, 0,
"in", "y", "clob", 0, 0, "in", "k", "int", 32, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "maxlevenshtein", "SYSTEM", "create
filter function sys.maxlevenshtein(x string, y string, k int, insdel int, rep
int) external name txtsim.\"maxlevenshtein\";", "txtsim", "MAL",
"Filter function", false, false, false, true, NULL, "x", "clob",
0, 0, "in", "y", "clob", 0, 0, "in", "k", "int",
32, 0, "in", "insdel", "int", 32, 0, "in", "rep",
"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 ]
[ "sys.functions", "sys", "mbr", "SYSTEM", "create function
mbr(geom geometry) returns mbr external name geom.\"mbr\";", "geom", "MAL",
"Scalar function", false, false, false, true, NULL, "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, true,
NULL, "res_0", "boolean", 1, 0, "out", "arg_1",
"geometry", 0, 0, "in", "arg_2", "geometry", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "mbr_above", "SYSTEM", "mbrAbove",
"geom", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "boolean", 1, 0, "out", "arg_1",
"mbr", 0, 0, "in", "arg_2", "mbr", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -1833,6 +1842,7 @@ select 'null in fkeys.delete_action', de
[ "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, true, NULL, "result", "double", 53, 0,
"out", "val", "tinyint", 8, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "min", "SYSTEM", "min", "aggr",
"Internal C", "Aggregate function", false, false, false, false, NULL,
"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, true, NULL,
"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", "minjarowinkler", "SYSTEM", "create
filter function minjarowinkler(x string, y string, threshold double) external
name txtsim.\"minjarowinkler\";", "txtsim", "MAL", "Filter function",
false, false, false, true, NULL, "x", "clob", 0, 0, "in",
"y", "clob", 0, 0, "in", "threshold", "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", "minute", "SYSTEM", "minutes",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 32, 0, "out", "arg_1",
"day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "minute", "SYSTEM", "minutes",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "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,
false, NULL, "res_0", "tinyint", 8, 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 ]
@@ -1908,9 +1918,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, true, NULL,
"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, true, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "prod", "SYSTEM", "prod", "sql",
"Internal C", "Analytic function", false, false, false, true, NULL,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "qgramnormalize", "SYSTEM",
"qgramnormalize", "txtsim", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "char", 0, 0,
"out", "arg_1", "char", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "qgramnormalize", "SYSTEM",
"qgramnormalize", "txtsim", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "clob", 0, 0,
"out", "arg_1", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "qgramnormalize", "SYSTEM",
"qgramnormalize", "txtsim", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "varchar", 0,
0, "out", "arg_1", "varchar", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "qgramnormalize", "SYSTEM", "create
function sys.qgramnormalize(x string) returns string external name
txtsim.qgramnormalize;", "txtsim", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "clob", 0, 0,
"out", "x", "clob", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "quantile", "SYSTEM", "create
aggregate quantile(val bigint, q double) returns bigint external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "bigint", 64, 0,
"out", "val", "bigint", 64, 0, "in", "q", "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", "quantile", "SYSTEM", "create
aggregate quantile(val date, q double) returns date external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "date", 0, 0, "out",
"val", "date", 0, 0, "in", "q", "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", "quantile", "SYSTEM", "create
aggregate quantile(val decimal, q double) returns decimal external name
\"aggr\".\"quantile\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "decimal", 18, 3,
"out", "val", "decimal", 18, 3, "in", "q", "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 ]
@@ -1952,7 +1960,6 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "regexp_replace", "SYSTEM", "create
function sys.regexp_replace(ori string, pat string, rep string) returns string
begin return sys.regexp_replace(ori, pat, rep, ''); end;", "sql", "SQL",
"Scalar function", false, false, false, true, NULL, "result",
"clob", 0, 0, "out", "ori", "clob", 0, 0, "in", "pat",
"clob", 0, 0, "in", "rep", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "regexp_replace", "SYSTEM", "create
function sys.regexp_replace(ori string, pat string, rep string, flg string)
returns string external name pcre.replace;", "pcre", "MAL", "Scalar
function", false, false, false, true, NULL, "result", "clob",
0, 0, "out", "ori", "clob", 0, 0, "in", "pat", "clob",
0, 0, "in", "rep", "clob", 0, 0, "in", "flg", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "rejects", "SYSTEM", "create
function sys.rejects() returns table(rowid bigint, fldid int, \"message\"
string, \"input\" string) external name sql.copy_rejects;", "sql", "MAL",
"Function returning a table", false, false, false, true, NULL,
"rowid", "bigint", 64, 0, "out", "fldid", "int",
32, 0, "out", "message", "clob", 0, 0, "out",
"input", "clob", 0, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "remote_table_credentials", "SYSTEM",
"create function sys.remote_table_credentials (tablename string) returns table
(\"uri\" string, \"username\" string, \"hash\" string) external name
sql.rt_credentials;", "sql", "MAL", "Function returning a table",
false, false, false, true, NULL, "uri", "clob", 0, 0, "out",
"username", "clob", 0, 0, "out", "hash", "clob", 0, 0,
"out", "tablename", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "repeat", "SYSTEM", "repeat",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "char", 0, 0, "out", "arg_1", "char",
0, 0, "in", "arg_2", "int", 32, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "repeat", "SYSTEM", "repeat",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "clob", 0, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "int", 32, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "repeat", "SYSTEM", "repeat",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "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 ]
@@ -2033,16 +2040,12 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "sign", "SYSTEM", "sign", "calc",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "tinyint", 8, 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", "sign", "SYSTEM", "sign", "calc",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "tinyint", 8, 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", "sign", "SYSTEM", "sign", "calc",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "tinyint", 8, 0, "out", "arg_1",
"tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "similarity", "SYSTEM", "similarity",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "double", 53, 0, "out",
"arg_1", "char", 0, 0, "in", "arg_2", "char", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "similarity", "SYSTEM", "similarity",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "double", 53, 0, "out",
"arg_1", "clob", 0, 0, "in", "arg_2", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "similarity", "SYSTEM", "similarity",
"txtsim", "Internal C", "Scalar function", false, false, false,
true, NULL, "res_0", "double", 53, 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", "similarity", "SYSTEM", "create
function sys.similarity(x string, y string) returns double external name
txtsim.similarity;", "txtsim", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "x", "clob", 0, 0, "in", "y", "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", "sin", "SYSTEM", "sin", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "sin", "SYSTEM", "sin", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "sinh", "SYSTEM", "sinh", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "sinh", "SYSTEM", "sinh", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"res_0", "real", 24, 0, "out", "arg_1", "real", 24,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys.functions", "sys", "soundex", "SYSTEM", "soundex",
"txtsim", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "char", 0, 0, "out", "arg_1",
"char", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "soundex", "SYSTEM", "soundex",
"txtsim", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "clob", 0, 0, "out", "arg_1",
"clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys.functions", "sys", "soundex", "SYSTEM", "soundex",
"txtsim", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "varchar", 0, 0, "out",
"arg_1", "varchar", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "soundex", "SYSTEM", "create
function sys.soundex(x string) returns string external name txtsim.soundex;",
"txtsim", "MAL", "Scalar function", false, false, false, true,
NULL, "result", "clob", 0, 0, "out", "x", "clob", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "space", "SYSTEM", "space",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "char", 0, 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", "space", "SYSTEM", "space",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "clob", 0, 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", "space", "SYSTEM", "space",
"str", "Internal C", "Scalar function", false, false, false, true,
NULL, "res_0", "varchar", 0, 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 ]
@@ -2381,6 +2384,10 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "st_ymin", "SYSTEM", "create
function st_ymin(box mbr) returns double external name geom.\"YMinFromMBR\";",
"geom", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "box", "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, NULL, NULL, NULL,
NULL, NULL ]
[ "sys.functions", "sys", "st_ymin", "SYSTEM", "create
function st_ymin(geom geometry) returns double external name
geom.\"YMinFromWKB\";", "geom", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "double", 53, 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", "st_z", "SYSTEM", "create function
st_z(geom geometry) returns double external name geom.\"Z\";", "geom", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"double", 53, 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", "startswith", "SYSTEM", "create filter
function sys.startswith(x string, y string) external name str.\"startsWith\";",
"str", "MAL", "Filter function", false, false, false, true, NULL,
"x", "clob", 0, 0, "in", "y", "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", "startswith", "SYSTEM", "create filter
function sys.startswith(x string, y string, icase boolean) external name
str.\"startsWith\";", "str", "MAL", "Filter function", false, false,
false, true, NULL, "x", "clob", 0, 0, "in", "y", "clob",
0, 0, "in", "icase", "boolean", 1, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "startswith", "SYSTEM", "create
function sys.startswith(x string, y string) returns boolean external name
str.\"startsWith\";", "str", "MAL", "Scalar function", false, false,
false, true, NULL, "result", "boolean", 1, 0, "out",
"x", "clob", 0, 0, "in", "y", "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", "startswith", "SYSTEM", "create
function sys.startswith(x string, y string, icase boolean) returns boolean
external name str.\"startsWith\";", "str", "MAL", "Scalar function",
false, false, false, true, NULL, "result", "boolean", 1,
0, "out", "x", "clob", 0, 0, "in", "y", "clob", 0,
0, "in", "icase", "boolean", 1, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "statistics", "SYSTEM", "create
function sys.\"statistics\"(\"sname\" varchar(1024)) returns table
(\"column_id\" integer, \"schema\" varchar(1024), \"table\" varchar(1024),
\"column\" varchar(1024), \"type\" varchar(1024), \"width\" integer, \"count\"
bigint, \"unique\" boolean, \"nils\" boolean, \"minval\" string, \"maxval\"
string, \"sorted\" boolean, \"revsorted\" boolean) external name
sql.\"statistics\";", "sql", "MAL", "Function returning a table", false,
false, false, true, NULL, "column_id", "int", 32, 0, "out",
"schema", "varchar", 1024, 0, "out", "table",
"varchar", 1024, 0, "out", "column", "varchar", 1024,
0, "out", "type", "varchar", 1024, 0, "out", "width",
"int", 32, 0, "out", "count", "bigint", 64, 0,
"out", "unique", "boolean", 1, 0, "out", "nils",
"boolean", 1, 0, "out", "minval", "clob", 0, 0,
"out", "maxval", "clob", 0, 0, "out", "sorted",
"boolean", 1, 0, "out", "revsorted", "boolean", 1,
0, "out", "sname", "varchar", 1024, 0, "in", NU
LL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "statistics", "SYSTEM", "create
function sys.\"statistics\"(\"sname\" varchar(1024), \"tname\" varchar(1024))
returns table (\"column_id\" integer, \"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"width\"
integer, \"count\" bigint, \"unique\" boolean, \"nils\" boolean, \"minval\"
string, \"maxval\" string, \"sorted\" boolean, \"revsorted\" boolean) external
name sql.\"statistics\";", "sql", "MAL", "Function returning a table",
false, false, false, true, NULL, "column_id", "int", 32, 0,
"out", "schema", "varchar", 1024, 0, "out", "table",
"varchar", 1024, 0, "out", "column", "varchar", 1024,
0, "out", "type", "varchar", 1024, 0, "out", "width",
"int", 32, 0, "out", "count", "bigint", 64, 0,
"out", "unique", "boolean", 1, 0, "out", "nils",
"boolean", 1, 0, "out", "minval", "clob", 0, 0,
"out", "maxval", "clob", 0, 0, "out", "sorted",
"boolean", 1, 0, "out", "revsorted", "boolean", 1,
0, "out", "sname", "va
rchar", 1024, 0, "in", "tname", "varchar", 1024,
0, "in", NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "statistics", "SYSTEM", "create
function sys.\"statistics\"(\"sname\" varchar(1024), \"tname\" varchar(1024),
\"cname\" varchar(1024)) returns table (\"column_id\" integer, \"schema\"
varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\"
varchar(1024), \"width\" integer, \"count\" bigint, \"unique\" boolean,
\"nils\" boolean, \"minval\" string, \"maxval\" string, \"sorted\" boolean,
\"revsorted\" boolean) external name sql.\"statistics\";", "sql", "MAL",
"Function returning a table", false, false, false, true, NULL,
"column_id", "int", 32, 0, "out", "schema", "varchar",
1024, 0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "width", "int", 32, 0, "out",
"count", "bigint", 64, 0, "out", "unique",
"boolean", 1, 0, "out", "nils", "boolean", 1, 0,
"out", "minval", "clob", 0, 0, "out", "maxval", "clob",
0, 0, "out", "sorted", "boolean", 1, 0, "out",
"revsorted", "boolean",
1, 0, "out", "sname", "varchar", 1024, 0, "in",
"tname", "varchar", 1024, 0, "in", "cname",
"varchar", 1024, 0, "in" ]
@@ -2600,7 +2607,7 @@ select 'null in fkeys.delete_action', de
% .%1, .s1, .f1, .s2, .f2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar # type
-% 25, 3, 24, 3, 37, 9 # length
+% 25, 3, 17, 3, 37, 9 # length
[ "function used by function", "sys", "describe_type", "sys",
"describe_columns", "FUNCTION" ]
[ "function used by function", "sys", "dump_table_data", "sys",
"dump_database", "FUNCTION" ]
[ "function used by function", "sys", "dq", "sys", "dump_table_data",
"PROCEDURE" ]
@@ -2610,7 +2617,7 @@ select 'null in fkeys.delete_action', de
[ "function used by function", "sys", "prepare_esc", "sys",
"dump_table_data", "PROCEDURE" ]
[ "function used by function", "sys", "storage", "sys",
"dump_table_data", "PROCEDURE" ]
[ "function used by function", "sys", "dq", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
-[ "function used by function", "sys", "remote_table_credentials", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "function used by function", "sys", "decypher", "sys",
"get_remote_table_expressions", "FUNCTION" ]
[ "function used by function", "sys", "sq", "sys",
"get_remote_table_expressions", "FUNCTION" ]
[ "function used by function", "sys", "ms_trunc", "sys", "ms_round",
"FUNCTION" ]
[ "function used by function", "sys", "dq", "sys", "prepare_esc",
"FUNCTION" ]
@@ -2670,6 +2677,9 @@ select 'null in fkeys.delete_action', de
[ "table used by function", "sys", "tables", "sys",
"dump_table_data", "PROCEDURE" ]
[ "table used by function", "sys", "columns", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
[ "table used by function", "sys", "table_partitions", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
+[ "table used by function", "sys", "_tables", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "table used by function", "sys", "remote_user_info", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "table used by function", "sys", "schemas", "sys",
"get_remote_table_expressions", "FUNCTION" ]
[ "table used by function", "sys", "spatial_ref_sys", "sys",
"getproj4", "FUNCTION" ]
[ "table used by function", "sys", "columns", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "table used by function", "sys", "keys", "sys", "storagemodelinit",
"PROCEDURE" ]
@@ -2791,6 +2801,15 @@ select 'null in fkeys.delete_action', de
[ "column used by function", "sys", "table_partitions", "id", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "table_id",
"sys", "get_merge_table_partition_expressions", "FUNCTION" ]
[ "column used by function", "sys", "table_partitions", "type", "sys",
"get_merge_table_partition_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "_tables", "id", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "_tables", "name", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "_tables", "query", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "_tables", "schema_id", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "remote_user_info", "password",
"sys", "get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "remote_user_info", "table_id",
"sys", "get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "remote_user_info", "username",
"sys", "get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "schemas", "id", "sys",
"get_remote_table_expressions", "FUNCTION" ]
+[ "column used by function", "sys", "schemas", "name", "sys",
"get_remote_table_expressions", "FUNCTION" ]
[ "column used by function", "sys", "spatial_ref_sys", "proj4text",
"sys", "getproj4", "FUNCTION" ]
[ "column used by function", "sys", "spatial_ref_sys", "srid", "sys",
"getproj4", "FUNCTION" ]
[ "column used by function", "sys", "columns", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
@@ -2826,7 +2845,7 @@ select 'null in fkeys.delete_action', de
[ "column used by function", "sys", "tables", "id", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "name", "sys",
"storagemodelinit", "PROCEDURE" ]
[ "column used by function", "sys", "tables", "schema_id", "sys",
"storagemodelinit", "PROCEDURE" ]
-% .%1, sys.s1, sys.f1, sys.s2, sys.t2, .dt # table_name
+% .%1, .s1, .f1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar # type
% 21, 7, 37, 7, 26, 4 # length
@@ -2909,7 +2928,7 @@ select 'null in fkeys.delete_action', de
[ "function used by view", "sys", "heapsize", "sys",
"tablestoragemodel", "VIEW" ]
[ "function used by view", "sys", "imprintsize", "sys",
"tablestoragemodel", "VIEW" ]
[ "function used by view", "sys", "tracelog", "sys", "tracelog",
"VIEW" ]
-% .%1, sys.s1, sys.t1, sys.s2, sys.t2, .dt # table_name
+% .%1, .s1, .t1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar # type
% 18, 3, 27, 3, 34, 4 # length
@@ -3131,7 +3150,7 @@ select 'null in fkeys.delete_action', de
[ "table used by view", "sys", "storage", "sys", "tablestorage",
"VIEW" ]
[ "table used by view", "sys", "storagemodelinput", "sys",
"tablestoragemodel", "VIEW" ]
[ "table used by view", "sys", "db_user_info", "sys", "users",
"VIEW" ]
-% .%1, sys.s1, sys.t1, sys.c1, sys.s2, sys.t2, .dt # table_name
+% .%1, .s1, .t1, .c1, .s2, .t2, .dt # table_name
% %1, name, name, name, name, name, dependency_type_name # name
% char, varchar, varchar, varchar, varchar,
varchar, varchar # type
% 19, 3, 27, 21, 3, 34, 4 # length
@@ -3898,7 +3917,7 @@ select 'null in fkeys.delete_action', de
[ "column used by view", "sys", "db_user_info", "name", "sys",
"users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "optimizer", "sys",
"users", "VIEW" ]
[ "column used by view", "sys", "db_user_info", "schema_path", "sys",
"users", "VIEW" ]
-% .%1, sys.s1, sys.t1, sys.c1, sys.s2, sys.t2, sys.k2, .dt # table_name
+% .%1, .s1, .t1, .c1, .s2, .t2, .k2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
% char, varchar, varchar, varchar, varchar,
varchar, varchar, varchar # type
% 18, 3, 18, 20, 3, 18, 44, 3 # length
@@ -3920,7 +3939,7 @@ select 'null in fkeys.delete_action', de
[ "column used by key", "sys", "spatial_ref_sys", "srid", "sys",
"spatial_ref_sys", "spatial_ref_sys_srid_pkey", "KEY" ]
[ "column used by key", "sys", "table_types", "table_type_id",
"sys", "table_types", "table_types_table_type_id_pkey", "KEY" ]
[ "column used by key", "sys", "table_types", "table_type_name",
"sys", "table_types", "table_types_table_type_name_unique", "KEY" ]
-% .%1, sys.s1, sys.t1, sys.c1, sys.s2, sys.t2, sys.i2, .dt # table_name
+% .%1, .s1, .t1, .c1, .s2, .t2, .i2, .dt # table_name
% %1, name, name, name, name, name, name, dependency_type_name #
name
% char, varchar, varchar, varchar, varchar,
varchar, varchar, varchar # type
% 20, 3, 18, 20, 3, 18, 44, 5 # length
@@ -3942,7 +3961,7 @@ select 'null in fkeys.delete_action', de
[ "column used by index", "sys", "spatial_ref_sys", "srid", "sys",
"spatial_ref_sys", "spatial_ref_sys_srid_pkey", "INDEX" ]
[ "column used by index", "sys", "table_types", "table_type_id",
"sys", "table_types", "table_types_table_type_id_pkey", "INDEX" ]
[ "column used by index", "sys", "table_types", "table_type_name",
"sys", "table_types", "table_types_table_type_name_unique", "INDEX" ]
-% .%1, sys.t, sys.t, .s, .f, .dt # table_name
+% .%1, .t, .t, .s, .f, .dt # table_name
% %1, systemname, sqlname, name, name, dependency_type_name #
name
% char, varchar, varchar, varchar, varchar,
varchar # type
% 21, 4, 4, 4, 18, 4 # length
@@ -4073,13 +4092,13 @@ select 'null in fkeys.delete_action', de
[ "sys.objects", "table_type_id", "0", NULL ]
[ "sys.objects", "table_type_name", "0", NULL ]
[ "sys.objects", "table_type_name", "0", NULL ]
-% .%1, sys.s, sys.u # table_name
+% .%1, .s, .u # table_name
% %1, name, name # name
% char, varchar, varchar # type
% 22, 3, 9 # length
[ "default schema of user", "sys", ".snapshot" ]
[ "default schema of user", "sys", "monetdb" ]
-% .%1, sys.t, sys.a, .pc, .g, .p # table_name
+% .%1, .t, .a, .pc, .g, .p # table_name
% %1, name, name, privilege_code_name, name, grantable # name
% char, varchar, varchar, varchar, varchar,
int # type
% 14, 34, 7, 6, 7, 1 # length
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]