[CI] PropagateInlineEvalsTests testGroupingAliasingMoved_To_LeftSideOfJoin failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7054 / release-tests
• elasticsearch-periodic #7047 / release-tests
• elasticsearch-periodic #7040 / release-tests
• elasticsearch-periodic #7033 / release-tests
• elasticsearch-periodic #7026 / release-tests
• elasticsearch-periodic #7019 / release-tests
• elasticsearch-periodic #7012 / release-tests
• elasticsearch-periodic #7005 / release-tests
• elasticsearch-periodic #6998 / release-tests
• elasticsearch-periodic #6991 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.rules.logical.PropagateInlineEvalsTests.testGroupingAliasingMoved_To_LeftSideOfJoin_WithExpression" -Dtests.seed=14E771E79B9E8DFC -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=shi-Latn-MA -Dtests.timezone=Etc/GMT+8 -Druntime.java=24

Applicable branches:
9.0

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

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

Issue Reasons:

• [9.0] 13 consecutive failures in step release-tests
• [9.0] 13 failures in test testGroupingAliasingMoved_To_LeftSideOfJoin (3.2% fail rate in 407 executions)
• [9.0] 13 failures in step release-tests (100.0% fail rate in 13 executions)
• [9.0] 13 failures in pipeline elasticsearch-periodic (100.0% fail rate in 13 executions)

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

[elasticsearchmachine]

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

[alex-spies]

Fixed by #125004