[GitHub] [doris] zclllyybb opened a new pull request, #19599: [bugfix](scanner) Fix topN-with-limit behaviour of duplicate key with scanner pooling

[via GitHub]

zclllyybb opened a new pull request, #19599:
URL: https://github.com/apache/doris/pull/19599

   # Proposed changes
   
   Issue Number: close DORIS-4362
   
   ## Problem summary
   
   before:
   ```
   mysql> SELECT ss_item_sk FROM store_sales ORDER BY ss_sold_date_sk DESC, 
ss_sold_time_sk DESC, ss_item_sk DESC LIMIT 10;
   +------------+
   | ss_item_sk |
   +------------+
   |      17899 |
   |      17899 |
   |      16866 |
   |      16866 |
   |      16236 |
   |      16236 |
   |      16161 |
   |      16161 |
   |      15012 |
   |      15012 |
   +------------+
   ```
   after:
   ```
   mysql> SELECT ss_item_sk FROM store_sales ORDER BY ss_sold_date_sk DESC, 
ss_sold_time_sk DESC, ss_item_sk DESC LIMIT 10;
   +------------+
   | ss_item_sk |
   +------------+
   |      17899 |
   |      16866 |
   |      16236 |
   |      16161 |
   |      15012 |
   |      11905 |
   |       9205 |
   |       8280 |
   |       6345 |
   |       5400 |
   +------------+
   ```
   
   ## Checklist(Required)
   
   * [ ] Does it affect the original behavior
   * [x] Has unit tests been added
   * [ ] Has document been added or modified
   * [ ] Does it need to update dependencies
   * [x] Is this PR support rollback (If NO, please explain WHY)
   
   


-- 
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: commits-unsubscr...@doris.apache.org

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