Changeset: 62eb70e309c7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=62eb70e309c7
Modified Files:
sql/test/emptydb/Tests/check.stable.out.32bit
Branch: default
Log Message:
Approve 32 bit output.
diffs (198 lines):
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -226,6 +226,7 @@ stdout of test 'check` in directory 'sql
\dSf sys."querylog_disable"
\dSf sys."querylog_empty"
\dSf sys."querylog_enable"
+\dSf sys."querytimeout"
\dSf sys."queue"
\dSf sys."radians"
\dSf sys."rejects"
@@ -237,6 +238,7 @@ stdout of test 'check` in directory 'sql
\dSf sys."right_shift"
\dSf sys."right_shift_assign"
\dSf sys."sessions"
+\dSf sys."sessiontimeout"
\dSf sys."setmasklen"
\dSf sys."setprinttimeout"
\dSf sys."setsession"
@@ -341,6 +343,7 @@ stdout of test 'check` in directory 'sql
\dSf sys."stddev_pop"
\dSf sys."stddev_samp"
\dSf sys."stop"
+\dSf sys."stopsession"
\dSf sys."storage"
\dSf sys."storagemodelinit"
\dSf sys."str_to_date"
@@ -666,6 +669,7 @@ SYSTEM FUNCTION sys.querylog_cat
SYSTEM PROCEDURE sys.querylog_disable
SYSTEM PROCEDURE sys.querylog_empty
SYSTEM PROCEDURE sys.querylog_enable
+SYSTEM PROCEDURE sys.querytimeout
SYSTEM FUNCTION sys.queue
SYSTEM FUNCTION sys.radians
SYSTEM FUNCTION sys.rand
@@ -692,6 +696,7 @@ SYSTEM FUNCTION sys.scale_down
SYSTEM FUNCTION sys.scale_up
SYSTEM FUNCTION sys.second
SYSTEM FUNCTION sys.sessions
+SYSTEM PROCEDURE sys.sessiontimeout
SYSTEM FUNCTION sys.setmasklen
SYSTEM PROCEDURE sys.setprinttimeout
SYSTEM PROCEDURE sys.setsession
@@ -816,6 +821,7 @@ SYSTEM FUNCTION sys.st_z
SYSTEM AGGREGATE sys.stddev_pop
SYSTEM AGGREGATE sys.stddev_samp
SYSTEM PROCEDURE sys.stop
+SYSTEM PROCEDURE sys.stopsession
SYSTEM FUNCTION sys.storage
SYSTEM PROCEDURE sys.storagemodelinit
SYSTEM FUNCTION sys.str_to_date
@@ -1081,6 +1087,7 @@ create function sys.optimizers () return
create function sys.password_hash (username string) returns string external
name sql.password;
create procedure sys.pause(tag bigint) external name sql.sysmon_pause;
create procedure sys.pause(tag int) external name sql.sysmon_pause;
+create procedure sys.pause(tag tinyint) external name sql.sysmon_pause;
create aggregate quantile(val bigint, q double) returns bigint external name
"aggr"."quantile";
create aggregate quantile(val date, q double) returns date external name
"aggr"."quantile";
create aggregate quantile(val decimal, q double) returns decimal external name
"aggr"."quantile";
@@ -1106,23 +1113,25 @@ 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(qtag bigint, "user" string, started
timestamp, estimate timestamp, progress int, status string, tag oid, query
string) external name sql.sysmon_queue;
+create procedure sys.querytimeout("sessionid" int, "query" bigint) external
name clients.querytimeout;
+create function sys.queue() returns table(qtag bigint, sessionid int, "user"
string, started timestamp, estimate timestamp, progress int, status string, tag
oid, query string) external name sql.sysmon_queue;
create function radians(d double) returns double return d*pi()/180;
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 procedure sys.resume(tag bigint) external name sql.sysmon_resume;
create procedure sys.resume(tag int) external name sql.sysmon_resume;
+create procedure sys.resume(tag tinyint) external name sql.sysmon_resume;
create procedure resume_log_flushing() external name sql.resume_log_flushing;
create procedure reuse(sys string, tab string) external name sql.reuse;
create function reverse(src string) returns string external name udf.reverse;
create function "right_shift"(i1 inet, i2 inet) returns boolean external name
inet.">>";
create function "right_shift_assign"(i1 inet, i2 inet) returns boolean
external name inet.">>=";
-create function sys.sessions() returns table("user" string, "login" timestamp,
"sessiontimeout" bigint, "lastcommand" timestamp, "querytimeout" bigint,
"active" bool) external name sql.sessions;
+create function sys.sessions() returns table("sessionid" int, "user" string,
"login" timestamp, "sessiontimeout" bigint, "lastcommand" timestamp,
"querytimeout" bigint, "threads" int) external name sql.sessions;
+create procedure sys.sessiontimeout("sessionid" int, "query" bigint) external
name clients.sessiontimeout;
create function "setmasklen" (p inet, mask int) returns inet external name
inet."setmasklen";
create procedure sys.setprinttimeout("timeout" integer) external name
clients.setprinttimeout;
create procedure sys.setsession("timeout" bigint) external name
clients.setsession;
create procedure sys.settimeout("query" bigint) external name
clients.settimeout;
-create procedure sys.settimeout("query" bigint, "session" bigint) external
name clients.settimeout;
create procedure shpattach(fname string) external name shp.attach;
create procedure shpload(fid integer) external name shp.import;
create procedure shpload(fid integer, filter geometry) external name
shp.import;
@@ -1266,6 +1275,8 @@ create aggregate stddev_samp(val timesta
create aggregate stddev_samp(val tinyint) returns double external name
"aggr"."stdev";
create procedure sys.stop(tag bigint) external name sql.sysmon_stop;
create procedure sys.stop(tag int) external name sql.sysmon_stop;
+create procedure sys.stop(tag tinyint) external name sql.sysmon_stop;
+create procedure sys.stopsession("sessionid" int) external name
clients.stopsession;
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";
create function sys."storage"(sname varchar(1024)) 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";
create function sys."storage"(sname varchar(1024), tname varchar(1024))
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";
@@ -1900,13 +1911,14 @@ drop function pcre_replace(string, strin
[ "querylog_history", "cpu", "int", 32, 0, NULL, true, 14,
NULL ]
[ "querylog_history", "io", "int", 32, 0, NULL, true, 15,
NULL ]
[ "queue", "qtag", "bigint", 64, 0, NULL, true, 0,
NULL ]
-[ "queue", "user", "clob", 0, 0, NULL, true, 1, NULL
]
-[ "queue", "started", "timestamp", 7, 0, NULL, true,
2, NULL ]
-[ "queue", "estimate", "timestamp", 7, 0, NULL, true,
3, NULL ]
-[ "queue", "progress", "int", 32, 0, NULL, true, 4,
NULL ]
-[ "queue", "status", "clob", 0, 0, NULL, true, 5,
NULL ]
-[ "queue", "tag", "oid", 31, 0, NULL, true, 6, NULL
]
-[ "queue", "query", "clob", 0, 0, NULL, true, 7,
NULL ]
+[ "queue", "sessionid", "int", 32, 0, NULL, true, 1,
NULL ]
+[ "queue", "user", "clob", 0, 0, NULL, true, 2, NULL
]
+[ "queue", "started", "timestamp", 7, 0, NULL, true,
3, NULL ]
+[ "queue", "estimate", "timestamp", 7, 0, NULL, true,
4, NULL ]
+[ "queue", "progress", "int", 32, 0, NULL, true, 5,
NULL ]
+[ "queue", "status", "clob", 0, 0, NULL, true, 6,
NULL ]
+[ "queue", "tag", "oid", 31, 0, NULL, true, 7, NULL
]
+[ "queue", "query", "clob", 0, 0, NULL, true, 8,
NULL ]
[ "range_partitions", "table_id", "int", 32, 0, NULL, true,
0, NULL ]
[ "range_partitions", "partition_id", "int", 32, 0, NULL, true,
1, NULL ]
[ "range_partitions", "minimum", "varchar", 2048, 0, NULL,
true, 2, NULL ]
@@ -1953,12 +1965,13 @@ drop function pcre_replace(string, strin
[ "sequences", "increment", "bigint", 64, 0, NULL, true,
6, NULL ]
[ "sequences", "cacheinc", "bigint", 64, 0, NULL, true,
7, NULL ]
[ "sequences", "cycle", "boolean", 1, 0, NULL, true,
8, NULL ]
-[ "sessions", "user", "clob", 0, 0, NULL, true, 0, NULL
]
-[ "sessions", "login", "timestamp", 7, 0, NULL, true,
1, NULL ]
-[ "sessions", "sessiontimeout", "bigint", 64, 0, NULL,
true, 2, NULL ]
-[ "sessions", "lastcommand", "timestamp", 7, 0, NULL, true,
3, NULL ]
-[ "sessions", "querytimeout", "bigint", 64, 0, NULL, true,
4, NULL ]
-[ "sessions", "active", "boolean", 1, 0, NULL, true,
5, NULL ]
+[ "sessions", "sessionid", "int", 32, 0, NULL, true, 0,
NULL ]
+[ "sessions", "user", "clob", 0, 0, NULL, true, 1, NULL
]
+[ "sessions", "login", "timestamp", 7, 0, NULL, true,
2, NULL ]
+[ "sessions", "sessiontimeout", "bigint", 64, 0, NULL,
true, 3, NULL ]
+[ "sessions", "lastcommand", "timestamp", 7, 0, NULL, true,
4, NULL ]
+[ "sessions", "querytimeout", "bigint", 64, 0, NULL, true,
5, NULL ]
+[ "sessions", "threads", "int", 32, 0, NULL, true, 6,
NULL ]
[ "spatial_ref_sys", "srid", "int", 32, 0, NULL, false, 0,
NULL ]
[ "spatial_ref_sys", "auth_name", "varchar", 256, 0, NULL,
true, 1, NULL ]
[ "spatial_ref_sys", "auth_srid", "int", 32, 0, NULL, true,
2, NULL ]
@@ -2124,7 +2137,7 @@ drop function pcre_replace(string, strin
% .s, .f, .L47, .L50, .f, .fl, .ft, .f, .f, .f,
.L51, .L52, .L53, .L54, .L55, .L56, .L57, .L60, .L61, .L62,
.L63, .L64, .L65, .L66, .L67, .L70, .L71, .L72, .L73, .L74,
.L75, .L76, .L77, .L100, .L101, .L102, .L103, .L104, .L105, .L106,
.L107, .L110, .L111, .L112, .L113, .L114, .L115, .L116, .L117, .L120,
.L121, .L122, .L123, .L124, .L125, .L126, .L127, .L130, .L131, .L132,
.L133, .L134, .L135, .L136, .L137, .L140, .L141, .L142, .L143, .L144,
.L145, .L146, .L147, .L150, .L151, .L152, .L153, .L154, .L155, .L156,
.L157, .L160, .L161, .L162, .L163, .L164, .L165, .L166, .L167, .L170 #
table_name
% name, name, system, query, mod, language_name,
function_type_name, side_effect, varres, vararg, name0, type0,
type_digits0, type_scale0, inout0, name1, type1, type_digits1,
type_scale1, inout1, name2, type2, type_digits2, type_scale2, inout2,
name3, type3, type_digits3, type_scale3, inout3, name4, type4,
type_digits4, type_scale4, inout4, name5, type5, type_digits5,
type_scale5, inout5, name6, type6, type_digits6, type_scale6, inout6,
name7, type7, type_digits7, type_scale7, inout7, name8, type8,
type_digits8, type_scale8, inout8, name9, type9, type_digits9,
type_scale9, inout9, name10, type10, type_digits10, type_scale10,
inout10, name11, type11, type_digits11, type_scale11, inout11,
name12, type12, type_digits12, type_scale12, inout12, name13, type13,
type_digits13, type_scale13, inout13, name14, type14, type_digits14,
type_scale14, inout14, name15, type15, type_digits15, type_scale15,
inout15 # name
% varchar, varchar, char, varchar, varchar,
varchar, varchar, boolean, boolean, boolean,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char,
varchar, varchar, int, int, char, varchar,
varchar, int, int, char, varchar, varchar, int,
int, char, varchar, varchar, int, int, char # type
-% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
12, 7, 2, 1, 3, 10, 14, 4, 1, 3,
8, 14, 2, 1, 3, 9, 7, 2, 1, 3,
10, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 2, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
+% 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5,
11, 14, 4, 1, 3, 16, 14, 4, 1, 3,
16, 14, 4, 1, 3, 27, 12, 4, 1, 3,
11, 9, 2, 1, 3, 12, 14, 4, 1, 3,
8, 14, 2, 1, 3, 9, 7, 2, 1, 3,
10, 7, 2, 1, 3, 8, 6, 2, 1, 3,
6, 6, 2, 1, 3, 6, 7, 1, 1, 3,
8, 6, 2, 1, 3, 6, 7, 1, 1, 3,
9, 7, 1, 1, 3, 6, 7, 1, 1, 3 #
length
[ "bam", "bam_drop_file", "SYSTEM", "create procedure
bam.bam_drop_file(file_id bigint, dbschema smallint) external name
bam.bam_drop_file;", "bam", "MAL", "Procedure", true, false,
false, "file_id", "bigint", 64, 0, "in", "dbschema",
"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 ]
[ "bam", "bam_export", "SYSTEM", "create procedure
bam.bam_export(output_path string) external name bam.bam_export;", "bam",
"MAL", "Procedure", true, false, false, "output_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 ]
[ "bam", "bam_flag", "SYSTEM", "create function
bam.bam_flag(flag smallint, name string) returns boolean external name
bam.bam_flag;", "bam", "MAL", "Scalar function", false, false, false,
"result", "boolean", 1, 0, "out", "flag", "smallint",
16, 0, "in", "name", "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 ]
@@ -2641,6 +2654,7 @@ drop function pcre_replace(string, strin
[ "sys", "patindex", "SYSTEM", "patindex", "pcre",
"Internal C", "Scalar function", false, false, false, "res_0",
"int", 32, 0, "out", "arg_1", "varchar", 0, 0,
"in", "arg_2", "varchar", 0, 0, "in", NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
[ "sys", "pause", "SYSTEM", "create procedure sys.pause(tag
bigint) external name sql.sysmon_pause;", "sql", "MAL", "Procedure",
true, false, false, "tag", "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, NULL,
NULL, NULL, NULL, NULL ]
[ "sys", "pause", "SYSTEM", "create procedure sys.pause(tag
int) external name sql.sysmon_pause;", "sql", "MAL", "Procedure", true,
false, false, "tag", "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", "pause", "SYSTEM", "create procedure sys.pause(tag
tinyint) external name sql.sysmon_pause;", "sql", "MAL", "Procedure",
true, false, false, "tag", "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, NULL,
NULL, NULL, NULL, NULL ]
[ "sys", "pcre_replace", "", "create function pcre_replace(origin
string, pat string, repl string, flags string) returns string external name
pcre.replace;", "pcre", "MAL", "Scalar function", false, false,
false, "result", "clob", 0, 0, "out", "origin", "clob",
0, 0, "in", "pat", "clob", 0, 0, "in", "repl", "clob",
0, 0, "in", "flags", "clob", 0, 0, "in", NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL ]
[ "sys", "percent_rank", "SYSTEM", "percent_rank", "sql",
"Internal C", "Analytic function", false, false, false, "res_0",
"double", 53, 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", "pi", "SYSTEM", "pi", "mmath", "Internal C",
"Scalar function", false, false, false, "res_0", "double",
53, 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 ]
@@ -2689,7 +2703,8 @@ drop function pcre_replace(string, strin
[ "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 integer) external name sql.querylog_enable;",
"sql", "MAL", "Procedure", true, false, false, "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", "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", 31, 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", "querytimeout", "SYSTEM", "create procedure
sys.querytimeout(\"sessionid\" int, \"query\" bigint) external name
clients.querytimeout;", "clients", "MAL", "Procedure", true,
false, false, "sessionid", "int", 32, 0, "in", "query",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
+[ "sys", "queue", "SYSTEM", "create function sys.queue()
returns table(qtag bigint, sessionid int, \"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", "sessionid", "int", 32, 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", 31, 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 ]
[ "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
]
@@ -2705,6 +2720,7 @@ drop function pcre_replace(string, strin
[ "sys", "restart", "SYSTEM", "restart", "sql",
"Internal C", "Scalar function", false, false, false, "res_0",
"bigint", 64, 0, "out", "arg_1", "varchar", 0,
0, "in", "arg_2", "varchar", 0, 0, "in",
"arg_3", "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 ]
[ "sys", "resume", "SYSTEM", "create procedure
sys.resume(tag bigint) external name sql.sysmon_resume;", "sql", "MAL",
"Procedure", true, false, false, "tag", "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, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "resume", "SYSTEM", "create procedure
sys.resume(tag int) external name sql.sysmon_resume;", "sql", "MAL",
"Procedure", true, false, false, "tag", "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", "resume", "SYSTEM", "create procedure
sys.resume(tag tinyint) external name sql.sysmon_resume;", "sql", "MAL",
"Procedure", true, false, false, "tag", "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, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "resume_log_flushing", "SYSTEM", "create procedure
resume_log_flushing() external name sql.resume_log_flushing;", "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", "reuse", "SYSTEM", "create procedure reuse(sys
string, tab string) external name sql.reuse;", "sql", "MAL",
"Procedure", true, false, false, "sys", "clob", 0, 0, "in",
"tab", "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", "reverse", "SYSTEM", "create function reverse(src
string) returns string external name udf.reverse;", "udf", "MAL",
"Scalar function", false, false, false, "result", "clob", 0,
0, "out", "src", "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 ]
@@ -3261,12 +3277,12 @@ drop function pcre_replace(string, strin
[ "sys", "second", "SYSTEM", "sql_seconds", "mtime",
"Internal C", "Scalar function", false, false, false, "res_0",
"decimal", 9, 6, "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", "second", "SYSTEM", "sql_seconds", "mtime",
"Internal C", "Scalar function", false, false, false, "res_0",
"decimal", 9, 6, "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", "second", "SYSTEM", "sql_seconds", "mtime",
"Internal C", "Scalar function", false, false, false, "res_0",
"decimal", 9, 6, "out", "arg_1", "timetz", 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", "sessions", "SYSTEM", "create function sys.sessions()
returns table(\"user\" string, \"login\" timestamp, \"sessiontimeout\" bigint,
\"lastcommand\" timestamp, \"querytimeout\" bigint, \"active\" bool) external
name sql.sessions;", "sql", "MAL", "Function returning a table",
true, false, false, "user", "clob", 0, 0, "out", "login",
"timestamp", 7, 0, "out", "sessiontimeout", "bigint",
64, 0, "out", "lastcommand", "timestamp", 7, 0, "out",
"querytimeout", "bigint", 64, 0, "out", "active",
"boolean", 1, 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 ]
+[ "sys", "sessions", "SYSTEM", "create function sys.sessions()
returns table(\"sessionid\" int, \"user\" string, \"login\" timestamp,
\"sessiontimeout\" bigint, \"lastcommand\" timestamp, \"querytimeout\" bigint,
\"threads\" int) external name sql.sessions;", "sql", "MAL", "Function
returning a table", true, false, false, "sessionid", "int", 32,
0, "out", "user", "clob", 0, 0, "out", "login",
"timestamp", 7, 0, "out", "sessiontimeout", "bigint",
64, 0, "out", "lastcommand", "timestamp", 7, 0, "out",
"querytimeout", "bigint", 64, 0, "out", "threads", "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 ]
+[ "sys", "sessiontimeout", "SYSTEM", "create procedure
sys.sessiontimeout(\"sessionid\" int, \"query\" bigint) external name
clients.sessiontimeout;", "clients", "MAL", "Procedure", true,
false, false, "sessionid", "int", 32, 0, "in", "query",
"bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys", "setmasklen", "SYSTEM", "create function \"setmasklen\"
(p inet, mask int) returns inet external name inet.\"setmasklen\";", "inet",
"MAL", "Scalar function", false, false, false, "result", "inet",
0, 0, "out", "p", "inet", 0, 0, "in", "mask", "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", "setprinttimeout", "SYSTEM", "create procedure
sys.setprinttimeout(\"timeout\" integer) external name
clients.setprinttimeout;", "clients", "MAL", "Procedure", true,
false, false, "timeout", "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", "setsession", "SYSTEM", "create procedure
sys.setsession(\"timeout\" bigint) external name clients.setsession;",
"clients", "MAL", "Procedure", true, false, false, "timeout",
"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, NULL, NULL, NULL, NULL, NULL
]
[ "sys", "settimeout", "SYSTEM", "create procedure
sys.settimeout(\"query\" bigint) external name clients.settimeout;",
"clients", "MAL", "Procedure", true, false, false, "query",
"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, NULL, NULL, NULL, NULL, NULL
]
-[ "sys", "settimeout", "SYSTEM", "create procedure
sys.settimeout(\"query\" bigint, \"session\" bigint) external name
clients.settimeout;", "clients", "MAL", "Procedure", true,
false, false, "query", "bigint", 64, 0, "in",
"session", "bigint", 64, 0, "in", NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys", "shpattach", "SYSTEM", "create procedure
shpattach(fname string) external name shp.attach;", "shp", "MAL",
"Procedure", true, false, false, "fname", "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", "shpload", "SYSTEM", "create procedure shpload(fid
integer) external name shp.import;", "shp", "MAL", "Procedure", true,
false, false, "fid", "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", "shpload", "SYSTEM", "create procedure shpload(fid
integer, filter geometry) external name shp.import;", "shp", "MAL",
"Procedure", true, false, false, "fid", "int", 32, 0, "in",
"filter", "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 ]
@@ -3667,6 +3683,8 @@ drop function pcre_replace(string, strin
[ "sys", "stddev_samp", "SYSTEM", "create aggregate
stddev_samp(val tinyint) returns double external name \"aggr\".\"stdev\";",
"aggr", "MAL", "Aggregate function", false, false, false, "result",
"double", 53, 0, "out", "val", "tinyint", 8, 0,
"in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
[ "sys", "stop", "SYSTEM", "create procedure sys.stop(tag bigint)
external name sql.sysmon_stop;", "sql", "MAL", "Procedure", true, false,
false, "tag", "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, NULL, NULL, NULL,
NULL, NULL ]
[ "sys", "stop", "SYSTEM", "create procedure sys.stop(tag int)
external name sql.sysmon_stop;", "sql", "MAL", "Procedure", true,
false, false, "tag", "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", "stop", "SYSTEM", "create procedure sys.stop(tag tinyint)
external name sql.sysmon_stop;", "sql", "MAL", "Procedure", true,
false, false, "tag", "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, NULL, NULL,
NULL, NULL, NULL ]
+[ "sys", "stopsession", "SYSTEM", "create procedure
sys.stopsession(\"sessionid\" int) external name clients.stopsession;",
"clients", "MAL", "Procedure", true, false, false, "sessionid",
"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", "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", true, false, false, "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", 64,
0, "out", "typewidth", "int", 32, 0, "out", "columnsize",
"bigint", 64, 0, "out", "heapsize", "bigint", 64,
0, "out", "hashes", "bigint", 64, 0, "out",
"phash", "boolean", 1, 0, "out", "imprints",
"bigint", 64, 0, "out", "sorted", "boolean",
1, 0, "out", "revsorted", "boolean", 1, 0,
"out", "unique", "boolean", 1, 0, "out" ]
[ "sys", "storage", "SYSTEM", "create function
sys.\"storage\"(sname varchar(1024)) 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, "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", 64,
0, "out", "typewidth", "int", 32, 0, "out", "columnsize",
"bigint", 64, 0, "out", "heapsize", "bigint", 64,
0, "out", "hashes", "bigint", 64, 0, "out",
"phash", "boolean", 1, 0, "out", "imprints",
"bigint", 64, 0, "out",
"sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
[ "sys", "storage", "SYSTEM", "create function
sys.\"storage\"(sname varchar(1024), tname varchar(1024)) 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, "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", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bi
gint", 64, 0, "out", "sorted", "boolean", 1, 0,
"out", "revsorted", "boolean", 1, 0, "out", "unique",
"boolean", 1, 0, "out" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
