Why doesn't LIMIT work in a nested query [WHERE a IN ( SELECT a FROM b LIMIT 1 )]?

Question

SQL

Why does it not work with LIMIT (gives out emptiness), but does it work without LIMIT?

SELECT *  FROM b WHERE a IN ( SELECT а FROM b LIMIT 1  )

Thank you.

Answer 1

Limit in subqueries is not supported.
MySQL does not support LIMIT in subqueries for ce...

SELECT * FROM t1
WHERE s1 IN (SELECT s2 FROM t2 ORDER BY s1 LIMIT 1);
ERROR 1235 (42000): This version of MySQL doesn't yet support
 'LIMIT & IN/ALL/ANY/SOME subquery'

Answer 2

Perhaps you are not getting an error?
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'