HarrySheep opened a new issue, #14334: URL: https://github.com/apache/shardingsphere/issues/14334
## Question What happens? I'm using sharding-jdbc springboot, trying to perform pagination (with PageHelper) with 2 sharding tables (in Oracle). The result sets seem like containing all the result I need, but they have not been sorted. So I wonder if i configure it wrong or what? I have searched for it for a long time, but I never found a proper solution. Here's some configuration and the test code: **Maven Dependency:**  **Configuration:**  **Sharding Algorithm:** Plz ignore it for now. It seems to have nothing to do with this issue. **Test Code:**   **Mybatis Mapper:**  **Here's the result sets:**  **The SQL Log:**  What it appears? And above all, we can see that it scanned through 2 tables, nfs_push_sent_message and nfs_push_sent_message_2021, and the sql did have the "order by STATUS_TIME desc" phase clearly. But still, the "order column" in **result sets were not ordered**. If you need any further information, please contact me at any time. Thank for for taking a look at the question. -- 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]
