Comment 1 for bug 997747

Revision history for this message
Sergey Petrunia (sergefp) wrote :

Tables D and C are eliminated.
Remaining tables are: { A B E}

Optimization considers a join prefix of {A, B}
best_access_path(<E>) is never called,
because check_interleaving_with_nj() doesn't allow to put it into the join
order,
because join->cur_embedding_map!=0.

This is so, because we've "entered" a join nest for table B and have never left it.

Will need to check why it works in 5.3