strongduanmu commented on issue #11338: URL: https://github.com/apache/shardingsphere/issues/11338#issuecomment-881192162
> Hi，I am studying ShardingSphere recently. I don’t quite understand this piece of logic, why this modification can fix this problem, can you explain it? > > Does this modification solve similar problems？ like this: > > ```sql > select * from t_order order by abs(user_id); > ``` @MingxingLAI Because in a distributed scenario, we need to ensure that the results are in order, and we need to sort and merge the ordered results on different data nodes. At this time, we need to take out the field value of order by for sorting. However, query results may not contain the field value of the order by, so it needs to be added when rewriting. The query statement that contains shorthand is not correct when dealing with rewriting. -- 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]
