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.
Tables D and C are eliminated.
Remaining tables are: { A B E}
Optimization considers a join prefix of {A, B} path(<E> ) is never called, ing_with_ nj() doesn't allow to put it into the join embedding_ map!=0.
best_access_
because check_interleav
order,
because join->cur_
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