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
Describe the bug
Example failure:
https://github.com/apache/datafusion/actions/runs/13467161088/job/37635189226
To Reproduce
Run extended sqloite tests
Expected behavior
they should pass
Additional context
This was introduced in
plan_aggregateandplan_windowto planner #14689 (as pointed out by @ozankabak here Remove CountWildcardRule in Analyzer and move the functionality in ExprPlanner, addplan_aggregateandplan_windowto planner #14689 (comment))@jayzhan211 has a fix in