Changeset: b10f08de6bd0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b10f08de6bd0
Modified Files:
clients/Tests/MAL-signatures-hge.test
clients/Tests/MAL-signatures.test
sql/backends/monet5/sql_upgrades.c
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.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.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.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.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.int128
Branch: Dec2025
Log Message:
Implemented upgrade code and approved tests for new to_hex function.
diffs (truncated from 494 to 300 lines):
diff --git a/clients/Tests/MAL-signatures-hge.test
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -45109,6 +45109,16 @@ pattern calc.timestamptz(X_0:str, X_1:in
str_2time_timestamptz
cast to timestamp and check for overflow
calc
+to_hex
+command calc.to_hex(X_0:int):str
+CALCto_hex_int
+convert to unsigned hexadecimal number representation
+calc
+to_hex
+command calc.to_hex(X_0:lng):str
+CALCto_hex_lng
+convert to unsigned hexadecimal number representation
+calc
url
command calc.url(X_0:str):url
URLnew
diff --git a/clients/Tests/MAL-signatures.test
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -33664,6 +33664,16 @@ pattern calc.timestamptz(X_0:str, X_1:in
str_2time_timestamptz
cast to timestamp and check for overflow
calc
+to_hex
+command calc.to_hex(X_0:int):str
+CALCto_hex_int
+convert to unsigned hexadecimal number representation
+calc
+to_hex
+command calc.to_hex(X_0:lng):str
+CALCto_hex_lng
+convert to unsigned hexadecimal number representation
+calc
url
command calc.url(X_0:str):url
URLnew
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
@@ -5223,6 +5223,24 @@ sql_update_dec2025(Client c, mvc *sql, s
}
res_table_destroy(output);
output = NULL;
+ if (err)
+ return err;
+
+ sql_find_subtype(&tp, "bigint", 64, 0);
+ if (!sql_bind_func(sql, "sys", "to_hex", &tp, NULL, F_FUNC, true,
true)) {
+ sql->session->status = 0; /* if the function was not found
clean the error */
+ sql->errstr[0] = '\0';
+ const char query[] = "create function to_hex(n int)\n"
+ "returns text external name \"calc\".\"to_hex\";\n"
+ "grant execute on function to_hex(int) to public;\n"
+ "create function to_hex(n bigint)\n"
+ "returns text external name \"calc\".\"to_hex\";\n"
+ "grant execute on function to_hex(bigint) to public;\n"
+ "update sys.functions set system = true where not
system and schema_id = 2000 and name = 'to_hex' and type = 1;\n"; /* F_FUNC ==
1 */
+ printf("Running database upgrade commands:\n%s\n", query);
+ fflush(stdout);
+ err = SQLstatementIntern(c, query, "update", true, false, NULL);
+ }
return err;
}
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -619,3 +619,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -619,3 +619,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -702,3 +702,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
diff --git
a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -619,3 +619,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
@@ -619,3 +619,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
@@ -702,3 +702,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -244,3 +244,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -244,3 +244,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -329,3 +329,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -244,3 +244,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -244,3 +244,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -329,3 +329,12 @@ DELETE FROM sys.keywords WHERE keyword =
Running database upgrade commands:
ALTER TABLE sys.keywords SET READ ONLY;
+Running database upgrade commands:
+create function to_hex(n int)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(int) to public;
+create function to_hex(n bigint)
+returns text external name "calc"."to_hex";
+grant execute on function to_hex(bigint) to public;
+update sys.functions set system = true where not system and schema_id = 2000
and name = 'to_hex' and type = 1;
+
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
@@ -2825,6 +2825,8 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 31, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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 ]
[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 31, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 31, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"timestamptz", 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
]
+[ "sys.functions", "sys", "to_hex", "SYSTEM", "create
function to_hex(n bigint) returns text external name \"calc\".\"to_hex\";",
"calc", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "varchar", 0, 0, "out", "n", "bigint",
63, 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", "to_hex", "SYSTEM", "create
function to_hex(n int) returns text external name \"calc\".\"to_hex\";",
"calc", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "varchar", 0, 0, "out", "n", "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 ]
[ "sys.functions", "sys", "tracelog", "SYSTEM", "create
function sys.tracelog() returns table (ticks bigint, stmt string, event string)
external name sql.dump_trace;", "sql", "MAL", "Function returning a table",
false, false, false, true, NULL, "ticks", "bigint", 63,
0, "out", "stmt", "varchar", 0, 0, "out", "event",
"varchar", 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
]
[ "sys.functions", "sys", "truncate", "SYSTEM", "stringleft",
"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", 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", "ucase", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "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 ]
@@ -5124,6 +5126,8 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "time_to_str", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "timestamp_to_str", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "timestamp_to_str", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "to_hex", "public", "EXECUTE",
"monetdb", 0 ]
+[ "grant on function", "sys", "to_hex", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "tracelog", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "unclosed_result_sets", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "url_extract_host", "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
@@ -2936,6 +2936,8 @@ select 'null in fkeys.delete_action', de
[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 31, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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 ]
[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 31, 0,
"out", "arg_1", "timestamp", 7, 0, "in", "arg_2",
"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
]
[ "sys.functions", "sys", "timestampdiff_year", "SYSTEM",
"timestampdiff_year", "mtime", "Internal C", "Scalar function",
false, false, false, false, NULL, "res_0", "int", 31, 0,
"out", "arg_1", "timestamptz", 7, 0, "in", "arg_2",
"timestamptz", 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
]
+[ "sys.functions", "sys", "to_hex", "SYSTEM", "create
function to_hex(n bigint) returns text external name \"calc\".\"to_hex\";",
"calc", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "varchar", 0, 0, "out", "n", "bigint",
63, 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", "to_hex", "SYSTEM", "create
function to_hex(n int) returns text external name \"calc\".\"to_hex\";",
"calc", "MAL", "Scalar function", false, false, false, true, NULL,
"result", "varchar", 0, 0, "out", "n", "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 ]
[ "sys.functions", "sys", "tracelog", "SYSTEM", "create
function sys.tracelog() returns table (ticks bigint, stmt string, event string)
external name sql.dump_trace;", "sql", "MAL", "Function returning a table",
false, false, false, true, NULL, "ticks", "bigint", 63,
0, "out", "stmt", "varchar", 0, 0, "out", "event",
"varchar", 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
]
[ "sys.functions", "sys", "truncate", "SYSTEM", "stringleft",
"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", 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", "ucase", "SYSTEM", "toUpper",
"str", "Internal C", "Scalar function", false, false, false, false,
NULL, "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 ]
@@ -5261,6 +5263,8 @@ select 'null in fkeys.delete_action', de
[ "grant on function", "sys", "time_to_str", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "timestamp_to_str", "public",
"EXECUTE", "monetdb", 0 ]
[ "grant on function", "sys", "timestamp_to_str", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "to_hex", "public", "EXECUTE",
"monetdb", 0 ]
+[ "grant on function", "sys", "to_hex", "public", "EXECUTE",
"monetdb", 0 ]
[ "grant on function", "sys", "tracelog", "public", "EXECUTE",
"monetdb", 0 ]
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
