cunlianer opened a new issue, #31221: URL: https://github.com/apache/shardingsphere/issues/31221
In SQL statements with deep pagination, such as table partitioning, there are the following SQL statements: select fields from tableName t1 inner join (select id from tableName limit 2000000,10) t2 on t2. id=t1. id When the number of records in a single table is less than 2000000 but the total number is more than 2000000, deep pagination retrieves an empty record. I suspect that pagination can only obtain data on the number of records in a single 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
