jonahgao commented on issue #9394: URL: https://github.com/apache/datafusion/issues/9394#issuecomment-2212453652
> I took a look at Postgres cross join behavior, it looks like the order of the result is not deterministic either (meaning it feel free to decide which table is small and should be materialized inside memory, and the order of the output will be based on this decision) @duongcongtoai Yes. Order itself is not an issue. A relation is an **unordered** set. "Two relational algebra expressions are said to be equivalent if on every legal database instance the two expressions generate the same set of tuples." and as stated in the PostgreSQL [documentation](https://www.postgresql.org/docs/current/queries-order.html): > If sorting is not chosen, the rows will be returned in an unspecified order. The actual order in that case will depend on the scan and join plan types and the order on disk, but it must not be relied on. -- 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 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
