Spole0168 opened a new issue #6550: URL: https://github.com/apache/shardingsphere/issues/6550
I am using the 4.0.1 version of sharingjdbc to link to the oracle database and encounter problems with paging display data. Currently sharingjdbc supports nesting of subqueries once, but Oracle paging can only be achieved by nesting twice with rownum. The recommendation on the official website is the same. When using it, it will report an error "Must have sharding column with subquery", just remove one level of nesting. How to deal with Oracle paging? Official suggestion link: https://shardingsphere.apache.org/document/legacy/4.x/document/cn/features/sharding/use-norms/pagination/   ---------------------------------------------------------------- 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]
