[CI] MatchFunctionIT testMatchWithLookupJoinOnMatch failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #30521 / part3
• elasticsearch-pull-request #100743 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:internalClusterTest" --tests "org.elasticsearch.xpack.esql.plugin.MatchFunctionIT.testMatchWithLookupJoinOnMatch" -Dtests.seed=48C6AEDAE8B8A530 -Dtests.locale=ksb -Dtests.timezone=Europe/Sarajevo -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: <[[This is a brown fox, 1, 1, This is a brown fox], [The quick brown fox jumps over the lazy dog, 6, 6, The quick brown fox jumps over the lazy dog]]>
     but: was <[[The quick brown fox jumps over the lazy dog, 6, 6, The quick brown fox jumps over the lazy dog], [This is a brown fox, 1, 1, This is a brown fox]]>

Issue Reasons:

• [main] 2 failures in test testMatchWithLookupJoinOnMatch (1.5% fail rate in 135 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 2 failures in test testMatchWithLookupJoinOnMatch (1.5% fail rate in 135 executions)

Build Scans:

• elasticsearch-intake #30521 / part3
• elasticsearch-pull-request #100743 / part-3

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)

[alex-spies]

Looks like non-deterministic order of the rows. @julian-elastic , could you please have a look?