Skip to content

Conversation

@alamb
Copy link
Contributor

@alamb alamb commented Jun 4, 2025

Which issue does this PR close?

Rationale for this change

Let's have sqllogictest pass locally without having to set RUST_BACKTRACE

Note I didn't actually find / fix the actual underlying problem...

What changes are included in this PR?

  1. Update test to look for the error message rather than the entire thing

Are these changes tested?

yes, by CI and I ran it locally as well

Are there any user-facing changes?

No

This is only a test change

@github-actions github-actions bot added the sqllogictest SQL Logic Tests (.slt) label Jun 4, 2025
@alamb alamb marked this pull request as ready for review June 4, 2025 16:27
@alamb alamb added the development-process Related to development process of DataFusion label Jun 4, 2025
Copy link
Contributor

@zhuqi-lucas zhuqi-lucas left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM Thank you @alamb .

I am confused why CI will not fail for this case, i remember some cases i run locally to -- --complete, but the CI failed, so i add RUST_BACKTRACE to generate.

Copy link
Contributor

@2010YOUY01 2010YOUY01 left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thank you for the fix!

@2010YOUY01 2010YOUY01 merged commit 448c985 into apache:main Jun 5, 2025
28 checks passed
@alamb
Copy link
Contributor Author

alamb commented Jun 5, 2025

I am confused why CI will not fail for this case, i remember some cases i run locally to -- --complete, but the CI failed, so i add RUST_BACKTRACE to generate.

I think sqllogictest checks for substring match but --complete puts the entire string

So something about the entire string is different in CI but the substring does work

@zhuqi-lucas
Copy link
Contributor

Thank you @alamb , is it possible for --complete also generate substring which matches in CI?

@alamb
Copy link
Contributor Author

alamb commented Jun 5, 2025

Thank you @alamb , is it possible for --complete also generate substring which matches in CI?

Yes, the question is what is the most important substring 🤔

Maybe just the first line would be enough

@alamb alamb deleted the alamb/fix_slt branch June 5, 2025 20:51
kosiew pushed a commit to kosiew/datafusion that referenced this pull request Jun 6, 2025
@zhuqi-lucas
Copy link
Contributor

Thank you @alamb , is it possible for --complete also generate substring which matches in CI?

Yes, the question is what is the most important substring 🤔

Maybe just the first line would be enough

Yeah @alamb , this is a good idea, maybe can can start from the first line.

@zhuqi-lucas
Copy link
Contributor

Created a issue for this:
#16284

kosiew pushed a commit to kosiew/datafusion that referenced this pull request Jun 9, 2025
blaginin added a commit that referenced this pull request Jun 9, 2025
… in values array (#16258)

* Add tests

* trigger ci

* Update tpch, clickbench, sort_tpch to mark failed queries (#16182)

* Move struct QueryResult to util/run.rs

* Modify benches to continue query execution even on failure

* Mark benchmark query success on output json

* Adjust slttest to pass without RUST_BACKTRACE enabled (#16251)

* add more tests where the dict keys are not null but dict values are null

* Revert "add more tests where the dict keys are not null but dict values are null"

This reverts commit c745dae.

* Add tests for count and count_distinct with dictionary arrays containing null values

* resolve merge conflict, reorder imports

* Add helper function to create dictionary array with non-null keys and null values

* Add test for count_distinct accumulator with dictionary array containing all null values

* add tests to aggregate.rs

* remove redundant comments in get_formatted_results function

* remove redundant safety checks in count distinct dictionary test

* refactor: introduce helper function for output assertion

* test: add count distinct dictionary handling for null values

* refactor: streamline imports and improve code organization in count.rs

* fix: add missing import for batches_to_string in aggregates.rs

* test: reorganize tests

* refactor: simplify COUNT(DISTINCT) tests and remove unused helper functions

* refactor: trim redundant tests

---------

Co-authored-by: ding-young <lsyhime@snu.ac.kr>
Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
Co-authored-by: Dmitrii Blaginin <dmitrii@blaginin.me>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

development-process Related to development process of DataFusion sqllogictest SQL Logic Tests (.slt)

Projects

None yet

Development

Successfully merging this pull request may close these issues.

sqllogictest tests fail when run locally

3 participants