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