gianm commented on PR #18183: URL: https://github.com/apache/druid/pull/18183#issuecomment-3022461151
> interesting that result order changes in some cases - but its not ordered; so it doesn't matter.... I thought that was odd too, and tracked it down to a feature in Quidem. It sorts resultsets when it believes that the SQL query does not have an `ORDER BY` (I say "believes" because it does not really have a true parser, it's a simple function `Quidem#isProbablyDeterministic`). The idea is that when the SQL query is not explicitly ordered, the underlying database might return rows in any order, so Quidem wants to ignore the order. It uses a simple lexicographic sort that includes whitespace, so whitespace differences can cause the results to end up in a different order. -- 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]
