Changeset: b76b596b4915 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b76b596b4915
Modified Files:
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: Oct2020
Log Message:
Fix and approve upgrade.
diffs (truncated from 460 to 300 lines):
diff --git a/sql/backends/monet5/sql_upgrades.c
b/sql/backends/monet5/sql_upgrades.c
--- a/sql/backends/monet5/sql_upgrades.c
+++ b/sql/backends/monet5/sql_upgrades.c
@@ -2531,7 +2531,8 @@ sql_update_oct2020_sp1(Client c, mvc *sq
pos += snprintf(buf + pos, bufsize - pos,
"create function sys.uuid(d int) returns uuid\n"
" external name uuid.\"new\";\n"
- "GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;\n");
+ "GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;\n"
+ "update sys.functions set system = true where system <>
true and name = 'uuid' and schema_id = (select id from sys.schemas where name =
'sys') and type = %d;\n", (int) F_FUNC);
pos += snprintf(buf + pos, bufsize - pos, "set schema
\"%s\";\n", prev_schema);
assert(pos < bufsize);
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -4297,6 +4297,14 @@ insert into sys.functions values (1114,
insert into sys.functions values (1115, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 15:17:55 >
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128
@@ -4297,6 +4297,14 @@ insert into sys.functions values (1114,
insert into sys.functions values (1115, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 15:17:55 >
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -3688,6 +3688,14 @@ insert into sys.functions values (962, '
insert into sys.functions values (963, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 15:55:37 >
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit
@@ -3688,6 +3688,14 @@ insert into sys.functions values (962, '
insert into sys.functions values (963, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 16:02:52 >
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -4371,6 +4371,14 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'filter' and schema_id = (select id from sys.schemas where name = 'json') and
type = 1;
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 16:53:35 >
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64
@@ -3688,6 +3688,14 @@ insert into sys.functions values (962, '
insert into sys.functions values (963, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 15:55:37 >
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -4371,6 +4371,14 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'filter' and schema_id = (select id from sys.schemas where name = 'json') and
type = 1;
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 15:43:25 >
diff --git a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -4297,6 +4297,14 @@ insert into sys.functions values (1114,
insert into sys.functions values (1115, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 15:17:04 >
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out
@@ -3688,6 +3688,14 @@ insert into sys.functions values (962, '
insert into sys.functions values (963, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 21:10:45 >
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.32bit
@@ -3688,6 +3688,14 @@ insert into sys.functions values (962, '
insert into sys.functions values (963, 'sys_update_tables', 'update_tables',
'sql', 0, 2, false, false, false, 2000, true, true);
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 16:02:52 >
diff --git a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
@@ -4371,6 +4371,14 @@ update sys.functions set system = true w
update sys.functions set system = true where system <> true and name =
'filter' and schema_id = (select id from sys.schemas where name = 'json') and
type = 1;
set schema "sys";
+Running database upgrade commands:
+set schema sys;
+create function sys.uuid(d int) returns uuid
+ external name uuid."new";
+GRANT EXECUTE ON FUNCTION sys.uuid(int) TO PUBLIC;
+update sys.functions set system = true where system <> true and name = 'uuid'
and schema_id = (select id from sys.schemas where name = 'sys') and type = 1;
+set schema "sys";
+
# MonetDB/SQL module loaded
# 18:26:24 >
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
@@ -1352,6 +1352,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 procedure vacuum(sys string, tab string) external name sql.vacuum;
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";
@@ -3500,6 +3501,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", "vacuum", "SYSTEM", "create
procedure vacuum(sys string, tab string) external name sql.vacuum;", "sql",
"MAL", "Procedure", true, false, false, true, "sys", "clob", 0,
0, "in", "tab", "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", "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 ]
@@ -4339,6 +4341,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
@@ -4827,6 +4830,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
@@ -1352,6 +1352,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 procedure vacuum(sys string, tab string) external name sql.vacuum;
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";
@@ -3500,6 +3501,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", "vacuum", "SYSTEM", "create
procedure vacuum(sys string, tab string) external name sql.vacuum;", "sql",
"MAL", "Procedure", true, false, false, true, "sys", "clob", 0,
0, "in", "tab", "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", "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 ]
@@ -4339,6 +4341,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
@@ -4827,6 +4830,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
@@ -1369,6 +1369,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 procedure vacuum(sys string, tab string) external name sql.vacuum;
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";
@@ -3685,6 +3686,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", "vacuum", "SYSTEM", "create
procedure vacuum(sys string, tab string) external name sql.vacuum;", "sql",
"MAL", "Procedure", true, false, false, true, "sys", "clob", 0,
0, "in", "tab", "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", "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 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
