ql/src/test/queries/clientpositive/join_merging.q

explain select p1.p_size, p2.p_size 
from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey 
  right outer join part p3 on p2.p_partkey = p3.p_partkey and 
              p1.p_size > 10
;

explain select p1.p_size, p2.p_size 
from part p1 left outer join part p2 on p1.p_partkey = p2.p_partkey 
  right outer join part p3 on p2.p_partkey = p3.p_partkey and 
              p1.p_size > 10 and p1.p_size > p2.p_size + 10
;