Changeset: a60790432ec0 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a60790432ec0
Modified Files:
        sql/server/rel_optimizer.c
Branch: DVframework
Log Message:

simple trick to make std_dev queries work.


diffs (12 lines):

diff --git a/sql/server/rel_optimizer.c b/sql/server/rel_optimizer.c
--- a/sql/server/rel_optimizer.c
+++ b/sql/server/rel_optimizer.c
@@ -1887,7 +1887,7 @@ str form_pkey_select_str(sel_predicate**
 str get_non_pkey_select_str(str schema_name, str dmdt_name)
 {
        if(strcmp(schema_name, "mseed") == 0 && strcmp(dmdt_name, 
"windowmetadata") == 0)
-               return "MIN(sample_value) AS min_val, MAX(sample_value) AS 
max_val, AVG(sample_value) AS avg_val, stddev_pop(sample_value) AS std_dev";
+               return "MIN(sample_value) AS min_val, MAX(sample_value) AS 
max_val, AVG(sample_value) AS avg_val, SUM(sample_value) AS std_dev";
        if(strcmp(schema_name, "mseed") == 0 && strcmp(dmdt_name, 
"psdmetadata") == 0)
                return "AVG(sample_value) AS psd_value";
        else
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to