Github user gatorsmile commented on the issue:
https://github.com/apache/spark/pull/17039
The major issue is we do not know the original intention of users' query.
The query might purposely check whether the result set is sorted or not. Thus,
the existing test suite design is conservative to avoid adding any sort as long
as users specify the ORDER BY clause. For example,
```SQL
SELECT c1, c2, sum(c1) FROM tab1 GROUP BY c1, c2 ORDER BY c1, c2
```
In the above example, although the order by clause does not contain all the
columns, the result set is always sorted. Thus, our test suite should not sort
it.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
