2671884528 opened a new issue, #30222: URL: https://github.com/apache/shardingsphere/issues/30222
The following is the correct way to obtain the data SELECT * FROM trade_order ORDER BY create_time OFFSET 0 ROW FETCH NEXT 10 ROWS ONLY; The following data cannot be obtained (OFFSET is different) SELECT * FROM trade_order ORDER BY create_time OFFSET 10 ROW FETCH NEXT 10 ROWS ONLY; Analyze the reasons There is a problem with this judgment and the data cannot be obtained. The logic here is incorrect For this SQL OFFSET 10 ROW FETCH NEXT 10 ROWS ONLY, rowNumber++ <= pagination.getActualRowCount().get() is always false  -- 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]
