Changeset: b014a51863a0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b014a51863a0 Modified Files: clients/Tests/MAL-signatures.test sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64 sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.32bit 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/Tests/upgrade.stable.out.32bit sql/test/emptydb/Tests/check.stable.out.32bit sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit Branch: default Log Message:
Approve 32-bit and power upgrades diffs (223 lines): 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 @@ -33008,6 +33008,11 @@ similarity command battxtsim.similarity(X_0:bat[:str], X_1:bat[:str]):bat[:dbl] fstrcmp0_impl_bulk; Normalized edit distance between two strings +baturl +extractURLHost +command baturl.extractURLHost(X_0:bat[:str], X_1:bit):bat[:str] +BATextractURLHost; +Extract host from BAT of URLs batuuid isaUUID command batuuid.isaUUID(X_0:bat[:str]):bat[:bit] @@ -47999,6 +48004,11 @@ command txtsim.stringdiff(X_0:str, X_1:s stringdiff_impl; calculate the soundexed editdistance url +extractURLHost +command url.extractURLHost(X_0:str, X_1:bit):str +extractURLHost; +Extract host from a URL relaxed version +url getAnchor command url.getAnchor(X_0:url):str URLgetAnchor; @@ -48032,7 +48042,7 @@ url getHost command url.getHost(X_0:url):str URLgetHost; -Extract the server name from the URL +Extract the server name from the URL strict version url getPort command url.getPort(X_0:url):str diff --git a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.ppc64.int128 @@ -4234,4 +4234,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit --- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit +++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit @@ -3887,4 +3887,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64 b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64 --- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64 +++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64 @@ -3887,4 +3887,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 --- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 +++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128 @@ -4303,4 +4303,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit --- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit +++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.32bit @@ -3881,4 +3881,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; 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 @@ -3102,4 +3102,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; 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 @@ -2755,4 +2755,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; 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 @@ -2755,4 +2755,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; 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 @@ -3171,4 +3171,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; 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 @@ -2749,4 +2749,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; 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 @@ -2451,6 +2451,7 @@ select 'null in value_partitions.value', [ "sys.functions", "sys", "upper", "SYSTEM", "toUpper", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "char", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] [ "sys.functions", "sys", "upper", "SYSTEM", "toUpper", "str", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "clob", 0, 0, "out", "arg_1", "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", "upper", "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 ] +[ "sys.functions", "sys", "url_extract_host", "SYSTEM", "create function sys.url_extract_host(url string, no_www bool) returns string external name url.\"extractURLHost\";", "url", "MAL", "Scalar function", false, false, false, true, NULL, "result", "clob", 0, 0, "out", "url", "clob", 0, 0, "in", "no_www", "boolean", 1, 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", "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", false, false, false, true, NULL, "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", "usweekofyear", "SYSTEM", "usweekofyear", "mtime", "Internal C", "Scalar function", false, false, false, false, NULL, "res_0", "int", 32, 0, "out", "arg_1", "date", 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", "uuid", "SYSTEM", "create function sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar function", true, false, false, true, NULL, "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 ] @@ -4415,6 +4416,7 @@ select 'null in value_partitions.value', [ "grant on function", "sys", "text", "public", "EXECUTE", "monetdb", 0 ] [ "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", "url_extract_host", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "uuid", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "uuid", "public", "EXECUTE", "monetdb", 0 ] [ "grant on function", "sys", "var", "public", "EXECUTE", NULL, 0 ] diff --git a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit --- a/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit +++ b/sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.32bit @@ -3887,4 +3887,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit --- a/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit +++ b/sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.32bit @@ -3881,4 +3881,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit --- a/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit +++ b/sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.32bit @@ -2755,4 +2755,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; diff --git a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit --- a/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit +++ b/sql/test/testdb-upgrade/Tests/upgrade.stable.out.32bit @@ -2749,4 +2749,7 @@ RETURN sys.dump_statements; END; update sys._tables set system = true where name in ('describe_partition_tables', 'dump_partition_tables', 'dump_sequences', 'dump_start_sequences') AND schema_id = 2000; update sys.functions set system = true where system <> true and name in ('dump_database') and schema_id = 2000 and type = 5; - +CREATE function sys.url_extract_host(url string, no_www bool) RETURNS STRING +EXTERNAL NAME url."extractURLHost"; +GRANT EXECUTE ON FUNCTION url_extract_host(string, bool) TO PUBLIC; +update sys.functions set system = true where system <> true and name = 'url_extract_host' and schema_id = 2000 and type = 1; _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org