Changeset: 05049019a1a8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/05049019a1a8
Modified Files:
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: scatter
Log Message:
approved output after sys.queue changes
diffs (96 lines):
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
@@ -1282,7 +1282,7 @@ create procedure sys.querylog_disable()
create procedure sys.querylog_empty() external name sql.querylog_empty;
create procedure sys.querylog_enable() external name sql.querylog_enable;
create procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;
-create function sys.queue() returns table("tag" bigint, "sessionid" int,
"username" string, "started" timestamp, "status" string, "query" string,
"finished" timestamp, "workers" int, "memory" int) external name sysmon.queue;
+create function sys.queue() returns table("tag" bigint, "sessionid" int,
"username" string, "started" timestamp, "status" string, "query" string,
"finished" timestamp, "maxworkers" int, "footprint" int) external name
sysmon.queue;
create function sys.rejects() returns table(rowid bigint, fldid int, "message"
string, "input" string) external name sql.copy_rejects;
create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
create function sys.replace_first(ori string, pat string, rep string, flg
string) returns string external name "pcre"."replace_first";
@@ -2232,8 +2232,8 @@ drop function pcre_replace(string, strin
[ "sys._columns", "queue", "status", "clob", 0, 0,
NULL, true, 4, NULL ]
[ "sys._columns", "queue", "query", "clob", 0, 0,
NULL, true, 5, NULL ]
[ "sys._columns", "queue", "finished", "timestamp", 7,
0, NULL, true, 6, NULL ]
-[ "sys._columns", "queue", "workers", "int", 32, 0,
NULL, true, 7, NULL ]
-[ "sys._columns", "queue", "memory", "int", 32, 0,
NULL, true, 8, NULL ]
+[ "sys._columns", "queue", "maxworkers", "int", 32, 0,
NULL, true, 7, NULL ]
+[ "sys._columns", "queue", "footprint", "int", 32, 0,
NULL, true, 8, NULL ]
[ "sys._columns", "range_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL ]
[ "sys._columns", "range_partitions", "partition_id", "int", 32,
0, NULL, true, 1, NULL ]
[ "sys._columns", "range_partitions", "minimum", "varchar",
2048, 0, NULL, true, 2, NULL ]
@@ -3067,7 +3067,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "querylog_empty", "SYSTEM", "create
procedure sys.querylog_empty() external name sql.querylog_empty;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable() external name sql.querylog_enable;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;", "sql", "MAL", "Procedure", true, false, false,
true, "threshold", "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.functions", "sys", "queue", "SYSTEM", "create
function sys.queue() returns table(\"tag\" bigint, \"sessionid\" int,
\"username\" string, \"started\" timestamp, \"status\" string, \"query\"
string, \"finished\" timestamp, \"workers\" int, \"memory\" int) external name
sysmon.queue;", "sysmon", "MAL", "Function returning a table", true,
false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"workers", "int", 32, 0, "out", "memory", "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.functions", "sys", "queue", "SYSTEM", "create
function sys.queue() returns table(\"tag\" bigint, \"sessionid\" int,
\"username\" string, \"started\" timestamp, \"status\" string, \"query\"
string, \"finished\" timestamp, \"maxworkers\" int, \"footprint\" int) external
name sysmon.queue;", "sysmon", "MAL", "Function returning a table",
true, false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"maxworkers", "int", 32, 0, "out", "footprint", "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.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "real", 24, 0, "out", "arg_1", "real",
24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "rand", "SYSTEM", "rand", "mmath",
"Internal C", "Scalar function", true, false, false, true,
"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 ]
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
@@ -1281,7 +1281,7 @@ create procedure sys.querylog_disable()
create procedure sys.querylog_empty() external name sql.querylog_empty;
create procedure sys.querylog_enable() external name sql.querylog_enable;
create procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;
-create function sys.queue() returns table("tag" bigint, "sessionid" int,
"username" string, "started" timestamp, "status" string, "query" string,
"finished" timestamp, "workers" int, "memory" int) external name sysmon.queue;
+create function sys.queue() returns table("tag" bigint, "sessionid" int,
"username" string, "started" timestamp, "status" string, "query" string,
"finished" timestamp, "maxworkers" int, "footprint" int) external name
sysmon.queue;
create function sys.rejects() returns table(rowid bigint, fldid int, "message"
string, "input" string) external name sql.copy_rejects;
create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
create function sys.replace_first(ori string, pat string, rep string, flg
string) returns string external name "pcre"."replace_first";
@@ -2231,8 +2231,8 @@ drop function pcre_replace(string, strin
[ "sys._columns", "queue", "status", "clob", 0, 0,
NULL, true, 4, NULL ]
[ "sys._columns", "queue", "query", "clob", 0, 0,
NULL, true, 5, NULL ]
[ "sys._columns", "queue", "finished", "timestamp", 7,
0, NULL, true, 6, NULL ]
-[ "sys._columns", "queue", "workers", "int", 32, 0,
NULL, true, 7, NULL ]
-[ "sys._columns", "queue", "memory", "int", 32, 0,
NULL, true, 8, NULL ]
+[ "sys._columns", "queue", "maxworkers", "int", 32, 0,
NULL, true, 7, NULL ]
+[ "sys._columns", "queue", "footprint", "int", 32, 0,
NULL, true, 8, NULL ]
[ "sys._columns", "range_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL ]
[ "sys._columns", "range_partitions", "partition_id", "int", 32,
0, NULL, true, 1, NULL ]
[ "sys._columns", "range_partitions", "minimum", "varchar",
2048, 0, NULL, true, 2, NULL ]
@@ -3083,7 +3083,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "querylog_empty", "SYSTEM", "create
procedure sys.querylog_empty() external name sql.querylog_empty;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable() external name sql.querylog_enable;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;", "sql", "MAL", "Procedure", true, false, false,
true, "threshold", "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.functions", "sys", "queue", "SYSTEM", "create
function sys.queue() returns table(\"tag\" bigint, \"sessionid\" int,
\"username\" string, \"started\" timestamp, \"status\" string, \"query\"
string, \"finished\" timestamp, \"workers\" int, \"memory\" int) external name
sysmon.queue;", "sysmon", "MAL", "Function returning a table", true,
false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"workers", "int", 32, 0, "out", "memory", "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.functions", "sys", "queue", "SYSTEM", "create
function sys.queue() returns table(\"tag\" bigint, \"sessionid\" int,
\"username\" string, \"started\" timestamp, \"status\" string, \"query\"
string, \"finished\" timestamp, \"maxworkers\" int, \"footprint\" int) external
name sysmon.queue;", "sysmon", "MAL", "Function returning a table",
true, false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"maxworkers", "int", 32, 0, "out", "footprint", "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.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "real", 24, 0, "out", "arg_1", "real",
24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "rand", "SYSTEM", "rand", "mmath",
"Internal C", "Scalar function", true, false, false, true,
"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 ]
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
@@ -1295,7 +1295,7 @@ create procedure sys.querylog_disable()
create procedure sys.querylog_empty() external name sql.querylog_empty;
create procedure sys.querylog_enable() external name sql.querylog_enable;
create procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;
-create function sys.queue() returns table("tag" bigint, "sessionid" int,
"username" string, "started" timestamp, "status" string, "query" string,
"finished" timestamp, "workers" int, "memory" int) external name sysmon.queue;
+create function sys.queue() returns table("tag" bigint, "sessionid" int,
"username" string, "started" timestamp, "status" string, "query" string,
"finished" timestamp, "maxworkers" int, "footprint" int) external name
sysmon.queue;
create function sys.rejects() returns table(rowid bigint, fldid int, "message"
string, "input" string) external name sql.copy_rejects;
create function sys.remote_table_credentials (tablename string) returns table
("uri" string, "username" string, "hash" string) external name
sql.rt_credentials;
create function sys.replace_first(ori string, pat string, rep string, flg
string) returns string external name "pcre"."replace_first";
@@ -2253,8 +2253,8 @@ drop function pcre_replace(string, strin
[ "sys._columns", "queue", "status", "clob", 0, 0,
NULL, true, 4, NULL ]
[ "sys._columns", "queue", "query", "clob", 0, 0,
NULL, true, 5, NULL ]
[ "sys._columns", "queue", "finished", "timestamp", 7,
0, NULL, true, 6, NULL ]
-[ "sys._columns", "queue", "workers", "int", 32, 0,
NULL, true, 7, NULL ]
-[ "sys._columns", "queue", "memory", "int", 32, 0,
NULL, true, 8, NULL ]
+[ "sys._columns", "queue", "maxworkers", "int", 32, 0,
NULL, true, 7, NULL ]
+[ "sys._columns", "queue", "footprint", "int", 32, 0,
NULL, true, 8, NULL ]
[ "sys._columns", "range_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL ]
[ "sys._columns", "range_partitions", "partition_id", "int", 32,
0, NULL, true, 1, NULL ]
[ "sys._columns", "range_partitions", "minimum", "varchar",
2048, 0, NULL, true, 2, NULL ]
@@ -3128,7 +3128,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "querylog_empty", "SYSTEM", "create
procedure sys.querylog_empty() external name sql.querylog_empty;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable() external name sql.querylog_enable;", "sql",
"MAL", "Procedure", true, false, false, true, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "querylog_enable", "SYSTEM", "create
procedure sys.querylog_enable(threshold integer) external name
sql.querylog_enable;", "sql", "MAL", "Procedure", true, false, false,
true, "threshold", "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.functions", "sys", "queue", "SYSTEM", "create
function sys.queue() returns table(\"tag\" bigint, \"sessionid\" int,
\"username\" string, \"started\" timestamp, \"status\" string, \"query\"
string, \"finished\" timestamp, \"workers\" int, \"memory\" int) external name
sysmon.queue;", "sysmon", "MAL", "Function returning a table", true,
false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"workers", "int", 32, 0, "out", "memory", "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.functions", "sys", "queue", "SYSTEM", "create
function sys.queue() returns table(\"tag\" bigint, \"sessionid\" int,
\"username\" string, \"started\" timestamp, \"status\" string, \"query\"
string, \"finished\" timestamp, \"maxworkers\" int, \"footprint\" int) external
name sysmon.queue;", "sysmon", "MAL", "Function returning a table",
true, false, false, true, "tag", "bigint", 64, 0, "out",
"sessionid", "int", 32, 0, "out", "username", "clob", 0,
0, "out", "started", "timestamp", 7, 0, "out",
"status", "clob", 0, 0, "out", "query", "clob", 0,
0, "out", "finished", "timestamp", 7, 0, "out",
"maxworkers", "int", 32, 0, "out", "footprint", "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.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "double", 53, 0, "out", "arg_1",
"double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "radians", "SYSTEM", "radians",
"mmath", "Internal C", "Scalar function", false, false, false,
false, "res_0", "real", 24, 0, "out", "arg_1", "real",
24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys.functions", "sys", "rand", "SYSTEM", "rand", "mmath",
"Internal C", "Scalar function", true, false, false, true,
"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 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list