[CI] EsqlClientYamlIT test {p0=esql/40_unsupported_types/nested declared inline} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7890 / openjdk23_8.18.1_java-matrix-bwc
• elasticsearch-periodic #7884 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.18.1#yamlRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.EsqlClientYamlIT" -Dtests.method="test {p0=esql/40_unsupported_types/nested declared inline}" -Dtests.seed=B6019A9879DDC0C5 -Dtests.bwc=true -Dtests.locale=ia-Latn-001 -Dtests.timezone=America/Guayaquil -Druntime.java=23

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Failure at [esql/40_unsupported_types:428]: expected [2xx] status code but api [esql.query] returned [400 Bad Request] [{"error":{"root_cause":[{"type":"verification_exception","reason":"Found 1 problem\nline 1:19: Unknown column [find_me]","stack_trace":"org.elasticsearch.xpack.esql.VerificationException: Found 1 problem\nline 1:19: Unknown column [find_me]\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.verify(Analyzer.java:192)\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.analyze(Analyzer.java:186)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.lambda$analyzedPlan$7(EsqlSession.java:313)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.analyzeAndMaybeRetry(EsqlSession.java:519)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.lambda$analyzedPlan$16(EsqlSession.java:358)\n\tat [email protected]/org.elasticsearch.action.ActionListenerImplementations$ResponseWrappingActionListener.onResponse(ActionListene
[truncated]

Issue Reasons:

• [8.19] 2 failures in test test {p0=esql/40_unsupported_types/nested declared inline} (3.7% fail rate in 54 executions)
• [8.19] 2 failures in pipeline elasticsearch-periodic (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]

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

[fang-xing-esql]

This happens intermittently, I couldn't reproduce it on 8.18 with the command in the description.