Skip to content

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

@alamb

Description

@alamb

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions