ISSUE: IN sub query predicates are transformed into
semi join.
This transformation does not correctly reset
embedding_join_nest for sub selects.
Due to this, when number of IN expressions exceeds MAX_TABLES,
server exits abnormally.

SOLUTION:
Corrected setting of embedding_join_nest for sub selects,
as part of converting IN sub query predicates to semi join.