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/01/26 15:24:27 UTC
[GitHub] [shardingsphere] nrg1982lixi opened a new issue #9177: An error of pagination
nrg1982lixi opened a new issue #9177:
URL: https://github.com/apache/shardingsphere/issues/9177
When I was using pagination, sharding-jdbc throw an exception, didn't sharding-jdbc support sub-query?
database: Oracle
sharding-jdbc version: 4.0.1
### SQL: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( select * from MY_TABLE ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ?
### Cause: java.lang.IllegalStateException: Must have sharding column with subquery.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #9177: An error of pagination
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #9177:
URL: https://github.com/apache/shardingsphere/issues/9177
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tristaZero commented on issue #9177: An error of pagination
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9177:
URL: https://github.com/apache/shardingsphere/issues/9177#issuecomment-767999894
Hi @nrg1982lixi
4.0.1 does not support subquery well, I suggest you try a updated release.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #9177: An error of pagination
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #9177:
URL: https://github.com/apache/shardingsphere/issues/9177#issuecomment-774608529
No response
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org