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 -- [email protected]
To unsubscribe send an email to [email protected]
