TheBuilderJR opened a new issue, #13904:
URL: https://github.com/apache/datafusion/issues/13904
### Describe the bug
Generally for almost all other sql query engines I expect
```
SELECT * FROM (
SOME_ORDERED_SUB_QUERY_HERE
) AS query LIMIT 10000
```
to maintain the same order as the subquery, eg.
SELECT * FROM (
SELECT
session.access_token,
COUNT(1) as c
FROM quizchat_chats
GROUP BY session.access_token
ORDER BY c
) AS query LIMIT 10000
But in datafusion, it doesn't! It seemingly returns a randomly ordered list.
### To Reproduce
Run a SELECT * FROM over an ordered subquery
### Expected behavior
ordering is preserved
### Additional context
_No response_
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
