Changeset: 4d04f17f2f30 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/4d04f17f2f30
Modified Files:
sql/test/emptydb/Tests/check.stable.out
Branch: default
Log Message:
Fix output order.
diffs (43 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
@@ -1885,9 +1885,6 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "insert", "SYSTEM", "insert",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "char", 0, 0, "out", "arg_1", "char",
0, 0, "in", "arg_2", "int", 32, 0, "in",
"arg_3", "int", 32, 0, "in", "arg_4", "char", 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.functions", "sys", "insert", "SYSTEM", "insert",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "clob", 0, 0, "out", "arg_1", "clob",
0, 0, "in", "arg_2", "int", 32, 0, "in",
"arg_3", "int", 32, 0, "in", "arg_4", "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.functions", "sys", "insert", "SYSTEM", "insert",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "res_0", "varchar", 0, 0, "out", "arg_1",
"varchar", 0, 0, "in", "arg_2", "int", 32, 0,
"in", "arg_3", "int", 32, 0, "in", "arg_4",
"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
]
-[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged() returns table(\"table\" string, \"table_id\"
int, \"rowcount\" bigint) external name sql.persist_unlogged;", "sql",
"MAL", "Function returning a table", true, false, false, true, NULL,
"table", "clob", 0, 0, "out", "table_id", "int", 32,
0, "out", "rowcount", "bigint", 64, 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 ]
-[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string) returns table(\"table\" string,
\"table_id\" int, \"rowcount\" bigint) external name sql.persist_unlogged;",
"sql", "MAL", "Function returning a table", true, false, false,
true, NULL, "table", "clob", 0, 0, "out", "table_id",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
-[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"rowcount\" bigint) external name
sql.persist_unlogged;", "sql", "MAL", "Function returning a table", true,
false, false, true, NULL, "table", "clob", 0, 0, "out",
"table_id", "int", 32, 0, "out", "rowcount", "bigint",
64, 0, "out", "sname", "clob", 0, 0, "in",
"tname", "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.functions", "sys", "internaltransform", "SYSTEM", "create
function internaltransform(geom geometry, srid_src integer, srid_dest integer,
proj4_src string, proj4_dest string) returns geometry external name
geom.\"Transform\";", "geom", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "geometry", 0, 0,
"out", "geom", "geometry", 0, 0, "in", "srid_src", "int",
32, 0, "in", "srid_dest", "int", 32, 0, "in",
"proj4_src", "clob", 0, 0, "in", "proj4_dest", "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 ]
[ "sys.functions", "sys", "isaurl", "SYSTEM", "create
function isaurl(theurl string) returns bool external name url.\"isaURL\";",
"url", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "boolean", 1, 0, "out", "theurl", "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.functions", "sys", "isauuid", "SYSTEM", "create
function sys.isauuid(s string) returns boolean external name
uuid.\"isaUUID\";", "uuid", "MAL", "Scalar function", false,
false, false, true, NULL, "result", "boolean", 1, 0,
"out", "s", "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 ]
@@ -2092,6 +2089,9 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "pause", "SYSTEM", "create
procedure sys.pause(tag bigint, username string) external name sysmon.pause;",
"sysmon", "MAL", "Procedure", true, false, false, true, NULL,
"tag", "bigint", 64, 0, "in", "username", "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.functions", "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, true, NULL, "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.functions", "sys", "percent_rank", "SYSTEM", "percent_rank",
"sql", "Internal C", "Analytic function", false, false, false, true,
NULL, "res_0", "double", 53, 0, "out", "arg_1",
"any", 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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged() returns table(\"table\" string, \"table_id\"
int, \"rowcount\" bigint) external name sql.persist_unlogged;", "sql",
"MAL", "Function returning a table", true, false, false, true, NULL,
"table", "clob", 0, 0, "out", "table_id", "int", 32,
0, "out", "rowcount", "bigint", 64, 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 ]
+[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string) returns table(\"table\" string,
\"table_id\" int, \"rowcount\" bigint) external name sql.persist_unlogged;",
"sql", "MAL", "Function returning a table", true, false, false,
true, NULL, "table", "clob", 0, 0, "out", "table_id",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
+[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"rowcount\" bigint) external name
sql.persist_unlogged;", "sql", "MAL", "Function returning a table", true,
false, false, true, NULL, "table", "clob", 0, 0, "out",
"table_id", "int", 32, 0, "out", "rowcount", "bigint",
64, 0, "out", "sname", "clob", 0, 0, "in",
"tname", "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.functions", "sys", "pi", "SYSTEM", "pi", "mmath",
"Internal C", "Scalar function", false, false, false, false, NULL,
"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 ]
[ "sys.functions", "sys", "power", "SYSTEM", "pow",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "double", 53, 0, "out",
"arg_1", "double", 53, 0, "in", "arg_2",
"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
]
[ "sys.functions", "sys", "power", "SYSTEM", "pow",
"mmath", "Internal C", "Scalar function", false, false, false,
false, NULL, "res_0", "real", 24, 0, "out", "arg_1",
"real", 24, 0, "in", "arg_2", "real", 24, 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 ]
@@ -4656,9 +4656,6 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "hostmask", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "hot_snapshot", ".snapshot", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "hot_snapshot", ".snapshot", "EXECUTE",
"monetdb", 0 ]
-[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
-[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
-[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "internaltransform", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "isaurl", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "isauuid", "public", "EXECUTE",
"monetdb", 0 ]
@@ -4705,6 +4702,9 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "newurl", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "newurl", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "pause", "public", "EXECUTE",
"monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "prepared_statements", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "prepared_statements_args", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "qgramnormalize", "public",
"EXECUTE", "monetdb", 0 ]
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
