adriangb commented on issue #15886: URL: https://github.com/apache/datafusion/issues/15886#issuecomment-3690580797
I hit this issue as well. I can confirm that Postgres, DuckDB, BigQuery, ClickHouse and SQLite do preserve the order from the subquery / CTE. I understand that technically this may be acceptable behavior, but I have not been able to find *any* system that has this behavior. @ozankabak @suibianwanwank could you share some of the database systems have this behavior? I would like to propose that we (1) make this configurable and (2) change the default since (a) the majority of popular systems seem to behave in the same way and (b) the safer behavior is to preserve the order by even if it has some performance cost. -- 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]
