[CI] IndexResolverFieldNamesTests testForkWithStatsInAllBranches failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #23106 / part3
• elasticsearch-intake #23105 / part3
• elasticsearch-pull-request #71944 / part-3
• elasticsearch-intake #23103 / part3
• elasticsearch-intake #23102 / part3
• elasticsearch-pull-request #71939 / part-3
• elasticsearch-pull-request #71939 / part-3-fips

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.session.IndexResolverFieldNamesTests.testForkWithStatsInAllBranches" -Dtests.seed=1BFE0190BD05CAEE -Dtests.locale=kln-Latn-KE -Dtests.timezone=America/Shiprock -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: <[a.*, b.*, c.*, a, b, c, z.*, z]>
     but: was <[c, a, z, z.*, a.*, c.*]>

Issue Reasons:

• [main] 7 consecutive failures in test testForkWithStatsInAllBranches
• [main] 4 consecutive failures in step part3
• [main] 2 consecutive failures in step part-3
• [main] 4 consecutive failures in pipeline elasticsearch-intake
• [main] 2 consecutive failures in pipeline elasticsearch-pull-request
• [main] 7 failures in test testForkWithStatsInAllBranches (70.0% fail rate in 10 executions)
• [main] 4 failures in step part3 (100.0% fail rate in 4 executions)
• [main] 2 failures in step part-3 (40.0% fail rate in 5 executions)
• [main] 4 failures in pipeline elasticsearch-intake (100.0% fail rate in 4 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (50.0% fail rate in 4 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] 3 consecutive failures in test testForkWithStatsInAllBranches
• [main] 3 failures in test testForkWithStatsInAllBranches (50.0% fail rate in 6 executions)

Build Scans:

• elasticsearch-intake #23102 / part3
• elasticsearch-pull-request #71939 / part-3
• elasticsearch-pull-request #71939 / part-3-fips

[elasticsearchmachine]

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

[ioanatia]

this indeed fails when I run it - same as #128271

I think what happened is we merged some changes for fieldNames in the same day and I did not pull latest main before merging #128193
so we actually have a bug now with field resolution for FORK which I will fix soon