alamb opened a new issue, #14853: URL: https://github.com/apache/datafusion/issues/14853
### Describe the bug Example failure: https://github.com/apache/datafusion/actions/runs/13467161088/job/37635189226 ``` External error: query failed: DataFusion error: Schema error: Schema contains duplicate unqualified field name "count(*)" [SQL] SELECT - COUNT ( * ) * - 97 * - COALESCE ( + CAST ( + 68 AS INTEGER ), - + CASE - + 63 WHEN - + COALESCE ( + COUNT ( + 70 ), - 26 * - NULLIF ( + + 37, - 4 ) ) / COUNT ( ALL 42 ) * + + CAST ( - COUNT ( DISTINCT + 49 ) AS INTEGER ) + - 79 * - COUNT ( * ) THEN - COALESCE ( - COUNT ( * ), - 37 ) + + MIN ( + 71 ) WHEN 27 * - 52 THEN NULL ELSE NULL END ) AS col2 at ../../datafusion-testing/data/sqlite/random/expr/slt_good_44.slt:65 External error: query failed: DataFusion error: Schema error: Schema contains duplicate unqualified field name "count(*)" [SQL] SELECT - COUNT ( * ) - - COUNT ( + 43 ) AS col0 at ../../datafusion-testing/data/sqlite/random/expr/slt_good_89.slt:363 External error: query failed: DataFusion error: Schema error: Schema contains duplicate unqualified field name "count(*)" [SQL] SELECT DISTINCT - ( + CASE - + COUNT ( 75 ) WHEN 22 THEN - 35 ELSE + - 43 - + COUNT ( * ) END ) * 43 + + 41 / 6 + 65 / + 38 at ../../datafusion-testing/data/sqlite/random/expr/slt_good_79.slt:396 External error: query failed: DataFusion error: Schema error: Schema contains duplicate unqualified field name "count(*)" [SQL] SELECT - col1 * - COUNT ( - + col1 ) * + - COUNT ( * ) + col1 * ( - COUNT ( 31 ) ) * col1 + COUNT ( * ) col0 FROM tab0 cor0 GROUP BY col1, col1 HAVING ( NULL ) IS NULL at ../../datafusion-testing/data/sqlite/random/groupby/slt_good_12.slt:29528 ``` ### To Reproduce Run extended sqloite tests ### Expected behavior they should pass ### Additional context This was introduced in - https://github.com/apache/datafusion/pull/14689 (as pointed out by @ozankabak here https://github.com/apache/datafusion/pull/14689#issuecomment-2676043465) @jayzhan211 has a fix in - https://github.com/apache/datafusion/pull/14824 -- 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
