[CI] StatementParserTests testInvalidFromPatterns failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #9093 / release-tests
• elasticsearch-periodic #9086 / release-tests
• elasticsearch-periodic #9079 / release-tests
• elasticsearch-periodic #9070 / release-tests
• elasticsearch-periodic #9063 / release-tests
• elasticsearch-periodic #9056 / release-tests
• elasticsearch-periodic #9049 / release-tests
• elasticsearch-periodic #9042 / release-tests
• elasticsearch-periodic #9035 / release-tests
• elasticsearch-periodic #9028 / release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.parser.StatementParserTests.testInvalidFromPatterns" -Dtests.seed=1D4E4B1C783C3F87 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=ff-Adlm-GH -Dtests.timezone=Europe/Luxembourg -Druntime.java=24

Applicable branches:
9.1

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Query [TS " "] is expected to throw class org.elasticsearch.xpack.esql.parser.ParsingException with message [Blank index specified in index pattern]
Expected: a string containing "Blank index specified in index pattern"
     but: was "line 1:1: mismatched input 'TS' expecting {, 'row', 'from', 'show'}"

Issue Reasons:

• [9.1] 16 consecutive failures in step release-tests
• [9.1] 16 failures in test testInvalidFromPatterns (3.3% fail rate in 480 executions)
• [9.1] 16 failures in step release-tests (100.0% fail rate in 16 executions)
• [9.1] 16 failures in pipeline elasticsearch-periodic (94.1% fail rate in 17 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)

[fang-xing-esql]

Backport this PR to 9.1 should be able to fix this issue. 8.19 needs a similar fix.

[fang-xing-esql]

Fixed by #130458.