ql/src/test/queries/clientnegative/subquery_corr_grandparent.q

--! qt:dataset:part
-- inner query can only refer to it's parent query columns
select *
from part x 
where x.p_name in (select y.p_name from part y where exists (select z.p_name from part z where x.p_name = z.p_name))
;