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 -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org