This version of MariaDB doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’

原文链接：This version of MariaDB doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ – 每天进步一点点 (longkui.site)

运行sql的时候报这个错误，这个错误的原因是sql语句中IN语句内层带有limit语句，比如下面这样：

	SELECT * from stu
	WHERE id IN (
		SELECT uuid from motnt LIMIT 2
	);

我们参考下面的sql 改装一下就可以了

	SELECT * from stu
	WHERE id IN (
		SELECT tt.* from 
		 (SELECT uuid from motnt LIMIT 2) as tt
	);

原则就是多嵌套一层。