[GitHub] [shardingsphere] strongduanmu edited a comment on issue #10806: ## Wrong LIMIT rewrite while GROUP BY and ORDER BY

[GitBox <gi...@apache.org>]

strongduanmu edited a comment on issue #10806:
URL: https://github.com/apache/shardingsphere/issues/10806#issuecomment-861123359


   @lyflyy Thank you for your feedback. Since the `orders` table is a sharding table with multiple data nodes, when calculating `SUM(price)`, we need to obtain data on different nodes, and then perform aggregation calculations. Therefore, the limit clause needs to be rewritten to meet the data needed for the calculation. 
   
   For more information, you can refer to the [doc](https://shardingsphere.apache.org/document/current/cn/features/sharding/principle/merge/) of the merge engine.


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