Skip to content

Intermittent CI failure on at test_files/joins.slt:3676 #10119

New issue

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

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

Already on GitHub? # to your account

Closed
alamb opened this issue Apr 17, 2024 · 0 comments · Fixed by #10120
Closed

Intermittent CI failure on at test_files/joins.slt:3676 #10119

alamb opened this issue Apr 17, 2024 · 0 comments · Fixed by #10120
Labels
bug Something isn't working

Comments

@alamb
Copy link
Contributor

alamb commented Apr 17, 2024

Describe the bug

The sqllogictests appear to be failing intermittently on CI.

External error: query result mismatch:
[SQL] SELECT * FROM (
    SELECT 1 as c, 2 as d
    UNION ALL
    SELECT 1 as c, 3 AS d
) as a FULL JOIN (SELECT 1 as e, 3 AS f) AS rhs ON a.c=rhs.e;
[Diff] (-expected|+actual)
-   1 2 1 3
-   1 3 1 3
+   1 3 1 3
+   1 2 1 3
at test_files/joins.slt:3676

To Reproduce

When CI runs this command cargo test -p datafusion-sqllogictest --test sqllogictests sometimes it fails

Example failure:
https://github.com/apache/arrow-datafusion/actions/runs/8724655620/job/23936183227?pr=10115

Expected behavior

The test should always pass or always fail. Not be intermittent

I think the issue is that the rows show up in a different order

Additional context

No response

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant