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

we need to check all 3 tables for all range expressions


diffs (16 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
@@ -2223,9 +2223,10 @@ order_joins(visitor *v, list *rels, list
                                        l = rels_a[r1[cje->tmp]];
                                if (rel_mask & 
(((ulng)1)<<((r2[cje->tmp]-1)%64)))
                                        r = rels_a[r2[cje->tmp]];
-                               if (cje->f && r3[cje->tmp] && (rel_mask & 
(((ulng)1)<<((r3[cje->tmp]-1)%64)))) {
-                                       f = rels_a[r3[cje->tmp]];
+                               if (cje->f && r3[cje->tmp]) {
                                        needs3 = 1;
+                                       if (rel_mask & 
(((ulng)1)<<((r3[cje->tmp]-1)%64)))
+                                               f = rels_a[r3[cje->tmp]];
                                }
                        }
                        if (!direct) { /* check if at least one side in n_rels 
*/
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to