MonetDB: Aug2024 - exclude select expression when adding join (o...

[Niels Nes via checkin-list]

Changeset: b74ace65b88e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b74ace65b88e
Modified Files:
        sql/server/rel_optimize_sel.c
Branch: Aug2024
Log Message:

exclude select expression when adding join (only) expressions. Solves issue 
#7585.


diffs (12 lines):

diff --git a/sql/server/rel_optimize_sel.c b/sql/server/rel_optimize_sel.c
--- a/sql/server/rel_optimize_sel.c
+++ b/sql/server/rel_optimize_sel.c
@@ -2264,7 +2264,7 @@ order_joins(visitor *v, list *rels, list
                                for (en = sdje->h; en; ) {
                                        node *next = en->next;
                                        sql_exp *e = en->data;
-                                       if ((direct && ((e->flag <= 
cmp_notequal && (h[e->tmp] & rel_mask) == h[e->tmp]) || (e->flag > cmp_notequal 
&& rel_rebind_exp(v->sql, top, e))))  ||
+                                       if ((direct && ((e->flag <= 
cmp_notequal && (h[e->tmp] & rel_mask) == h[e->tmp] && h[e->tmp]) || (e->flag > 
cmp_notequal && rel_rebind_exp(v->sql, top, e))))  ||
                                            (!direct && rel_rebind_exp(v->sql, 
top, e))) {
                                                rel_join_add_exp(v->sql->sa, 
top, e);
                                                list_remove_data(sdje, NULL, 
en->data);
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org