Changeset: 0b8847b09df7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/0b8847b09df7 Modified Files: sql/test/emptydb/Tests/check.stable.out sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test Branch: clientinfo Log Message:
Approve more tests diffs (47 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 @@ -1502,6 +1502,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 ] @@ -2276,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 ] @@ -4838,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/sys-schema/Tests/check_ForeignKey_referential_integrity.test b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test --- a/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test +++ b/sql/test/sys-schema/Tests/check_ForeignKey_referential_integrity.test @@ -282,7 +282,7 @@ query IITTTTTII rowsort SELECT * FROM sys.queue WHERE "username" NOT IN (SELECT name FROM sys.users) ---- -query ITTTTIIII rowsort +query ITTTTIIIITTTTTIT rowsort SELECT * FROM sys.sessions WHERE "username" NOT IN (SELECT name FROM sys.users) ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org