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

--! qt:dataset:part
set hive.mapred.mode=nonstrict;
explain select p1.p_name, p2.p_name
from part p1 , part p2;

explain select p1.p_name, p2.p_name, p3.p_name
from part p1 ,part p2 ,part p3 
where p1.p_name = p2.p_name and p2.p_name = p3.p_name;

explain select p1.p_name, p2.p_name, p3.p_name
from part p1 , (select p_name from part) p2 ,part p3 
where p1.p_name = p2.p_name and p2.p_name = p3.p_name;

explain select p1.p_name, p2.p_name, p3.p_name
from part p1 , part p2 , part p3 
where p2.p_partkey + p1.p_partkey = p1.p_partkey and p3.p_name = p2.p_name;

explain select p1.p_name, p2.p_name, p3.p_name, p4.p_name
from part p1 , part p2 join part p3 on p2.p_name = p1.p_name join part p4 
where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey 
            and p1.p_partkey = p2.p_partkey;
            
explain select p1.p_name, p2.p_name, p3.p_name, p4.p_name
from part p1 join part p2 on p2.p_name = p1.p_name , part p3  , part p4 
where p2.p_name = p3.p_name and p1.p_partkey = p4.p_partkey 
            and p1.p_partkey = p2.p_partkey;