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