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: [email protected]
