Expand description

Optimizer rule for rewriting subquery filters to joins

It handles standalone parts of logical conjunction expressions, i.e.

  WHERE t1.f IN (SELECT f FROM t2) AND t2.f = 'x'

will be rewritten, but

  WHERE t1.f IN (SELECT f FROM t2) OR t2.f = 'x'

won’t

Structs

Optimizer rule for rewriting subquery filters to joins