mycat 为啥不支持select * from ( select * from A START WITH ID = '123' CONNECT BY PID = PRIOR ID)

Question

mycat 为啥不支持

select * from ( select * from A START WITH ID = '123' CONNECT BY PID = PRIOR ID)

这样写却没错

select * from A START WITH ID = '123' CONNECT BY PID = PRIOR ID

 

Answer 1

同样遇到了这个问题，解决了吗？是什么原因？

Answer 2

不是mycat不支持 是sql有点问题 第一个查询的结果集后面加个别名应该就行了

Answer 3

感谢您的回答，不懂请不要回答，放屁请一边去。谢谢