Caused exception message is: 该游标未声明。

执行查询sql时提示：Caused exception message is: 该游标未声明。

SELECT 
a.* 
FROM
(
SELECT
id,
name,
age,
bid
from a
LEFT JOIN b ON  a.bid=b.id
WHERE xxx
ORDER BY  xxx
) a

解决方法：
移除 ORDER BY xxx 语句，放置sql末尾

SELECT 
a.* 
FROM
(
SELECT
id,
name,
age,
bid
from a
LEFT JOIN b ON  a.bid=b.id
WHERE xxx
) a
ORDER BY  xxx