2671884528 opened a new issue, #30218:
URL: https://github.com/apache/shardingsphere/issues/30218

   以下是可以正确拿到数据的
   SELECT * FROM trade_order ORDER BY create_time OFFSET 0 ROW FETCH NEXT 10 
ROWS ONLY;
   以下是拿不到数据的(OFFSET不同而已)
   SELECT * FROM trade_order ORDER BY create_time OFFSET 10 ROW FETCH NEXT 10 
ROWS ONLY;
   
   分析原因
   这个判断有问题,导致无法获取数据。这里的逻辑不正确
   
![image](https://github.com/apache/shardingsphere/assets/39427887/5ac5a63e-98fc-49da-be07-c4e51600e42e)
   


-- 
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]

Reply via email to