Omega359 commented on code in PR #10: URL: https://github.com/apache/datafusion-testing/pull/10#discussion_r2268269086
########## data/sqlite/random/aggregates/slt_good_45.slt: ########## @@ -15713,13 +15713,10 @@ SELECT DISTINCT - - col1 AS col0, + col1 AS col1 FROM tab1 AS cor0 WHERE col2 IS 5 5 -# Datafusion - Types were automatically converted from: -# Datafusion - [Expected] [I] -# Datafusion - [Actual ] [R] -query R rowsort label-2592 +# Datafusion - Datafusion expected results: +# Datafusion - Expected - NULL +query error DataFusion error: Execution error: avg\(DISTINCT\) aggregations are not available SELECT AVG ( DISTINCT - - col1 ) * CAST ( NULL AS FLOAT8 ) * ( + - CAST ( NULL AS INTEGER ) ) - - ( COUNT ( * ) ) AS col2 FROM tab0 cor0 Review Comment: This one is interesting - it used to succeed (even though DF doesn't support avg(distinct)) and now it fails with the expected error on avg(distinct). -- 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
