[I] SELECT * FROM subquery ignores ordering [datafusion]

[via GitHub]

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: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org