Skip to content

Extended tests are failing on main #14549

@alamb

Description

@alamb

Describe the bug

Example: https://github.com/apache/datafusion/actions/runs/13203566677/job/36861234807

External error: query is expected to fail with error:
	(regex) DataFusion error: External error: External error: Arrow error: Divide by zero error
but got error:
	DataFusion error: Arrow error: Divide by zero error
[SQL] SELECT DISTINCT col1 AS col1 FROM tab0 WHERE NOT + CASE + 87 WHEN col1 THEN col1 ELSE NULL END NOT BETWEEN - col1 / + col1 AND NULL GROUP BY col1 HAVING NOT col1 * 75 IS NOT NULL
at ../../datafusion-testing/data/sqlite/random/groupby/slt_good_12.slt:12141

External error: query is expected to fail with error:
	(regex) DataFusion error: External error: External error: Arrow error: Divide by zero error
but got error:
	DataFusion error: Arrow error: Divide by zero error
[SQL] SELECT DISTINCT tab0.col1 FROM tab0 GROUP BY col1 HAVING NULL = + col1 / tab0.col1
at ../../datafusion-testing/data/sqlite/random/groupby/slt_good_7.slt:17941

External error: query is expected to fail with error:
	(regex) DataFusion error: External error: External error: Arrow error: Divide by zero error
but got error:
	DataFusion error: Arrow error: Divide by zero error
[SQL] SELECT ALL ( 19 ) FROM tab0 AS cor0 WHERE NULL BETWEEN + CAST ( + col1 AS INTEGER ) + - - col0 + col2 * - 76 + col1 * - 8 / + col1 * - + col0 / - - col2 AND - col2 + col0 * + + col1 * col2 GROUP BY col2 HAVING NOT ( - ( + ( 44 ) ) ) IS NULL
at ../../datafusion-testing/data/sqlite/random/groupby/slt_good_11.slt:21271

error: test failed, to rerun pass `-p datafusion-sqllogictest --test sqllogictests`

Caused by:
  process didn't exit successfully: `/__w/datafusion/datafusion/target/release-nonlto/deps/sqllogictests-2f94f[911](https://github.com/apache/datafusion/actions/runs/13203566677/job/36861234807#step:5:912)ca12b448 --include-sqlite` (exit status: 1)
Error: Process completed with exit code 1.

To Reproduce

No response

Expected behavior

No response

Additional context

I am pretty sure it was due to #14371

The fix is to update the expected output in datafusion-testing

And then we need to update the pin in datafusion to the latest datafusion-testing pin

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingdevelopment-processRelated to development process of DataFusion

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions