Omega359 commented on code in PR #10: URL: https://github.com/apache/datafusion-testing/pull/10#discussion_r2273429749
########## data/sqlite/random/aggregates/slt_good_100.slt: ########## @@ -26465,11 +26468,14 @@ SELECT DISTINCT - col2 AS col2, CAST ( - col0 AS INTEGER ) + + 58 FROM tab0 -99 -39 -# Datafusion - Datafusion expected results: -# Datafusion - Expected - 32 -# Datafusion - Expected - NULL -query error DataFusion error: Execution error: avg\(DISTINCT\) aggregations are not available +# Datafusion - Types were automatically converted from: +# Datafusion - [Expected] I[I] +# Datafusion - [Actual ] I[R] +query IR rowsort label-4361 SELECT DISTINCT + 32 AS col0, CAST ( + CAST ( NULL AS INTEGER ) AS INTEGER ) + - MIN ( ALL 59 ) * - AVG ( DISTINCT 64 ) AS col2 FROM tab2 +---- +32 +NULL Review Comment: Yeah, the result mode for the files that came from sqlite are in valuewise mode which is one result per row. I vaguely recall having code to do the conversion at one point but I recall having issues with it so left it as is. -- 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
