You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/08/04 11:02:02 UTC
[GitHub] [shardingsphere] YollinChan opened a new issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
YollinChan opened a new issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645
for example，sql like: "SELECT s.id from (select id from table_a where id >= 0 limit 0,1000) as s order by s.id desc;" will encounter a "IllegalStateException".
but sql like "SELECT s.id from (select id from table_a where id >= 0 limit 0,1000) as s order by id desc;" can execute normally
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] YollinChan commented on issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
Posted by GitBox <gi...@apache.org>.
YollinChan commented on issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645#issuecomment-892566952
exception message is "Can not find owner from table."
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] YollinChan commented on issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
Posted by GitBox <gi...@apache.org>.
YollinChan commented on issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645#issuecomment-892566952
exception message is "Can not find owner from table."
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645#issuecomment-893094897
Duplicate with issue #10257. You can try `5.0.0-beta` version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645#issuecomment-893094897
Duplicate with issue #10257. You can try `5.0.0-beta` version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #11645: shardingsphere executing sql that included subQuery and “order by alias.field” will throw a "IllegalStateException"
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #11645:
URL: https://github.com/apache/shardingsphere/issues/11645
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org