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 -- [email protected]
To unsubscribe send an email to [email protected]