Omega359 commented on code in PR #10:
URL: https://github.com/apache/datafusion-testing/pull/10#discussion_r2273450615


##########
data/sqlite/random/expr/slt_good_63.slt:
##########
@@ -13316,11 +13331,18 @@ SELECT ALL + COUNT ( * ) / 79
 ----
 0
 
-# Datafusion - Datafusion expected results:
-# Datafusion - Expected - 50
-# Datafusion - Expected - -12
-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 - 50
+# Datafusion - -12
+# Datafusion - Types were automatically converted from:
+# Datafusion - [Expected] I[I]
+# Datafusion - [Actual  ] I[R]
+query IR rowsort label-2529
 SELECT ALL + 50 AS col2, + 62 / - - COALESCE ( - + 5, - - COUNT ( * ) / - + 
AVG ( DISTINCT 81 ) + - 24 - - CAST ( NULL AS INTEGER ) + COUNT ( 94 ) * - 3 * 
- 4 * + 42 + + 82 + - ( + - 59 ) ) AS col0
+----
+50
+-12.4

Review Comment:
   matches postgres result.



-- 
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

Reply via email to