Changeset: 17030ce3c92a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/17030ce3c92a
Modified Files:
        sql/server/rel_unnest.c
Branch: Jan2022
Log Message:

push down project in unnest if its under a outerjoin and above semi/anti join.


diffs (12 lines):

diff --git a/sql/server/rel_unnest.c b/sql/server/rel_unnest.c
--- a/sql/server/rel_unnest.c
+++ b/sql/server/rel_unnest.c
@@ -841,7 +841,7 @@ push_up_project(mvc *sql, sql_rel *rel, 
                        list *cexps = NULL;
                        sql_rel *l = r->l;
 
-                       if (l && (is_select(l->op) || l->op == op_join) && 
!rel_is_ref(l)) {
+                       if (l && (is_select(l->op) || l->op == op_join || 
is_semi(l->op)) && !rel_is_ref(l)) {
                                for(n=r->exps->h; n; n=n->next) {
                                        sql_exp *e = n->data;
 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list

Reply via email to