Changeset: cd82b1f31b9d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=cd82b1f31b9d
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/exports.stable.out
monetdb5/modules/atoms/uuid.c
monetdb5/modules/atoms/uuid.mal
sql/backends/monet5/sql_statement.c
sql/server/rel_select.c
sql/server/sql_mvc.h
sql/storage/store.c
sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/mergetables/Tests/mergequery.stable.out
sql/test/miscellaneous/Tests/simple_selects.stable.out
Branch: default
Log Message:
Merge with Aug2018 branch.
diffs (truncated from 750 to 300 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -11379,7 +11379,8 @@ Ready.
[ "uuid", "#tostr", "command uuid.#tostr():void ",
"UUIDtoString;", "" ]
[ "uuid", "#write", "command uuid.#write():void ", "UUIDwrite;",
"" ]
[ "uuid", "isaUUID", "command uuid.isaUUID(u:str):bit ",
"UUIDisaUUID;", "Test a string for a UUID format" ]
-[ "uuid", "new", "command uuid.new():uuid ", "UUIDgenerateUuid;",
"Generate a new uuid" ]
+[ "uuid", "new", "unsafe command uuid.new():uuid ",
"UUIDgenerateUuid;", "Generate a new uuid" ]
+[ "uuid", "new", "unsafe command uuid.new(d:int):uuid ",
"UUIDgenerateUuidInt;", "Generate a new uuid (dummy version for side effect
free multiplex loop)" ]
[ "uuid", "prelude", "command uuid.prelude():void ", "UUIDprelude;",
"" ]
[ "uuid", "str", "command uuid.str(u:uuid):str ",
"UUIDuuid2str;", "Coerce a uuid to its string type" ]
[ "uuid", "uuid", "command uuid.uuid(s:str):uuid ",
"UUIDstr2uuid;", "Coerce a string to a uuid, validating its format"
]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -15625,7 +15625,8 @@ Ready.
[ "uuid", "#tostr", "command uuid.#tostr():void ",
"UUIDtoString;", "" ]
[ "uuid", "#write", "command uuid.#write():void ", "UUIDwrite;",
"" ]
[ "uuid", "isaUUID", "command uuid.isaUUID(u:str):bit ",
"UUIDisaUUID;", "Test a string for a UUID format" ]
-[ "uuid", "new", "command uuid.new():uuid ", "UUIDgenerateUuid;",
"Generate a new uuid" ]
+[ "uuid", "new", "unsafe command uuid.new():uuid ",
"UUIDgenerateUuid;", "Generate a new uuid" ]
+[ "uuid", "new", "unsafe command uuid.new(d:int):uuid ",
"UUIDgenerateUuidInt;", "Generate a new uuid (dummy version for side effect
free multiplex loop)" ]
[ "uuid", "prelude", "command uuid.prelude():void ", "UUIDprelude;",
"" ]
[ "uuid", "str", "command uuid.str(u:uuid):str ",
"UUIDuuid2str;", "Coerce a uuid to its string type" ]
[ "uuid", "uuid", "command uuid.uuid(s:str):uuid ",
"UUIDstr2uuid;", "Coerce a string to a uuid, validating its format"
]
diff --git a/clients/Tests/exports.stable.out b/clients/Tests/exports.stable.out
--- a/clients/Tests/exports.stable.out
+++ b/clients/Tests/exports.stable.out
@@ -1951,6 +1951,7 @@ int UUIDcompare(const uuid *l, const uui
str UUIDequal(bit *retval, uuid **l, uuid **r);
ssize_t UUIDfromString(const char *svalue, size_t *len, uuid **retval, bool
external);
str UUIDgenerateUuid(uuid **retval);
+str UUIDgenerateUuidInt(uuid **retval, int *d);
BUN UUIDhash(const void *u);
str UUIDisaUUID(bit *retval, str *u);
const uuid *UUIDnull(void);
diff --git a/monetdb5/modules/atoms/uuid.c b/monetdb5/modules/atoms/uuid.c
--- a/monetdb5/modules/atoms/uuid.c
+++ b/monetdb5/modules/atoms/uuid.c
@@ -60,6 +60,7 @@ mal_export ssize_t UUIDtoString(str *ret
mal_export gdk_return UUIDwrite(const uuid *u, stream *s, size_t cnt);
mal_export str UUIDgenerateUuid(uuid **retval);
+mal_export str UUIDgenerateUuidInt(uuid **retval, int *d);
mal_export str UUIDstr2uuid(uuid **retval, str *s);
mal_export str UUIDuuid2str(str *retval, uuid **u);
mal_export str UUIDisaUUID(bit *retval, str *u);
@@ -217,6 +218,13 @@ UUIDgenerateUuid(uuid **retval)
}
str
+UUIDgenerateUuidInt(uuid **retval, int *d)
+{
+ (void)d;
+ return UUIDgenerateUuid(retval);
+}
+
+str
UUIDisaUUID(bit *retval, str *s)
{
uuid u;
diff --git a/monetdb5/modules/atoms/uuid.mal b/monetdb5/modules/atoms/uuid.mal
--- a/monetdb5/modules/atoms/uuid.mal
+++ b/monetdb5/modules/atoms/uuid.mal
@@ -13,10 +13,15 @@ command write() address UUIDwrite;
command prelude():void address UUIDprelude;
uuid.prelude();
-command new() :uuid
+# unsafe is to prevent optimizers to reuse common expressions
+unsafe command new() :uuid
address UUIDgenerateUuid
comment "Generate a new uuid";
+unsafe command new(d:int) :uuid
+address UUIDgenerateUuidInt
+comment "Generate a new uuid (dummy version for side effect free multiplex
loop)";
+
command uuid(s:str):uuid
address UUIDstr2uuid
comment "Coerce a string to a uuid, validating its format";
diff --git a/sql/backends/monet5/sql_statement.c
b/sql/backends/monet5/sql_statement.c
--- a/sql/backends/monet5/sql_statement.c
+++ b/sql/backends/monet5/sql_statement.c
@@ -1995,7 +1995,7 @@ stmt_project(backend *be, stmt *op1, stm
s->op2 = op2;
s->flag = cmp_project;
s->key = 0;
- s->nrcols = 2;
+ s->nrcols = MAX(op1->nrcols,op2->nrcols);
s->nr = getDestVar(q);
s->q = q;
return s;
diff --git a/sql/server/rel_select.c b/sql/server/rel_select.c
--- a/sql/server/rel_select.c
+++ b/sql/server/rel_select.c
@@ -3143,7 +3143,7 @@ rel_unop(mvc *sql, sql_rel **rel, symbol
/* reset error */
sql->session->status = 0;
sql->errstr[0] = '\0';
- return sql_error(sql, 02, "SELECT: no such aggregate
'%s'", fname);
+ return sql_error(sql, 02, SQLSTATE(42000) "SELECT: no
such aggregate '%s'", fname);
}
return NULL;
}
@@ -3436,7 +3436,7 @@ rel_binop(mvc *sql, sql_rel **rel, symbo
/* reset error */
sql->session->status = 0;
sql->errstr[0] = '\0';
- return sql_error(sql, 02, "SELECT: no such aggregate '%s'",
fname);
+ return sql_error(sql, 02, SQLSTATE(42000) "SELECT: no such
aggregate '%s'", fname);
}
if (!l && !r && sf) { /* possibly we cannot resolve the argument as the
function maybe an aggregate */
/* reset error */
@@ -3526,7 +3526,7 @@ rel_nop(mvc *sql, sql_rel **rel, symbol
/* reset error */
sql->session->status = 0;
sql->errstr[0] = '\0';
- return sql_error(sql, 02, "SELECT: no such aggregate '%s'",
fname);
+ return sql_error(sql, 02, SQLSTATE(42000) "SELECT: no such
aggregate '%s'", fname);
}
if (f) {
if (err) {
@@ -5087,7 +5087,7 @@ rel_value_exp2(mvc *sql, sql_rel **rel,
e = _rel_lastexp(sql, r);
/* group by needed ? */
- if (e->card > CARD_ATOM && e->card > ek.card) {
+ if (e->card >= CARD_ATOM && e->card > ek.card) {
int processed = is_processed(r);
sql_subaggr *zero_or_one =
sql_bind_aggr(sql->sa, sql->session->schema, "zero_or_one", exp_subtype(e));
@@ -5258,8 +5258,11 @@ column_exp(mvc *sql, sql_rel **rel, symb
{
dlist *l = column_e->data.lval;
exp_kind ek = {type_value, card_column, FALSE};
- sql_exp *ve = rel_value_exp(sql, rel, l->h->data.sym, f, ek);
-
+ sql_exp *ve;
+
+ if (f == sql_sel && rel && *rel && (*rel)->card < CARD_AGGR)
+ ek.card = card_value;
+ ve = rel_value_exp(sql, rel, l->h->data.sym, f, ek);
if (!ve)
return NULL;
/* AS name */
diff --git a/sql/server/sql_mvc.h b/sql/server/sql_mvc.h
--- a/sql/server/sql_mvc.h
+++ b/sql/server/sql_mvc.h
@@ -30,11 +30,10 @@
#define type_value 0
#define type_predicate 1
-/* todo cleanup card_row and card_set, both seem to be not used */
/* cardinality expected by enclosing operator */
#define card_none -1 /* psm call doesn't return anything */
#define card_value 0
-#define card_row 1
+#define card_row 1 /* needed for subqueries on single value tables
(select (select 1))*/
#define card_column 2
#define card_set 3 /* some operators require only a set (IN/EXISTS) */
#define card_relation 4
diff --git a/sql/storage/store.c b/sql/storage/store.c
--- a/sql/storage/store.c
+++ b/sql/storage/store.c
@@ -979,6 +979,7 @@ load_func(sql_trans *tr, sql_schema *s,
}
if (t->type == F_FUNC && !t->res)
t->type = F_PROC;
+ t->side_effect = (t->type==F_FILT || (t->res && (t->lang==FUNC_LANG_SQL
|| !list_empty(t->ops))))?FALSE:TRUE;
return t;
}
@@ -4641,7 +4642,7 @@ create_sql_func(sql_allocator *sa, const
t->type = type;
t->lang = lang;
t->sql = (lang==FUNC_LANG_SQL||lang==FUNC_LANG_MAL);
- t->side_effect = (type==F_FILT||res)?FALSE:TRUE;
+ t->side_effect = (type==F_FILT || (res && (lang==FUNC_LANG_SQL ||
!list_empty(args))))?FALSE:TRUE;
t->varres = varres;
t->vararg = vararg;
t->ops = args;
@@ -4671,7 +4672,7 @@ sql_trans_create_func(sql_trans *tr, sql
t->type = type;
t->lang = lang;
t->sql = (lang==FUNC_LANG_SQL||lang==FUNC_LANG_MAL);
- se = t->side_effect = (type==F_FILT||res)?FALSE:TRUE;
+ se = t->side_effect = (type==F_FILT || (res && (lang==FUNC_LANG_SQL ||
!list_empty(args))))?FALSE:TRUE;
t->varres = varres;
t->vararg = vararg;
t->ops = sa_list(tr->sa);
diff --git
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
---
a/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
+++
b/sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085.stable.out
@@ -48,14 +48,14 @@ Ready.
#2086 "idxs" 2000 NULL 0 true 0 false 0
[ 40 ]
#SELECT 1, (SELECT count(*) FROM tbls);
-% .L2, sys.L7 # table_name
-% L2, L6 # name
+% .L2, .L7 # table_name
+% L2, L7 # name
% tinyint, bigint # type
% 1, 2 # length
[ 1, 40 ]
#SELECT (SELECT count(*) FROM tbls), 1;
-% sys.L5, .L7 # table_name
-% L4, L7 # name
+% .L5, .L7 # table_name
+% L5, L7 # name
% bigint, tinyint # type
% 2, 1 # length
[ 40, 1 ]
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -2146,7 +2146,7 @@ drop function pcre_replace(string, strin
[ "json", "tojsonarray", "SYSTEM", "create aggregate
json.tojsonarray(x double) returns string external name aggr.jsonaggr;",
"aggr", "MAL", "Aggregate function", false, false, false, "result",
"clob", 0, 0, "out", "x", "double", 53, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "json", "tojsonarray", "SYSTEM", "create aggregate
json.tojsonarray(x string) returns string external name aggr.jsonaggr;",
"aggr", "MAL", "Aggregate function", false, false, false, "result",
"clob", 0, 0, "out", "x", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "json", "valuearray", "SYSTEM", "create function
json.valuearray(js json) returns json external name json.valuearray;", "json",
"MAL", "Scalar function", false, false, false, "result", "json",
0, 0, "out", "js", "json", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "profiler", "getlimit", "SYSTEM", "create function
profiler.getlimit() returns integer external name profiler.getlimit;",
"profiler", "MAL", "Scalar function", false, false, false,
"result", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "profiler", "getlimit", "SYSTEM", "create function
profiler.getlimit() returns integer external name profiler.getlimit;",
"profiler", "MAL", "Scalar function", true, false, false,
"result", "int", 32, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "profiler", "setheartbeat", "SYSTEM", "create procedure
profiler.setheartbeat(beat int) external name profiler.setheartbeat;",
"profiler", "MAL", "Procedure", true, false, false, "beat", "int",
32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "profiler", "setlimit", "SYSTEM", "create procedure
profiler.setlimit(lim integer) external name profiler.setlimit;",
"profiler", "MAL", "Procedure", true, false, false, "lim", "int",
32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "profiler", "start", "SYSTEM", "create procedure
profiler.start() external name profiler.\"start\";", "profiler", "MAL",
"Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
@@ -2205,7 +2205,7 @@ drop function pcre_replace(string, strin
[ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "real", 24, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "smallint", 16, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "double",
53, 0, "out", "arg_1", "tinyint", 8, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "bbp", "SYSTEM", "create function sys.bbp () returns
table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt
int, location string, heat int, dirty string, status string, kind string)
external name bbp.get;", "bbp", "MAL", "Function returning a table",
false, false, false, "id", "int", 32, 0, "out", "name", "clob",
0, 0, "out", "ttype", "clob", 0, 0, "out",
"count", "bigint", 64, 0, "out", "refcnt", "int",
32, 0, "out", "lrefcnt", "int", 32, 0, "out",
"location", "clob", 0, 0, "out", "heat", "int", 32, 0,
"out", "dirty", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys", "bbp", "SYSTEM", "create function sys.bbp () returns
table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt
int, location string, heat int, dirty string, status string, kind string)
external name bbp.get;", "bbp", "MAL", "Function returning a table",
true, false, false, "id", "int", 32, 0, "out", "name", "clob",
0, 0, "out", "ttype", "clob", 0, 0, "out",
"count", "bigint", 64, 0, "out", "refcnt", "int",
32, 0, "out", "lrefcnt", "int", 32, 0, "out",
"location", "clob", 0, 0, "out", "heat", "int", 32, 0,
"out", "dirty", "clob", 0, 0, "out", "status", "clob",
0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "bit_and", "SYSTEM", "and", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "bigint",
64, 0, "out", "arg_1", "bigint", 64, 0, "in",
"arg_2", "bigint", 64, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "bit_and", "SYSTEM", "and", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "decimal",
2, 0, "out", "arg_1", "decimal", 2, 0, "in",
"arg_2", "decimal", 2, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "bit_and", "SYSTEM", "and", "calc", "Internal C",
"Scalar function", false, false, false, "res_0", "decimal",
4, 0, "out", "arg_1", "decimal", 4, 0, "in",
"arg_2", "decimal", 4, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
@@ -2481,13 +2481,13 @@ drop function pcre_replace(string, strin
[ "sys", "ltrim", "SYSTEM", "ltrim", "str",
"Internal C", "Scalar function", false, false, false, "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", "ltrim", "SYSTEM", "ltrim", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"varchar", 0, 0, "out", "arg_1", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "ltrim", "SYSTEM", "ltrim", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"varchar", 0, 0, "out", "arg_1", "varchar", 0,
0, "in", "arg_2", "varchar", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "malfunctions", "SYSTEM", "create function
sys.malfunctions() returns table(\"module\" string, \"function\" string,
\"signature\" string, \"address\" string, \"comment\" string) external name
\"manual\".\"functions\";", "manual", "MAL", "Function returning a
table", false, false, false, "module", "clob", 0, 0,
"out", "function", "clob", 0, 0, "out", "signature", "clob",
0, 0, "out", "address", "clob", 0, 0, "out",
"comment", "clob", 0, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys", "malfunctions", "SYSTEM", "create function
sys.malfunctions() returns table(\"module\" string, \"function\" string,
\"signature\" string, \"address\" string, \"comment\" string) external name
\"manual\".\"functions\";", "manual", "MAL", "Function returning a
table", true, false, false, "module", "clob", 0, 0,
"out", "function", "clob", 0, 0, "out", "signature", "clob",
0, 0, "out", "address", "clob", 0, 0, "out",
"comment", "clob", 0, 0, "out", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "masklen", "SYSTEM", "create function \"masklen\" (p
inet) returns int external name inet.\"masklen\";", "inet", "MAL", "Scalar
function", false, false, false, "result", "int", 32, 0,
"out", "p", "inet", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "master", "SYSTEM", "create procedure master()
external name wlc.master;", "wlc", "MAL", "Procedure", true, false,
false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "master", "SYSTEM", "create procedure master(path
string) external name wlc.master;", "wlc", "MAL", "Procedure", true,
false, false, "path", "clob", 0, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "masterbeat", "SYSTEM", "create procedure
masterbeat(duration int) external name wlc.\"setmasterbeat\";", "wlc",
"MAL", "Procedure", true, false, false, "duration", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "masterclock", "SYSTEM", "create function masterclock()
returns string external name wlc.\"getmasterclock\";", "wlc", "MAL",
"Scalar function", false, false, false, "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", "mastertick", "SYSTEM", "create function mastertick()
returns bigint external name wlc.\"getmastertick\";", "wlc", "MAL",
"Scalar function", false, false, false, "result", "bigint",
64, 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", "masterclock", "SYSTEM", "create function masterclock()
returns string external name wlc.\"getmasterclock\";", "wlc", "MAL",
"Scalar function", true, false, false, "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", "mastertick", "SYSTEM", "create function mastertick()
returns bigint external name wlc.\"getmastertick\";", "wlc", "MAL",
"Scalar function", true, false, false, "result", "bigint",
64, 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", "max", "SYSTEM", "max", "aggr", "Internal C",
"Aggregate function", false, false, false, "res", "any", 0, 0,
"out", "arg", "any", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "max", "SYSTEM", "max", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "any", 0,
0, "out", "arg_1", "any", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "mbr", "SYSTEM", "create function mbr(geom geometry)
returns mbr external name geom.\"mbr\";", "geom", "MAL", "Scalar function",
false, false, false, "result", "mbr", 0, 0, "out",
"geom", "geometry", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -2589,8 +2589,8 @@ drop function pcre_replace(string, strin
[ "sys", "octet_length", "SYSTEM", "nbytes", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"int", 32, 0, "out", "arg_1", "char", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys", "octet_length", "SYSTEM", "nbytes", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"int", 32, 0, "out", "arg_1", "clob", 0, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys", "octet_length", "SYSTEM", "nbytes", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"int", 32, 0, "out", "arg_1", "varchar", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys", "optimizer_stats", "SYSTEM", "create function
sys.optimizer_stats() returns table (optname string, count int, timing bigint)
external name inspect.optimizer_stats;", "inspect", "MAL",
"Function returning a table", false, false, false, "optname", "clob",
0, 0, "out", "count", "int", 32, 0, "out",
"timing", "bigint", 64, 0, "out", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
-[ "sys", "optimizers", "SYSTEM", "create function sys.optimizers
() returns table (name string, def string, status string) external name
sql.optimizers;", "sql", "MAL", "Function returning a table", false,
false, false, "name", "clob", 0, 0, "out", "def", "clob", 0,
0, "out", "status", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys", "optimizer_stats", "SYSTEM", "create function
sys.optimizer_stats() returns table (optname string, count int, timing bigint)
external name inspect.optimizer_stats;", "inspect", "MAL",
"Function returning a table", true, false, false, "optname", "clob",
0, 0, "out", "count", "int", 32, 0, "out",
"timing", "bigint", 64, 0, "out", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys", "optimizers", "SYSTEM", "create function sys.optimizers
() returns table (name string, def string, status string) external name
sql.optimizers;", "sql", "MAL", "Function returning a table", true,
false, false, "name", "clob", 0, 0, "out", "def", "clob", 0,
0, "out", "status", "clob", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "or", "SYSTEM", "or", "calc", "Internal C", "Scalar
function", false, false, false, "res_0", "boolean", 1,
0, "out", "arg_1", "boolean", 1, 0, "in",
"arg_2", "boolean", 1, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "password_hash", "SYSTEM", "create function
sys.password_hash (username string) returns string external name
sql.password;", "sql", "MAL", "Scalar function", false, false,
false, "result", "clob", 0, 0, "out", "username", "clob",
0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "patindex", "SYSTEM", "patindex", "pcre",
"Internal C", "Scalar function", false, false, false, "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 ]
@@ -2639,20 +2639,20 @@ drop function pcre_replace(string, strin
[ "sys", "quarter", "SYSTEM", "quarter", "mtime",
"Internal C", "Scalar function", false, false, false, "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", "quarter", "SYSTEM", "quarter", "mtime",
"Internal C", "Scalar function", false, false, false, "res_0",
"int", 32, 0, "out", "arg_1", "timestamp", 7, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "quarter", "SYSTEM", "quarter", "mtime",
"Internal C", "Scalar function", false, false, false, "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", "querycache", "SYSTEM", "create function
sys.querycache() returns table (query string, count int) external name
sql.dump_cache;", "sql", "MAL", "Function returning a table", false,
false, false, "query", "clob", 0, 0, "out", "count",
"int", 32, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
+[ "sys", "querycache", "SYSTEM", "create function
sys.querycache() returns table (query string, count int) external name
sql.dump_cache;", "sql", "MAL", "Function returning a table", true,
false, false, "query", "clob", 0, 0, "out", "count",
"int", 32, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys", "querylog", "SYSTEM", "create procedure
sys.querylog(filename string) external name sql.logfile;", "sql", "MAL",
"Procedure", true, false, false, "filename", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "querylog_calls", "SYSTEM", "create function
sys.querylog_calls() returns table(id oid, \"start\" timestamp, \"stop\"
timestamp, arguments string, tuples bigint, run bigint, ship bigint, cpu int,
io int) external name sql.querylog_calls;", "sql", "MAL", "Function
returning a table", false, false, false, "id", "oid", 63, 0,
"out", "start", "timestamp", 7, 0, "out", "stop",
"timestamp", 7, 0, "out", "arguments", "clob", 0, 0,
"out", "tuples", "bigint", 64, 0, "out", "run",
"bigint", 64, 0, "out", "ship", "bigint", 64, 0,
"out", "cpu", "int", 32, 0, "out", "io", "int", 32, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "querylog_catalog", "SYSTEM", "create function
sys.querylog_catalog() returns table(id oid, owner string, defined timestamp,
query string, pipe string, \"plan\" string, mal int, optimize bigint) external
name sql.querylog_catalog;", "sql", "MAL", "Function returning a table",
false, false, false, "id", "oid", 63, 0, "out", "owner",
"clob", 0, 0, "out", "defined", "timestamp", 7, 0,
"out", "query", "clob", 0, 0, "out", "pipe", "clob", 0,
0, "out", "plan", "clob", 0, 0, "out", "mal", "int", 32,
0, "out", "optimize", "bigint", 64, 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 ]
+[ "sys", "querylog_calls", "SYSTEM", "create function
sys.querylog_calls() returns table(id oid, \"start\" timestamp, \"stop\"
timestamp, arguments string, tuples bigint, run bigint, ship bigint, cpu int,
io int) external name sql.querylog_calls;", "sql", "MAL", "Function
returning a table", true, false, false, "id", "oid", 63, 0,
"out", "start", "timestamp", 7, 0, "out", "stop",
"timestamp", 7, 0, "out", "arguments", "clob", 0, 0,
"out", "tuples", "bigint", 64, 0, "out", "run",
"bigint", 64, 0, "out", "ship", "bigint", 64, 0,
"out", "cpu", "int", 32, 0, "out", "io", "int", 32, 0,
"out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys", "querylog_catalog", "SYSTEM", "create function
sys.querylog_catalog() returns table(id oid, owner string, defined timestamp,
query string, pipe string, \"plan\" string, mal int, optimize bigint) external
name sql.querylog_catalog;", "sql", "MAL", "Function returning a table",
true, false, false, "id", "oid", 63, 0, "out", "owner",
"clob", 0, 0, "out", "defined", "timestamp", 7, 0,
"out", "query", "clob", 0, 0, "out", "pipe", "clob", 0,
0, "out", "plan", "clob", 0, 0, "out", "mal", "int", 32,
0, "out", "optimize", "bigint", 64, 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 ]
[ "sys", "querylog_disable", "SYSTEM", "create procedure
sys.querylog_disable() external name sql.querylog_disable;", "sql", "MAL",
"Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys", "querylog_empty", "SYSTEM", "create procedure
sys.querylog_empty() external name sql.querylog_empty;", "sql", "MAL",
"Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys", "querylog_enable", "SYSTEM", "create procedure
sys.querylog_enable() external name sql.querylog_enable;", "sql", "MAL",
"Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys", "querylog_enable", "SYSTEM", "create procedure
sys.querylog_enable(threshold smallint) external name
sql.querylog_enable_threshold;", "sql", "MAL", "Procedure", true,
false, false, "threshold", "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, NULL,
NULL, NULL, NULL, NULL ]
-[ "sys", "queue", "SYSTEM", "create function sys.queue()
returns table(qtag bigint, \"user\" string, started timestamp, estimate
timestamp, progress int, status string, tag oid, query string) external name
sql.sysmon_queue;", "sql", "MAL", "Function returning a table", false,
false, false, "qtag", "bigint", 64, 0, "out", "user", "clob",
0, 0, "out", "started", "timestamp", 7, 0, "out",
"estimate", "timestamp", 7, 0, "out", "progress", "int",
32, 0, "out", "status", "clob", 0, 0, "out", "tag",
"oid", 63, 0, "out", "query", "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
]
+[ "sys", "queue", "SYSTEM", "create function sys.queue()
returns table(qtag bigint, \"user\" string, started timestamp, estimate
timestamp, progress int, status string, tag oid, query string) external name
sql.sysmon_queue;", "sql", "MAL", "Function returning a table", true,
false, false, "qtag", "bigint", 64, 0, "out", "user", "clob",
0, 0, "out", "started", "timestamp", 7, 0, "out",
"estimate", "timestamp", 7, 0, "out", "progress", "int",
32, 0, "out", "status", "clob", 0, 0, "out", "tag",
"oid", 63, 0, "out", "query", "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
]
[ "sys", "radians", "SYSTEM", "create function radians(d
double) returns double return d*pi()/180;", "user", "SQL", "Scalar function",
false, false, false, "result", "double", 53, 0,
"out", "d", "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", "rand", "SYSTEM", "rand", "mmath", "Internal C",
"Scalar function", true, false, false, "res_0", "int", 32,
0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "rand", "SYSTEM", "sqlrand", "mmath",
"Internal C", "Scalar function", true, false, false, "res_0",
"int", 32, 0, "out", "arg_1", "int", 32, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys", "rank", "SYSTEM", "rank", "sql", "Internal C",
"Analytic function", false, false, false, "res_0", "int", 32,
0, "out", "arg_1", "any", 0, 0, "in", "arg_2",
"boolean", 1, 0, "in", "arg_3", "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", "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, "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", "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", true, false, false, "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", "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, "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", "repeat", "SYSTEM", "repeat", "str",
"Internal C", "Scalar function", false, false, false, "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", "repeat", "SYSTEM", "repeat", "str",
"Internal C", "Scalar function", false, false, false, "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 ]
@@ -2661,7 +2661,7 @@ drop function pcre_replace(string, strin
[ "sys", "replace", "SYSTEM", "replace", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"clob", 0, 0, "out", "arg_1", "clob", 0, 0, "in",
"arg_2", "clob", 0, 0, "in", "arg_3", "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", "replace", "SYSTEM", "replace", "str",
"Internal C", "Scalar function", false, false, false, "res_0",
"varchar", 0, 0, "out", "arg_1", "varchar", 0,
0, "in", "arg_2", "varchar", 0, 0, "in",
"arg_3", "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 ]
[ "sys", "replicabeat", "SYSTEM", "create procedure
replicabeat(duration integer) external name wlr.\"setreplicabeat\";", "wlr",
"MAL", "Procedure", true, false, false, "duration", "int", 32,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "replicaclock", "SYSTEM", "create function replicaclock()
returns string external name wlr.\"getreplicaclock\";", "wlr", "MAL", "Scalar
function", false, false, false, "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", "replicaclock", "SYSTEM", "create function replicaclock()
returns string external name wlr.\"getreplicaclock\";", "wlr", "MAL", "Scalar
function", true, false, false, "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", "replicate", "SYSTEM", "create procedure replicate()
external name wlr.replicate;", "wlr", "MAL", "Procedure", true,
false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "replicate", "SYSTEM", "create procedure
replicate(dbname string) external name wlr.replicate;", "wlr", "MAL",
"Procedure", true, false, false, "dbname", "clob", 0, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "replicate", "SYSTEM", "create procedure
replicate(dbname string, id bigint) external name wlr.replicate;", "wlr",
"MAL", "Procedure", true, false, false, "dbname", "clob", 0,
0, "in", "id", "bigint", 64, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -2670,7 +2670,7 @@ drop function pcre_replace(string, strin
[ "sys", "replicate", "SYSTEM", "create procedure
replicate(dbname string, id tinyint) external name wlr.replicate;", "wlr",
"MAL", "Procedure", true, false, false, "dbname", "clob", 0,
0, "in", "id", "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 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
