Changeset: 44dc4012b847 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=44dc4012b847
Modified Files:
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
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.powerpc64
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.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: default
Log Message:
Approvals for group_concat.
diffs (truncated from 529 to 300 lines):
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
@@ -5757,6 +5757,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 13:50:24 >
# 13:50:24 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7858" "--port=33066"
diff --git
a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.powerpc64
@@ -5752,6 +5752,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 15:46:26 >
# 15:46:26 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7779" "--port=36716"
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
@@ -5044,6 +5044,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 14:06:25 >
# 14:06:25 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-32766" "--port=33975"
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
@@ -5044,6 +5044,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 15:42:23 >
# 15:42:23 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-10708" "--port=34422"
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
@@ -5808,6 +5808,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 16:53:35 >
# 16:53:35 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-30908" "--port=39660"
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64
@@ -5044,6 +5044,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 14:06:25 >
# 14:06:25 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-32766" "--port=33975"
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.powerpc64.int128
@@ -5808,6 +5808,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 15:43:25 >
# 15:43:25 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-5725" "--port=37647"
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
@@ -5746,6 +5746,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 13:50:25 >
# 13:50:25 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-7858" "--port=33066"
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
@@ -5033,6 +5033,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 14:06:25 >
# 14:06:25 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-32766" "--port=33975"
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
@@ -5033,6 +5033,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 15:42:23 >
# 15:42:23 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-10708" "--port=34422"
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
@@ -5797,6 +5797,16 @@ GRANT EXECUTE ON PROCEDURE bam.bam_expor
set schema "sys";
commit;
+Running database upgrade commands:
+set schema sys;
+create aggregate group_concat(str string) returns string external name
"aggr"."str_group_concat";
+grant execute on aggregate group_concat(string) to public;
+create aggregate group_concat(str string, sep string) returns string external
name "aggr"."str_group_concat";
+grant execute on aggregate group_concat(string, string) to public;
+insert into sys.systemfunctions (select id from sys.functions where name in
('group_concat') and schema_id = (select id from sys.schemas where name =
'sys') and id not in (select function_id from sys.systemfunctions));
+set schema "sys";
+commit;
+
# 18:26:24 >
# 18:26:24 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-20759" "--port=37815"
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
@@ -186,6 +186,7 @@ Ready.
\dSf sys."getquery"
\dSf sys."getroboturl"
\dSf sys."getuser"
+\dSf sys."group_concat"
\dSf sys."has_m"
\dSf sys."has_z"
\dSf sys."hashsize"
@@ -1020,6 +1021,8 @@ create function getprotocol(theurl url)
create function getquery(theurl url) returns string external name
url."getQuery";
create function getroboturl(theurl url) returns string external name
url."getRobotURL";
create function getuser(theurl url) returns string external name url."getUser";
+create aggregate sys.group_concat(str string) returns string external name
"aggr"."str_group_concat";
+create aggregate sys.group_concat(str string, sep string) returns string
external name "aggr"."str_group_concat";
create function has_m(info integer) returns integer external name geom."hasM";
create function has_z(info integer) returns integer external name geom."hasZ";
create function sys.hashsize(b boolean, i bigint) returns bigint begin if b =
true then return 8 * i; end if; return 0; end;
@@ -2333,6 +2336,8 @@ drop function pcre_replace(string, strin
[ "sys", "getquery", "create function getquery(theurl url) returns
string external name url.\"getQuery\";", "url", "MAL", "Scalar function",
false, false, false, "result", "clob", 0, 0, "out",
"theurl", "url", 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", "getroboturl", "create function getroboturl(theurl url)
returns string external name url.\"getRobotURL\";", "url", "MAL", "Scalar
function", false, false, false, "result", "clob", 0, 0,
"out", "theurl", "url", 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", "getuser", "create function getuser(theurl url) returns
string external name url.\"getUser\";", "url", "MAL", "Scalar function",
false, false, false, "result", "clob", 0, 0, "out",
"theurl", "url", 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", "group_concat", "create aggregate sys.group_concat(str string)
returns string external name \"aggr\".\"str_group_concat\";", "aggr", "MAL",
"Aggregate function", false, false, false, "result", "clob", 0,
0, "out", "str", "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", "group_concat", "create aggregate sys.group_concat(str string,
sep string) returns string external name \"aggr\".\"str_group_concat\";",
"aggr", "MAL", "Aggregate function", false, false, false, "result",
"clob", 0, 0, "out", "str", "clob", 0, 0, "in", "sep",
"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 ]
[ "sys", "has_m", "create function has_m(info integer) returns
integer external name geom.\"hasM\";", "geom", "MAL", "Scalar function",
false, false, false, "result", "int", 32, 0, "out",
"info", "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", "has_z", "create function has_z(info integer) returns
integer external name geom.\"hasZ\";", "geom", "MAL", "Scalar function",
false, false, false, "result", "int", 32, 0, "out",
"info", "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", "hash", "hash", "mkey", "Internal C", "Scalar function",
false, false, false, "res_0", "bigint", 64, 0, "out",
"arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -4676,6 +4681,8 @@ drop function pcre_replace(string, strin
[ "getquery", "public", "EXECUTE", "monetdb", 0 ]
[ "getroboturl", "public", "EXECUTE", "monetdb", 0
]
[ "getuser", "public", "EXECUTE", "monetdb", 0 ]
+[ "group_concat", "public", "EXECUTE", "monetdb", 0
]
+[ "group_concat", "public", "EXECUTE", "monetdb", 0
]
[ "has_m", "public", "EXECUTE", "monetdb", 0 ]
[ "has_z", "public", "EXECUTE", "monetdb", 0 ]
[ "host", "public", "EXECUTE", "monetdb", 0 ]
@@ -5157,6 +5164,8 @@ drop function pcre_replace(string, strin
[ "getquery" ]
[ "getroboturl" ]
[ "getuser" ]
+[ "group_concat" ]
+[ "group_concat" ]
[ "has_m" ]
[ "has_z" ]
[ "hash" ]
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
@@ -190,6 +190,7 @@ Ready.
\dSf sys."getquery"
\dSf sys."getroboturl"
\dSf sys."getuser"
+\dSf sys."group_concat"
\dSf sys."has_m"
\dSf sys."has_z"
\dSf sys."hashsize"
@@ -1024,6 +1025,8 @@ create function getprotocol(theurl url)
create function getquery(theurl url) returns string external name
url."getQuery";
create function getroboturl(theurl url) returns string external name
url."getRobotURL";
create function getuser(theurl url) returns string external name url."getUser";
+create aggregate sys.group_concat(str string) returns string external name
"aggr"."str_group_concat";
+create aggregate sys.group_concat(str string, sep string) returns string
external name "aggr"."str_group_concat";
create function has_m(info integer) returns integer external name geom."hasM";
create function has_z(info integer) returns integer external name geom."hasZ";
create function sys.hashsize(b boolean, i bigint) returns bigint begin if b =
true then return 8 * i; end if; return 0; end;
@@ -2337,6 +2340,8 @@ drop function pcre_replace(string, strin
[ "sys", "getquery", "create function getquery(theurl url) returns
string external name url.\"getQuery\";", "url", "MAL", "Scalar function",
false, false, false, "result", "clob", 0, 0, "out",
"theurl", "url", 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", "getroboturl", "create function getroboturl(theurl url)
returns string external name url.\"getRobotURL\";", "url", "MAL", "Scalar
function", false, false, false, "result", "clob", 0, 0,
"out", "theurl", "url", 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", "getuser", "create function getuser(theurl url) returns
string external name url.\"getUser\";", "url", "MAL", "Scalar function",
false, false, false, "result", "clob", 0, 0, "out",
"theurl", "url", 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", "group_concat", "create aggregate sys.group_concat(str string)
returns string external name \"aggr\".\"str_group_concat\";", "aggr", "MAL",
"Aggregate function", false, false, false, "result", "clob", 0,
0, "out", "str", "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", "group_concat", "create aggregate sys.group_concat(str string,
sep string) returns string external name \"aggr\".\"str_group_concat\";",
"aggr", "MAL", "Aggregate function", false, false, false, "result",
"clob", 0, 0, "out", "str", "clob", 0, 0, "in", "sep",
"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 ]
[ "sys", "has_m", "create function has_m(info integer) returns
integer external name geom.\"hasM\";", "geom", "MAL", "Scalar function",
false, false, false, "result", "int", 32, 0, "out",
"info", "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", "has_z", "create function has_z(info integer) returns
integer external name geom.\"hasZ\";", "geom", "MAL", "Scalar function",
false, false, false, "result", "int", 32, 0, "out",
"info", "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", "hash", "hash", "mkey", "Internal C", "Scalar function",
false, false, false, "res_0", "bigint", 64, 0, "out",
"arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -4680,6 +4685,8 @@ drop function pcre_replace(string, strin
[ "getquery", "public", "EXECUTE", "monetdb", 0 ]
[ "getroboturl", "public", "EXECUTE", "monetdb", 0
]
[ "getuser", "public", "EXECUTE", "monetdb", 0 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
