Changeset: f1cc14193489 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/f1cc14193489
Modified Files:
sql/scripts/10_sys_schema_extension.sql
sql/scripts/39_analytics.sql
sql/scripts/49_strings.sql
Branch: ordered-set-aggregates
Log Message:
Place group_concat functions in proper SQL script files
diffs (45 lines):
diff --git a/sql/scripts/10_sys_schema_extension.sql
b/sql/scripts/10_sys_schema_extension.sql
--- a/sql/scripts/10_sys_schema_extension.sql
+++ b/sql/scripts/10_sys_schema_extension.sql
@@ -526,13 +526,3 @@ SELECT 'optimizer', optimizer UNION ALL
SELECT 'pi', pi() UNION ALL
SELECT 'rowcnt', rowcnt;
GRANT SELECT ON sys.var_values TO PUBLIC;
-
-CREATE AGGREGATE sys.group_concat(str string) RETURNS string WITH ORDER
EXTERNAL NAME "aggr"."str_group_concat";
-GRANT EXECUTE ON AGGREGATE sys.group_concat(string) TO PUBLIC;
-CREATE AGGREGATE sys.group_concat(str string, sep string) RETURNS string WITH
ORDER EXTERNAL NAME "aggr"."str_group_concat";
-GRANT EXECUTE ON AGGREGATE sys.group_concat(string, string) TO PUBLIC;
-
-CREATE WINDOW sys.group_concat(str string) RETURNS string EXTERNAL NAME
"sql"."str_group_concat";
-GRANT EXECUTE ON WINDOW sys.group_concat(string) TO PUBLIC;
-CREATE WINDOW sys.group_concat(str string, sep string) RETURNS string EXTERNAL
NAME "sql"."str_group_concat";
-GRANT EXECUTE ON WINDOW sys.group_concat(string, string) TO PUBLIC;
diff --git a/sql/scripts/39_analytics.sql b/sql/scripts/39_analytics.sql
--- a/sql/scripts/39_analytics.sql
+++ b/sql/scripts/39_analytics.sql
@@ -445,3 +445,10 @@ GRANT EXECUTE ON WINDOW corr(REAL, REAL)
create window corr(e1 DOUBLE, e2 DOUBLE) returns DOUBLE
external name "sql"."corr";
GRANT EXECUTE ON WINDOW corr(DOUBLE, DOUBLE) TO PUBLIC;
+
+create window sys.group_concat(str string) returns string
+ external name "sql"."str_group_concat";
+GRANT EXECUTE ON WINDOW sys.group_concat(string) TO PUBLIC;
+create window sys.group_concat(str string, sep string) returns string
+ external name "sql"."str_group_concat";
+GRANT EXECUTE ON WINDOW sys.group_concat(string, string) TO PUBLIC;
diff --git a/sql/scripts/49_strings.sql b/sql/scripts/49_strings.sql
--- a/sql/scripts/49_strings.sql
+++ b/sql/scripts/49_strings.sql
@@ -59,3 +59,10 @@ grant execute on filter function contain
create filter function sys.contains(x string, y string, icase boolean)
external name str.contains;
grant execute on filter function contains(string, string, boolean) to public;
+
+create aggregate sys.group_concat(str string) returns string with order
+ with order external name "aggr"."str_group_concat";
+GRANT EXECUTE ON AGGREGATE sys.group_concat(string) TO PUBLIC;
+create aggregate sys.group_concat(str string, sep string) returns string with
order
+ with order external name "aggr"."str_group_concat";
+GRANT EXECUTE ON AGGREGATE sys.group_concat(string, string) TO PUBLIC;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
