MonetDB: default - Propagate min/max for average

[Pedro Ferreira]

Changeset: bd76513dd21a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/bd76513dd21a
Modified Files:
        sql/server/rel_statistics_functions.c
Branch: default
Log Message:

Propagate min/max for average


diffs (50 lines):

diff --git a/sql/server/rel_statistics_functions.c 
b/sql/server/rel_statistics_functions.c
--- a/sql/server/rel_statistics_functions.c
+++ b/sql/server/rel_statistics_functions.c
@@ -727,6 +727,29 @@ sql_min_max_propagate_statistics(mvc *sq
 }
 
 static void
+sql_avg_propagate_statistics(mvc *sql, sql_exp *e)
+{
+       list *l = e->l;
+       sql_exp *first = l->h->data;
+       atom *omin, *omax;
+
+       if ((omin = find_prop_and_get(first->p, PROP_MIN)) && (omax = 
find_prop_and_get(first->p, PROP_MAX))) {
+               sql_subtype *etype = exp_subtype(e), *ftype = 
exp_subtype(first);
+               if (ftype && etype->type->base.id == ftype->type->base.id) { /* 
average on decimals or intervals */
+                       set_minmax_property(sql, e, PROP_MAX, omax);
+                       set_minmax_property(sql, e, PROP_MIN, omin);
+               } else if (ftype && etype) { /* average on integer types */
+                       assert(etype->type->eclass == EC_FLT);
+                       atom *min_cast = atom_copy(sql->sa, omin), *max_cast = 
atom_copy(sql->sa, omax);
+                       if ((min_cast = atom_cast(sql->sa, min_cast, etype)) && 
(max_cast = atom_cast(sql->sa, max_cast, etype))) {
+                               set_minmax_property(sql, e, PROP_MAX, max_cast);
+                               set_minmax_property(sql, e, PROP_MIN, min_cast);
+                       }
+               }
+       }
+}
+
+static void
 sql_zero_or_one_propagate_statistics(mvc *sql, sql_exp *e)
 {
        list *l = e->l;
@@ -739,7 +762,7 @@ sql_zero_or_one_propagate_statistics(mvc
        }
 }
 
-static struct function_properties functions_list[34] = {
+static struct function_properties functions_list[35] = {
        /* arithmetic functions */
        {"sql_add", &sql_add_propagate_statistics},
        {"sql_sub", &sql_sub_propagate_statistics},
@@ -780,6 +803,7 @@ static struct function_properties functi
        /* aggregates */
        {"min", &sql_min_max_propagate_statistics},
        {"max", &sql_min_max_propagate_statistics},
+       {"avg", &sql_avg_propagate_statistics},
        {"zero_or_one", &sql_zero_or_one_propagate_statistics}
 };
 
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org