asolimando commented on issue #18863: URL: https://github.com/apache/datafusion/issues/18863#issuecomment-3561974663
@alchemist51, can you be more specific on what is the problem you see? To me this is working as expected. The two result sets are both correct w.r.t. the query, you order by "c" and that's respected in both cases, the relative order within the "groups" is implementation-dependent (it's a set, so it doesn't have any ordering, per se), and it doesn't necessarily have to be stable nor it can be relied upon. If you need a stable ordering on the groups, you need to expand the "order by" to the grouping columns too (and handle tie breaking), or reformulate the query to use a window function, for instance. -- 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]
