make semi-joins to work with nested joins

Description

merge (or reimplement) 5.6 optimizations related to semi-joins and nested joins

Assignee

Unassigned

Reporter

Sergei Golubchik

Labels

None

Priority

Critical
Configure