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

select *
from src
where src.key in (select key from src where key > '9')
;