findepi opened a new issue, #17138: URL: https://github.com/apache/datafusion/issues/17138
This passes in DataFusion 49.0.0 ``` statement ok CREATE TABLE tab1(col0 INTEGER, col1 INTEGER, col2 INTEGER) statement ok INSERT INTO tab1 VALUES(51,14,96) statement ok INSERT INTO tab1 VALUES(85,5,59) statement ok INSERT INTO tab1 VALUES(91,47,68) query R SELECT + CAST ( NULL AS INTEGER ) * + + AVG ( DISTINCT 4 ) + - SUM ( ALL + col1 ) AS col0 FROM tab1 ---- NULL ``` the query fails on current main ``` 1. query failed: DataFusion error: Execution error: avg(DISTINCT) aggregations are not available [SQL] SELECT + CAST ( NULL AS INTEGER ) * + + AVG ( DISTINCT 4 ) + - SUM ( ALL + col1 ) AS col0 FROM tab1 ``` -- 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.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
