select id from app where id in (select id from app limit 1);
select id from app where id in (select id from (select id from app limit 1) as t);

第一个报错：

select id from app where id in (select id from app limit 1)
1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

第二个正确.