Changeset: 0a0f9206de3f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/0a0f9206de3f
Modified Files:
sql/server/rel_optimize_sel.c
Branch: default
Log Message:
workaround to many join reorders, fixes bug 7466
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
@@ -2469,7 +2469,7 @@ run_optimizer
bind_join_order(visitor *v, global_props *gp)
{
int flag = v->sql->sql_optimizer;
- return gp->opt_level == 1 && !gp->cnt[op_update] && (gp->cnt[op_join]
|| gp->cnt[op_left] ||
+ return gp->opt_level == 1 && gp->opt_cycle < 10 && !gp->cnt[op_update]
&& (gp->cnt[op_join] || gp->cnt[op_left] ||
gp->cnt[op_right] || gp->cnt[op_full]) && (flag &
join_order) ? rel_join_order : NULL;
}
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]