Omega359 commented on code in PR #10: URL: https://github.com/apache/datafusion-testing/pull/10#discussion_r2273455392
########## data/sqlite/random/expr/slt_good_95.slt: ########## @@ -22676,10 +22691,16 @@ SELECT ALL 11 + NULLIF ( - - 79, 13 / + 44 * + + COUNT ( * ) ) AS col2 ---- 90 -# Datafusion - Datafusion expected results: -# Datafusion - Expected - 35 -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 - 35 +# Datafusion - Types were automatically converted from: +# Datafusion - [Expected] [I] +# Datafusion - [Actual ] [R] +query R rowsort label-4329 SELECT + NULLIF ( 95, - + 92 ) + + 14 + - MIN ( DISTINCT 74 ) + 24 / - CASE 95 WHEN + + 29 THEN + COALESCE ( - + 36, + + AVG ( DISTINCT + 29 ) * 82 ) * CAST ( - 78 AS INTEGER ) + MAX ( ALL - 41 ) + 39 * CAST ( NULL AS INTEGER ) * - - CASE + CASE ( + 24 ) WHEN - - 46 THEN NULL WHEN - CAST ( - - 99 AS INTEGER ) THEN + - 75 + + 49 + - 48 + - 64 END WHEN + 76 - + + 33 / + 13 + - + 70 THEN - 35 / 88 ELSE NULL END * - 27 * - - 60 WHEN + - 47 THEN NULL ELSE - 80 END * - + 96 AS col0 +---- +6.2 Review Comment: It must match the postgresql result or it would have been flagged. It's not the first time I've seen the sqlite test result (the 35) not match other databases like pg or duckdb (I verified this one with duckdb as well). -- 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
