alamb commented on code in PR #8525: URL: https://github.com/apache/arrow-datafusion/pull/8525#discussion_r1425769320
########## datafusion/sqllogictest/test_files/distinct_on.slt: ########## @@ -38,17 +38,17 @@ LOCATION '../../testing/data/csv/aggregate_test_100.csv' # Basic example: distinct on the first column project the second one, and # order by the third query TI -SELECT DISTINCT ON (c1) c1, c2 FROM aggregate_test_100 ORDER BY c1, c3; +SELECT DISTINCT ON (c1) c1, c2 FROM aggregate_test_100 ORDER BY c1, c3, c9; Review Comment: I think changing the order by changes the results because DISTINCT ON basically picks the first values for each of the distinct values (of c1) in this case -- 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...@arrow.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
