Build Scans:

• elasticsearch-periodic #3450 / 8.11.4_bwc
• elasticsearch-periodic #3446 / 8.11.4_bwc
• elasticsearch-periodic #3442 / 8.11.4_bwc
• elasticsearch-pull-request #25954 / 8.11.4_bwc
• elasticsearch-periodic #3438 / 8.11.4_bwc
• elasticsearch-periodic #3430 / 8.11.4_bwc
• elasticsearch-periodic #3429 / 8.11.4_bwc
• elasticsearch-periodic #3425 / 8.11.4_bwc
• elasticsearch-periodic #3397 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {keep.ShadowingInternalWildcardAndExplicit SYNC}" -Dtests.seed=D7ACD760C5230FD4 -Dtests.bwc=true -Dtests.locale=is-IS -Dtests.timezone=Europe/Zurich -Druntime.java=22

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Different number of columns returned; expected [emp_no, first_name, languages, last_name, gender] but actual was [last_name, emp_no, last_name, first_name, last_name, languages, last_name, gender, last_name]
Expected: a collection with size <5>
     but: collection size was <9>

Issue Reasons:

• [main] 5 consecutive failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT
• [main] 5 consecutive failures in step 8.11.4_bwc
• [main] 4 consecutive failures in pipeline elasticsearch-periodic
• [main] 9 failures in class org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT (56.3% fail rate in 16 executions)
• [main] 9 failures in step 8.11.4_bwc (56.3% fail rate in 16 executions)
• [main] 8 failures in pipeline elasticsearch-periodic (53.3% fail rate in 15 executions)

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