Omega359 commented on code in PR #10: URL: https://github.com/apache/datafusion-testing/pull/10#discussion_r2273447781
########## data/sqlite/random/expr/slt_good_56.slt: ########## @@ -10795,10 +10816,16 @@ SELECT ALL - CASE 56 WHEN - 16 + + COUNT ( * ) * + - COUNT ( * ) * - 78 * - 24 T ---- NULL -# Datafusion - Datafusion expected results: -# Datafusion - Expected - -90 -query error DataFusion error: Execution error: avg\(DISTINCT\) aggregations are not available +# Datafusion - Data was automatically updated based on comparison db results +# Datafusion - Previous results: +# Datafusion - -90 +# Datafusion - Types were automatically converted from: +# Datafusion - [Expected] [I] +# Datafusion - [Actual ] [R] +query R rowsort label-2056 SELECT + COALESCE ( + COALESCE ( COUNT ( * ), - 93 ), + - 30 / - 73 + + CAST ( + - 13 AS INTEGER ), ( CASE 4 WHEN + ( + 16 ) THEN NULL WHEN 20 - - + 12 THEN 48 WHEN - + 27 THEN NULL END ) / + 90 * + 6 + 93 * AVG ( DISTINCT + - 50 ) * - 51 ) / - 87 + - ( 85 ) + - 5 +---- +-90.011494252874 Review Comment: It matches the postgres result within a few decimal places. -- 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
