framework/resources/Functional/subqueries/bugs/drill-2069-with-alias.sql

select * from `t1.json` where a1 in (select a2 from `t2.json`);