MonetDB: Nov2019 - allow somemore push down of select expressions

[Niels Nes]

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

allow somemore push down of select expressions


diffs (19 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
@@ -4951,11 +4951,13 @@ rel_join_push_exps_down(int *changes, mv
                        int le = rel_has_cmp_exp(l, e);
                        int re = rel_has_cmp_exp(r, e);
 
-                       if (le && !re) {
+                       /* select expressions on left */
+                       if (le && !re) { 
                                if (!lexps)
                                        lexps=sa_list(sql->sa);
                                append(lexps, e);
-                       } else if (!le && re && rel->op != op_anti) {
+                       /* select expressions on right */
+                       } else if (!le && re && (rel->op != op_anti || (e->flag 
!= mark_notin && e->flag != mark_in))) { 
                                if (!rexps)
                                        rexps=sa_list(sql->sa);
                                append(rexps, e);
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list