[CI] VerifierTests testFullTextFunctionsOnlyAllowedInWhere failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #9384 / release-tests
• elasticsearch-pull-request #81067 / checkpart3_release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.analysis.VerifierTests.testFullTextFunctionsOnlyAllowedInWhere" -Dtests.seed=6D52917543CFDE20 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=os-Cyrl-GE -Dtests.timezone=Asia/Macau -Druntime.java=24

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: a string containing "[MATCH] function is only supported in WHERE and STATS commands, or in EVAL within score(.) function"
     but: was "1:22: [MATCH] function is only supported in WHERE and STATS commands"

Issue Reasons:

• [main] 2 failures in test testFullTextFunctionsOnlyAllowedInWhere (0.8% fail rate in 245 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 failures in test testFullTextFunctionsOnlyAllowedInWhere (0.8% fail rate in 245 executions)

Build Scans:

• elasticsearch-periodic #9384 / release-tests
• elasticsearch-pull-request #81067 / checkpart3_release-tests

[elasticsearchmachine]

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

[astefan]

@tteofili this seems related to your PR. This happens in release tests.

[tteofili]

@astefan thanks, I'm having a look