Changeset: 83d5ece05a73 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/83d5ece05a73
Modified Files:
clients/Tests/MAL-signatures.test
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: default
Log Message:
Some approvals.
We still need upgrade code...
diffs (84 lines):
diff --git a/clients/Tests/MAL-signatures.test
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -38365,8 +38365,13 @@ SQLstr_auto_vacuum;
auto vacuum string column with interval(sec)
sql
vacuum
+unsafe pattern sql.vacuum(X_0:str, X_1:str):void
+SQLstr_vacuum;
+vacuum a string column
+sql
+vacuum
unsafe pattern sql.vacuum(X_0:str, X_1:str, X_2:str):void
-SQLstr_column_vacuum;
+SQLstr_vacuum;
vacuum a string column
sql
variance
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
@@ -2704,6 +2704,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "val", "tinyint",
7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, NULL, "tag", "bigint",
63, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint, username string) external name sysmon.stop;", "sysmon",
"MAL", "Procedure", true, false, false, true, NULL, "tag",
"bigint", 63, 0, "in", "username", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string) external name
sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "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", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "sessionid", "int", 31, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\"
varchar(15), location varchar(1024), \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\"
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint)
external name sql.\"storage\";", "sql", "MAL", "Function returning a
table", false, false, false, true, NULL, "schema", "varchar",
1024, 0, "out", "table", "varchar", 1024, 0,
"out", "column", "varchar", 1024, 0, "out", "type",
"varchar", 1024, 0, "out", "mode", "varchar", 15, 0,
"out", "location", "varchar", 1024, 0, "out", "count",
"bigint", 63, 0, "out", "typewidth", "int", 31, 0,
"out", "columnsize", "bigint", 63, 0, "out", "heapsize",
"bigint", 63, 0, "out", "hashes", "bigint", 63,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 63,
0, "out", "sorted", "boolean", 1, 0, "out",
"revsorted", "boolean", 1, 0, "out", "unique",
"boolean", 1, 0, "out" ]
@@ -2808,8 +2809,10 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "tinyint", 7, 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", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, NULL, "result", "uuid",
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", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"uuid", 0, 0, "out", "d", "int", 31, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string) external name sql.vacuum;",
"sql", "MAL", "Procedure", true, false, false, true, NULL,
"sname", "varchar", 0, 0, "in", "tname",
"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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string, interval int)
external name sql.vacuum;", "sql", "MAL", "Procedure", true,
false, false, true, NULL, "sname", "varchar", 0, 0,
"in", "tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", "interval", "int", 31, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, interval int) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "interval", "int",
31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "MAL", "Function returning a table", false, false, false, true,
NULL, "schema", "varchar", 0, 0, "out", "name",
"varchar", 0, 0, "out", "type", "varchar", 0, 0,
"out", "value", "varchar", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "bigint", 63, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "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 ]
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
@@ -2704,6 +2704,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "val", "tinyint",
7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, NULL, "tag", "bigint",
63, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint, username string) external name sysmon.stop;", "sysmon",
"MAL", "Procedure", true, false, false, true, NULL, "tag",
"bigint", 63, 0, "in", "username", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string) external name
sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "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", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "sessionid", "int", 31, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\"
varchar(15), location varchar(1024), \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\"
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint)
external name sql.\"storage\";", "sql", "MAL", "Function returning a
table", false, false, false, true, NULL, "schema", "varchar",
1024, 0, "out", "table", "varchar", 1024, 0,
"out", "column", "varchar", 1024, 0, "out", "type",
"varchar", 1024, 0, "out", "mode", "varchar", 15, 0,
"out", "location", "varchar", 1024, 0, "out", "count",
"bigint", 63, 0, "out", "typewidth", "int", 31, 0,
"out", "columnsize", "bigint", 63, 0, "out", "heapsize",
"bigint", 63, 0, "out", "hashes", "bigint", 63,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 63,
0, "out", "sorted", "boolean", 1, 0, "out",
"revsorted", "boolean", 1, 0, "out", "unique",
"boolean", 1, 0, "out" ]
@@ -2808,8 +2809,10 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "tinyint", 7, 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", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, NULL, "result", "uuid",
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", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"uuid", 0, 0, "out", "d", "int", 31, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string) external name sql.vacuum;",
"sql", "MAL", "Procedure", true, false, false, true, NULL,
"sname", "varchar", 0, 0, "in", "tname",
"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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string, interval int)
external name sql.vacuum;", "sql", "MAL", "Procedure", true,
false, false, true, NULL, "sname", "varchar", 0, 0,
"in", "tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", "interval", "int", 31, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, interval int) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "interval", "int",
31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "MAL", "Function returning a table", false, false, false, true,
NULL, "schema", "varchar", 0, 0, "out", "name",
"varchar", 0, 0, "out", "type", "varchar", 0, 0,
"out", "value", "varchar", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "bigint", 63, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "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 ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -2811,6 +2811,7 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true, NULL,
"result", "double", 53, 0, "out", "val", "tinyint",
7, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, NULL, "tag", "bigint",
63, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint, username string) external name sysmon.stop;", "sysmon",
"MAL", "Procedure", true, false, false, true, NULL, "tag",
"bigint", 63, 0, "in", "username", "varchar", 0,
0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string) external name
sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "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", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "sessionid", "int", 31, 0, "in",
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\"
varchar(15), location varchar(1024), \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\"
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint)
external name sql.\"storage\";", "sql", "MAL", "Function returning a
table", false, false, false, true, NULL, "schema", "varchar",
1024, 0, "out", "table", "varchar", 1024, 0,
"out", "column", "varchar", 1024, 0, "out", "type",
"varchar", 1024, 0, "out", "mode", "varchar", 15, 0,
"out", "location", "varchar", 1024, 0, "out", "count",
"bigint", 63, 0, "out", "typewidth", "int", 31, 0,
"out", "columnsize", "bigint", 63, 0, "out", "heapsize",
"bigint", 63, 0, "out", "hashes", "bigint", 63,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 63,
0, "out", "sorted", "boolean", 1, 0, "out",
"revsorted", "boolean", 1, 0, "out", "unique",
"boolean", 1, 0, "out" ]
@@ -2919,8 +2920,10 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "tinyint", 7, 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", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, NULL, "result", "uuid",
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", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, NULL, "result",
"uuid", 0, 0, "out", "d", "int", 31, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string) external name sql.vacuum;",
"sql", "MAL", "Procedure", true, false, false, true, NULL,
"sname", "varchar", 0, 0, "in", "tname",
"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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL
]
[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string, interval int)
external name sql.vacuum;", "sql", "MAL", "Procedure", true,
false, false, true, NULL, "sname", "varchar", 0, 0,
"in", "tname", "varchar", 0, 0, "in", "cname",
"varchar", 0, 0, "in", "interval", "int", 31, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
+[ "sys.functions", "sys", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, interval int) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, NULL, "sname", "varchar", 0, 0, "in",
"tname", "varchar", 0, 0, "in", "interval", "int",
31, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "MAL", "Function returning a table", false, false, false, true,
NULL, "schema", "varchar", 0, 0, "out", "name",
"varchar", 0, 0, "out", "type", "varchar", 0, 0,
"out", "value", "varchar", 0, 0, "out", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "bigint", 63, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, NULL, "result", "double", 53, 0,
"out", "val", "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 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
