[GitHub] [incubator-doris] whatsgh opened a new issue #5025: order by with offset limit each result is unstable

[GitBox]

whatsgh opened a new issue #5025:
URL: https://github.com/apache/incubator-doris/issues/5025


   **Describe the bug**
   use duplicate model：
   pic1:this is limit 10 result:
   
![image](https://user-images.githubusercontent.com/18162700/101138080-a9d94380-364a-11eb-8b2e-af32ad1ec2b3.png)
   pic2:this is limit 0,3 result:
   
![image](https://user-images.githubusercontent.com/18162700/101138820-a7c3b480-364b-11eb-94b3-86a29bef1a5e.png)
   
   pic3:this is limit 3,3 result:
   
![image](https://user-images.githubusercontent.com/18162700/101138850-adb99580-364b-11eb-9a26-7276200aaadb.png)
   
   The order of result per page is not stable，
   
   
   **Expected behavior**
   The expected result per page is sorted by pic 1
   


----------------------------------------------------------------
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:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org