Skip to content

Extended sqllite tests are failing on main #14853

@alamb

Description

@alamb

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

@jayzhan211 has a fix in

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingregressionSomething that used to work no longer does

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions