[CI] IndexResolverFieldNamesTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5432 / release-tests
• elasticsearch-periodic #5427 / release-tests
• elasticsearch-periodic #5422 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.session.IndexResolverFieldNamesTests.testMultiLookupJoinSameIndexKeepBefore" -Dtests.seed=1097DFD0E490B654 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=nl-CW -Dtests.timezone=Brazil/DeNoronha -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.xpack.esql.parser.ParsingException: line 4:3: mismatched input 'LOOKUP' expecting {'dissect', 'drop', 'enrich', 'eval', 'grok', 'keep', 'limit', 'mv_expand', 'rename', 'sort', 'stats', 'where'}

Issue Reasons:

• [8.x] 3 consecutive failures in step release-tests
• [8.x] 3 failures in class org.elasticsearch.xpack.esql.session.IndexResolverFieldNamesTests (1.9% fail rate in 154 executions)
• [8.x] 3 failures in step release-tests (100.0% fail rate in 3 executions)
• [8.x] 3 failures in pipeline elasticsearch-periodic (75.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] 2 consecutive failures in step release-tests
• [main] 2 failures in class org.elasticsearch.xpack.esql.session.IndexResolverFieldNamesTests (0.9% fail rate in 213 executions)
• [main] 2 failures in step release-tests (50.0% fail rate in 4 executions)

Build Scans:

• elasticsearch-periodic #5419 / release-tests
• elasticsearch-pull-request #46876 / release-tests

[elasticsearchmachine]

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