Changeset: e7d4c6fc259f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/e7d4c6fc259f
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: clientinfo
Log Message:
More approves
diffs (121 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
@@ -461,6 +461,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "_tables", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "args", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "auths", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "clientinfo_properties", NULL,
"TABLE", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "columns", "SELECT * FROM (SELECT p.* FROM
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t)
AS columns;", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "comments", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "db_user_info", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
@@ -929,6 +930,7 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "sys", "auths", "id", "int", 31, 0,
NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "auths", "name", "varchar", 1024,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "auths", "grantor", "int", 31,
0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "sys", "clientinfo_properties", "prop",
"varchar", 0, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "columns", "id", "int", 31, 0,
NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "columns", "name", "varchar", 1024,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "columns", "type", "varchar", 1024,
0, NULL, true, 2, 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
@@ -461,6 +461,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "_tables", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "args", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "auths", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "clientinfo_properties", NULL,
"TABLE", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "columns", "SELECT * FROM (SELECT p.* FROM
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t)
AS columns;", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "comments", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "db_user_info", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
@@ -929,6 +930,7 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "sys", "auths", "id", "int", 31, 0,
NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "auths", "name", "varchar", 1024,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "auths", "grantor", "int", 31,
0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "sys", "clientinfo_properties", "prop",
"varchar", 0, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "columns", "id", "int", 31, 0,
NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "columns", "name", "varchar", 1024,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "columns", "type", "varchar", 1024,
0, NULL, true, 2, NULL, NULL ]
@@ -1502,6 +1504,13 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "sys", "sessions", "querytimeout", "int", 31,
0, NULL, true, 6, NULL, NULL ]
[ "sys._columns", "sys", "sessions", "workerlimit", "int", 31,
0, NULL, true, 7, NULL, NULL ]
[ "sys._columns", "sys", "sessions", "memorylimit", "int", 31,
0, NULL, true, 8, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "language", "varchar",
0, 0, NULL, true, 9, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "peer", "varchar", 0,
0, NULL, true, 10, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "hostname", "varchar",
0, 0, NULL, true, 11, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "application", "varchar",
0, 0, NULL, true, 12, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "client", "varchar",
0, 0, NULL, true, 13, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "clientpid", "bigint",
63, 0, NULL, true, 14, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "remark", "varchar",
0, 0, NULL, true, 15, NULL, NULL ]
[ "sys._columns", "sys", "spatial_ref_sys", "srid", "int", 31,
0, NULL, false, 0, NULL, NULL ]
[ "sys._columns", "sys", "spatial_ref_sys", "auth_name",
"varchar", 256, 0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "spatial_ref_sys", "auth_srid", "int",
31, 0, NULL, true, 2, NULL, NULL ]
@@ -2274,7 +2283,8 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "second", "SYSTEM", "seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 31, 0, "out", "arg_1",
"sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "decimal", 9, 6, "out",
"arg_1", "time", 7, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "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.functions", "sys", "sessions", "SYSTEM", "create
function sys.sessions() returns table(\"sessionid\" int, \"username\" string,
\"login\" timestamp, \"idle\" timestamp, \"optimizer\" string,
\"sessiontimeout\" int, \"querytimeout\" int, \"workerlimit\" int,
\"memorylimit\" int) external name sql.sessions;", "sql", "MAL",
"Function returning a table", false, false, false, true, NULL,
"sessionid", "int", 31, 0, "out", "username", "varchar",
0, 0, "out", "login", "timestamp", 7, 0, "out",
"idle", "timestamp", 7, 0, "out", "optimizer", "varchar",
0, 0, "out", "sessiontimeout", "int", 31, 0, "out",
"querytimeout", "int", 31, 0, "out", "workerlimit", "int", 31,
0, "out", "memorylimit", "int", 31, 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", "sessions", "SYSTEM", "create
function sys.sessions() returns table(\"sessionid\" int, \"username\" string,
\"login\" timestamp, \"idle\" timestamp, \"optimizer\" string,
\"sessiontimeout\" int, \"querytimeout\" int, \"workerlimit\" int,
\"memorylimit\" int, \"language\" string, \"peer\" string, \"hostname\" string,
\"application\" string, \"client\" string, \"clientpid\" bigint, \"remark\"
string) external name sql.sessions;", "sql", "MAL", "Function returning
a table", false, false, false, true, NULL, "sessionid", "int", 31,
0, "out", "username", "varchar", 0, 0, "out",
"login", "timestamp", 7, 0, "out", "idle", "timestamp",
7, 0, "out", "optimizer", "varchar", 0, 0, "out",
"sessiontimeout", "int", 31, 0, "out", "querytimeout", "int",
31, 0, "out", "workerlimit", "int", 31, 0, "out",
"memorylimit", "int", 31, 0, "out", "language", "varchar",
0, 0, "out", "peer", "varchar", 0, 0, "out",
"hostname", "varchar", 0, 0, "out", "application",
"varchar", 0, 0, "o
ut", "client", "varchar", 0, 0, "out", "clientpid",
"bigint", 63, 0, "out", "remark", "varchar", 0,
0, "out" ]
+[ "sys.functions", "sys", "setclientinfo", "SYSTEM", "create
procedure sys.setclientinfo(property string, value string) external name
clients.setinfo;", "clients", "MAL", "Procedure", true, false,
false, true, NULL, "property", "varchar", 0, 0, "in",
"value", "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", "setmasklen", "SYSTEM", "create
function \"setmasklen\" (p inet, mask int) returns inet external name
inet.\"setmasklen\";", "inet", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "inet", 0, 0, "out",
"p", "inet", 0, 0, "in", "mask", "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", "setmemorylimit", "SYSTEM", "create
procedure sys.setmemorylimit(\"limit\" int) external name
clients.setmemorylimit;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "limit", "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", "setmemorylimit", "SYSTEM", "create
procedure sys.setmemorylimit(\"sessionid\" int, \"limit\" int) external name
clients.setmemorylimit;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "sessionid", "int", 31, 0, "in",
"limit", "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 ]
@@ -4836,6 +4846,7 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "resume", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "right_shift", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "right_shift_assign", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "setclientinfo", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "setmasklen", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "setmemorylimit", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "setoptimizer", "public", "EXECUTE",
"monetdb", 0 ]
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
@@ -461,6 +461,7 @@ select 'null in fkeys.delete_action', de
[ "sys._tables", "sys", "_tables", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "args", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "auths", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
+[ "sys._tables", "sys", "clientinfo_properties", NULL,
"TABLE", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "columns", "SELECT * FROM (SELECT p.* FROM
\"sys\".\"_columns\" AS p UNION ALL SELECT t.* FROM \"tmp\".\"_columns\" AS t)
AS columns;", "VIEW", true, "COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "comments", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
[ "sys._tables", "sys", "db_user_info", NULL, "TABLE", true,
"COMMIT", "WRITABLE", NULL ]
@@ -929,6 +930,7 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "sys", "auths", "id", "int", 31, 0,
NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "auths", "name", "varchar", 1024,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "auths", "grantor", "int", 31,
0, NULL, true, 2, NULL, NULL ]
+[ "sys._columns", "sys", "clientinfo_properties", "prop",
"varchar", 0, 0, NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "columns", "id", "int", 31, 0,
NULL, true, 0, NULL, NULL ]
[ "sys._columns", "sys", "columns", "name", "varchar", 1024,
0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "columns", "type", "varchar", 1024,
0, NULL, true, 2, NULL, NULL ]
@@ -1502,6 +1504,13 @@ select 'null in fkeys.delete_action', de
[ "sys._columns", "sys", "sessions", "querytimeout", "int", 31,
0, NULL, true, 6, NULL, NULL ]
[ "sys._columns", "sys", "sessions", "workerlimit", "int", 31,
0, NULL, true, 7, NULL, NULL ]
[ "sys._columns", "sys", "sessions", "memorylimit", "int", 31,
0, NULL, true, 8, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "language", "varchar",
0, 0, NULL, true, 9, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "peer", "varchar", 0,
0, NULL, true, 10, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "hostname", "varchar",
0, 0, NULL, true, 11, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "application", "varchar",
0, 0, NULL, true, 12, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "client", "varchar",
0, 0, NULL, true, 13, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "clientpid", "bigint",
63, 0, NULL, true, 14, NULL, NULL ]
+[ "sys._columns", "sys", "sessions", "remark", "varchar",
0, 0, NULL, true, 15, NULL, NULL ]
[ "sys._columns", "sys", "spatial_ref_sys", "srid", "int", 31,
0, NULL, false, 0, NULL, NULL ]
[ "sys._columns", "sys", "spatial_ref_sys", "auth_name",
"varchar", 256, 0, NULL, true, 1, NULL, NULL ]
[ "sys._columns", "sys", "spatial_ref_sys", "auth_srid", "int",
31, 0, NULL, true, 2, NULL, NULL ]
@@ -2315,7 +2324,8 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "second", "SYSTEM", "seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "int", 31, 0, "out", "arg_1",
"sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "decimal", 9, 6, "out",
"arg_1", "time", 7, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "second", "SYSTEM", "sql_seconds",
"mtime", "Internal C", "Scalar function", false, false, false,
false, NULL, "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.functions", "sys", "sessions", "SYSTEM", "create
function sys.sessions() returns table(\"sessionid\" int, \"username\" string,
\"login\" timestamp, \"idle\" timestamp, \"optimizer\" string,
\"sessiontimeout\" int, \"querytimeout\" int, \"workerlimit\" int,
\"memorylimit\" int) external name sql.sessions;", "sql", "MAL",
"Function returning a table", false, false, false, true, NULL,
"sessionid", "int", 31, 0, "out", "username", "varchar",
0, 0, "out", "login", "timestamp", 7, 0, "out",
"idle", "timestamp", 7, 0, "out", "optimizer", "varchar",
0, 0, "out", "sessiontimeout", "int", 31, 0, "out",
"querytimeout", "int", 31, 0, "out", "workerlimit", "int", 31,
0, "out", "memorylimit", "int", 31, 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", "sessions", "SYSTEM", "create
function sys.sessions() returns table(\"sessionid\" int, \"username\" string,
\"login\" timestamp, \"idle\" timestamp, \"optimizer\" string,
\"sessiontimeout\" int, \"querytimeout\" int, \"workerlimit\" int,
\"memorylimit\" int, \"language\" string, \"peer\" string, \"hostname\" string,
\"application\" string, \"client\" string, \"clientpid\" bigint, \"remark\"
string) external name sql.sessions;", "sql", "MAL", "Function returning
a table", false, false, false, true, NULL, "sessionid", "int", 31,
0, "out", "username", "varchar", 0, 0, "out",
"login", "timestamp", 7, 0, "out", "idle", "timestamp",
7, 0, "out", "optimizer", "varchar", 0, 0, "out",
"sessiontimeout", "int", 31, 0, "out", "querytimeout", "int",
31, 0, "out", "workerlimit", "int", 31, 0, "out",
"memorylimit", "int", 31, 0, "out", "language", "varchar",
0, 0, "out", "peer", "varchar", 0, 0, "out",
"hostname", "varchar", 0, 0, "out", "application",
"varchar", 0, 0, "o
ut", "client", "varchar", 0, 0, "out", "clientpid",
"bigint", 63, 0, "out", "remark", "varchar", 0,
0, "out" ]
+[ "sys.functions", "sys", "setclientinfo", "SYSTEM", "create
procedure sys.setclientinfo(property string, value string) external name
clients.setinfo;", "clients", "MAL", "Procedure", true, false,
false, true, NULL, "property", "varchar", 0, 0, "in",
"value", "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", "setmasklen", "SYSTEM", "create
function \"setmasklen\" (p inet, mask int) returns inet external name
inet.\"setmasklen\";", "inet", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "inet", 0, 0, "out",
"p", "inet", 0, 0, "in", "mask", "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", "setmemorylimit", "SYSTEM", "create
procedure sys.setmemorylimit(\"limit\" int) external name
clients.setmemorylimit;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "limit", "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", "setmemorylimit", "SYSTEM", "create
procedure sys.setmemorylimit(\"sessionid\" int, \"limit\" int) external name
clients.setmemorylimit;", "clients", "MAL", "Procedure", true,
false, false, true, NULL, "sessionid", "int", 31, 0, "in",
"limit", "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 ]
@@ -4969,6 +4979,7 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "resume", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "right_shift", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "right_shift_assign", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "setclientinfo", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "setmasklen", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "setmemorylimit", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "setoptimizer", "public", "EXECUTE",
"monetdb", 0 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
