Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Extended sqllite tests are failing on main #14853

Open
Tracked by #14123
alamb opened this issue Feb 24, 2025 · 2 comments · May be fixed by #14824
Open
Tracked by #14123

Extended sqllite tests are failing on main #14853

alamb opened this issue Feb 24, 2025 · 2 comments · May be fixed by #14824
Labels
bug Something isn't working regression Something that used to work no longer does

Comments

@alamb
Copy link
Contributor

alamb commented Feb 24, 2025

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

@Omega359
Copy link
Contributor

I'm glad to see the tests catch something

@alamb
Copy link
Contributor Author

alamb commented Feb 24, 2025

I'm glad to see the tests catch something

For sure -- this is a real regression that the tests caught

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working regression Something that used to work no longer does
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants