Changeset: 360f9a6b8ede for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=360f9a6b8ede
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: unlock
Log Message:
approved output
diffs (89 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
@@ -1341,6 +1341,7 @@ create function timestamp_to_str(d times
create function sys.tracelog() returns table (ticks bigint, stmt string)
external name sql.dump_trace;
create function sys.user_statistics() returns table(username string,
querycount bigint, totalticks bigint, started timestamp, finished timestamp,
maxticks bigint, maxquery string) external name sysmon.user_statistics;
create function sys.uuid() returns uuid external name uuid."new";
+create function sys.uuid(d int) returns uuid external name uuid."new";
create function "sys"."var"() returns table("schema" string, "name" string,
"type" string, "value" string) external name "sql"."sql_variables";
create aggregate var_pop(val bigint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
@@ -3482,6 +3483,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "upper", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"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", "user_statistics", "SYSTEM", "create
function sys.user_statistics() returns table(username string, querycount
bigint, totalticks bigint, started timestamp, finished timestamp, maxticks
bigint, maxquery string) external name sysmon.user_statistics;", "sysmon",
"MAL", "Function returning a table", true, false, false, true,
"username", "clob", 0, 0, "out", "querycount", "bigint",
64, 0, "out", "totalticks", "bigint", 64, 0, "out",
"started", "timestamp", 7, 0, "out", "finished",
"timestamp", 7, 0, "out", "maxticks", "bigint", 64,
0, "out", "maxquery", "clob", 0, 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 ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
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", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d", "int", 32, 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", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "SQL", "Function returning a table", false, false, false, true,
"schema", "char", 0, 0, "out", "name", "char", 0, 0,
"out", "type", "char", 0, 0, "out", "value", "char", 0,
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 ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "bigint", 64, 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", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "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, NULL, NULL, NULL, NULL, NULL ]
@@ -4320,6 +4322,7 @@ drop function pcre_replace(string, strin
[ "type used by function", "inet", "inet", "sys", "setmasklen", "TYPE"
]
[ "type used by function", "inet", "inet", "sys", "text", "TYPE" ]
[ "type used by function", "uuid", "uuid", "sys", "uuid", "TYPE" ]
+[ "type used by function", "uuid", "uuid", "sys", "uuid", "TYPE" ]
#select 'sys.idxs', t.name, i.name, it.index_type_name from sys.idxs i left
outer join sys._tables t on t.id = i.table_id left outer join sys.index_types
as it on i.type = it.index_type_id order by t.name, i.name;
% .%1, .t, .i, .it # table_name
% %1, name, name, index_type_name # name
@@ -4808,6 +4811,7 @@ drop function pcre_replace(string, strin
[ "grant on function", "tojsonarray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "tojsonarray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "uuid", "public", "EXECUTE", "monetdb",
0 ]
+[ "grant on function", "uuid", "public", "EXECUTE", "monetdb",
0 ]
[ "grant on function", "valuearray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "var", "public", "EXECUTE", NULL, 0
]
[ "grant on function", "var_pop", "public", "EXECUTE",
"monetdb", 0 ]
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
@@ -4322,6 +4322,7 @@ drop function pcre_replace(string, strin
[ "type used by function", "inet", "inet", "sys", "setmasklen", "TYPE"
]
[ "type used by function", "inet", "inet", "sys", "text", "TYPE" ]
[ "type used by function", "uuid", "uuid", "sys", "uuid", "TYPE" ]
+[ "type used by function", "uuid", "uuid", "sys", "uuid", "TYPE" ]
#select 'sys.idxs', t.name, i.name, it.index_type_name from sys.idxs i left
outer join sys._tables t on t.id = i.table_id left outer join sys.index_types
as it on i.type = it.index_type_id order by t.name, i.name;
% .%1, .t, .i, .it # table_name
% %1, name, name, index_type_name # name
@@ -4810,6 +4811,7 @@ drop function pcre_replace(string, strin
[ "grant on function", "tojsonarray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "tojsonarray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "uuid", "public", "EXECUTE", "monetdb",
0 ]
+[ "grant on function", "uuid", "public", "EXECUTE", "monetdb",
0 ]
[ "grant on function", "valuearray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "var", "public", "EXECUTE", NULL, 0
]
[ "grant on function", "var_pop", "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
@@ -1358,6 +1358,7 @@ create function timestamp_to_str(d times
create function sys.tracelog() returns table (ticks bigint, stmt string)
external name sql.dump_trace;
create function sys.user_statistics() returns table(username string,
querycount bigint, totalticks bigint, started timestamp, finished timestamp,
maxticks bigint, maxquery string) external name sysmon.user_statistics;
create function sys.uuid() returns uuid external name uuid."new";
+create function sys.uuid(d int) returns uuid external name uuid."new";
create function "sys"."var"() returns table("schema" string, "name" string,
"type" string, "value" string) external name "sql"."sql_variables";
create aggregate var_pop(val bigint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
@@ -3666,6 +3667,7 @@ drop function pcre_replace(string, strin
[ "sys.functions", "sys", "upper", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
"res_0", "varchar", 0, 0, "out", "arg_1",
"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", "user_statistics", "SYSTEM", "create
function sys.user_statistics() returns table(username string, querycount
bigint, totalticks bigint, started timestamp, finished timestamp, maxticks
bigint, maxquery string) external name sysmon.user_statistics;", "sysmon",
"MAL", "Function returning a table", true, false, false, true,
"username", "clob", 0, 0, "out", "querycount", "bigint",
64, 0, "out", "totalticks", "bigint", 64, 0, "out",
"started", "timestamp", 7, 0, "out", "finished",
"timestamp", 7, 0, "out", "maxticks", "bigint", 64,
0, "out", "maxquery", "clob", 0, 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 ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
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", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d", "int", 32, 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", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "SQL", "Function returning a table", false, false, false, true,
"schema", "char", 0, 0, "out", "name", "char", 0, 0,
"out", "type", "char", 0, 0, "out", "value", "char", 0,
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 ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "bigint", 64, 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", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "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, NULL, NULL, NULL, NULL, NULL ]
@@ -4513,6 +4515,7 @@ drop function pcre_replace(string, strin
[ "type used by function", "inet", "inet", "sys", "setmasklen", "TYPE"
]
[ "type used by function", "inet", "inet", "sys", "text", "TYPE" ]
[ "type used by function", "uuid", "uuid", "sys", "uuid", "TYPE" ]
+[ "type used by function", "uuid", "uuid", "sys", "uuid", "TYPE" ]
#select 'sys.idxs', t.name, i.name, it.index_type_name from sys.idxs i left
outer join sys._tables t on t.id = i.table_id left outer join sys.index_types
as it on i.type = it.index_type_id order by t.name, i.name;
% .%1, .t, .i, .it # table_name
% %1, name, name, index_type_name # name
@@ -5016,6 +5019,7 @@ drop function pcre_replace(string, strin
[ "grant on function", "tojsonarray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "tojsonarray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "uuid", "public", "EXECUTE", "monetdb",
0 ]
+[ "grant on function", "uuid", "public", "EXECUTE", "monetdb",
0 ]
[ "grant on function", "valuearray", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "var", "public", "EXECUTE", NULL, 0
]
[ "grant on function", "var_pop", "public", "EXECUTE",
"monetdb", 0 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
