testdata/workloads/functional-query/queries/QueryTest/joins-partitioned.test

====
---- QUERY
# Regression test for IMPALA-1987. Equi-join predicates of outer joins contain
# TupleIsNullPredicate exprs.
# TODO: Move back to inline-views.test when this works with the non-partitioned hash
# join (IMPALA-2375).
select t1.int_col, t2.int_col, t3.id
from alltypestiny t1 left outer join
  (select coalesce(int_col, 384) as int_col from alltypestiny) t2
  on t1.int_col = t2.int_col
left outer join
  (select 0 as id from alltypestiny) t3
  on t1.int_col = t3.id
order by 1 limit 5
---- RESULTS
0,0,0
0,0,0
0,0,0
0,0,0
0,0,0
---- TYPES
INT,INT,TINYINT
====
---- QUERY
# Regression test for IMPALA-2495: Crash: impala::InPredicate::SetLookupPrepare
# TODO: Move back to exprs.test when this works with the non-partitioned hash join
# (IMPALA-2375).
select count(id) from functional.alltypestiny t1
left join (select coalesce(1, 10) as int_col
from functional.alltypessmall) t2 on t1.id = t2.int_col
where t2.int_col in (t2.int_col, 10);
---- RESULTS
100
---- TYPES
BIGINT
====