MonetDB: Apr2019 - Don't push group by down if its not reduce en...

[Niels Nes]

Changeset: 6ec2b39f2e3c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6ec2b39f2e3c
Modified Files:
        sql/server/rel_optimizer.c
Branch: Apr2019
Log Message:

Don't push group by down if its not reduce enough (later use measure from
other side of join, ie how much that would reduce the right hand side)


diffs (13 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
@@ -4023,7 +4023,8 @@ gen_push_groupby_down(int *changes, mvc 
                        return rel;
                }
 
-               if ((left && is_base(jl->op)) || (!left && is_base(jr->op)))
+               if ((left && is_base(jl->op)) || (!left && is_base(jr->op))||
+                   (left && is_select(jl->op)) || (!left && is_select(jr->op)))
                        return rel;
 
                /* only add aggr (based on left/right), and repeat the group by 
column */
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list