Changeset: ded6d78c0f15 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ded6d78c0f15
Modified Files:
sql/backends/monet5/sql_scenario.c
Branch: default
Log Message:
Quantiles added to DB upgrade for next release
diffs (26 lines):
diff --git a/sql/backends/monet5/sql_scenario.c
b/sql/backends/monet5/sql_scenario.c
--- a/sql/backends/monet5/sql_scenario.c
+++ b/sql/backends/monet5/sql_scenario.c
@@ -740,6 +740,22 @@ sql_update_oct2013(Client c)
pos += snprintf(buf+pos, bufsize-pos, "insert into sys.systemfunctions
(select f.id from sys.functions f, sys.schemas s where f.name in
('querylog_empty', 'querylog_enable', 'querylog_disable', 'pause', 'resume',
'sysmon_resume', 'stop') and f.type = %d and f.schema_id = s.id and s.name =
'sys');\n", F_PROC);
pos += snprintf(buf+pos, bufsize-pos, "update sys._tables set system =
true where name in ('tracelog', 'optimizers', 'environment', 'storage',
'storagemodel') and schema_id = (select id from sys.schemas where name =
'sys');\n");
+ /* new entries in 39_analytics.sql for quantiles and one previously
missing median */
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
TINYINT, q DOUBLE) returns TINYINT external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
SMALLINT, q DOUBLE) returns SMALLINT external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
INTEGER, q DOUBLE) returns INTEGER external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
WRD, q DOUBLE) returns WRD external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
BIGINT, q DOUBLE) returns BIGINT external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
DECIMAL, q DOUBLE) returns DECIMAL external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
REAL, q DOUBLE) returns REAL external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
DOUBLE, q DOUBLE) returns DOUBLE external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
DATE, q DOUBLE) returns DATE external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
TIME, q DOUBLE) returns TIME external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
TIMESTAMP, q DOUBLE) returns TIMESTAMP external name \"aggr\".\"quantile\";\n");
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate quantile(val
TIMESTAMP, q DOUBLE) returns TIMESTAMP external name \"aggr\".\"quantile\";\n");
+
+ pos += snprintf(buf+pos, bufsize-pos, "create aggregate median(val
DECIMAL) returns DECIMAL external name \"aggr\".\"median\";\n");
+
if (schema) {
pos += snprintf(buf+pos, bufsize-pos, "set schema \"%s\";\n",
schema);
free(schema);
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
