You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "alamb (via GitHub)" <gi...@apache.org> on 2025/02/24 14:20:44 UTC

[I] Extended sqllite tests are failing on main [datafusion]

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-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] Extended sqllite tests are failing on main [datafusion]

Posted by "Omega359 (via GitHub)" <gi...@apache.org>.
Omega359 commented on issue #14853:
URL: https://github.com/apache/datafusion/issues/14853#issuecomment-2678704673

   I'm glad to see the tests catch something 


-- 
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-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] Extended sqllite tests are failing on main [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb commented on issue #14853:
URL: https://github.com/apache/datafusion/issues/14853#issuecomment-2678783851

   > I'm glad to see the tests catch something
   
   For sure -- this is a real regression that the tests caught


-- 
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-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] Extended sqllite tests are failing on main [datafusion]

Posted by "alamb (via GitHub)" <gi...@apache.org>.
alamb closed issue #14853: Extended sqllite tests are failing on main
URL: https://github.com/apache/datafusion/issues/14853


-- 
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-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org