[CI] MixedClusterEsqlSpecIT test {date.Convert no zone SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7896 / 8.11.4_bwc
• elasticsearch-periodic #7890 / 8.11.4_bwc
• elasticsearch-periodic #7890 / 8.13.4_bwc
• elasticsearch-periodic #7890 / 8.12.2_bwc
• elasticsearch-periodic #7884 / 8.13.4_bwc
• elasticsearch-periodic #7878 / 8.11.4_bwc
• elasticsearch-periodic #7878 / 8.12.2_bwc
• elasticsearch-periodic #7866 / 8.12.2_bwc
• elasticsearch-periodic #7860 / 8.12.2_bwc
• elasticsearch-periodic #7860 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.11.4#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {date.Convert no zone SYNC}" -Dtests.seed=2F5E2B524F59421C -Dtests.bwc=true -Dtests.locale=ee-GH -Dtests.timezone=US/Central -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected an empty list
0: <unexpected> but was "Line 2:13: evaluation of [TO_DATETIME(str)] failed, treating result as null. Only first 20 failures recorded."
1: <unexpected> but was "Line 2:13: java.lang.IllegalArgumentException: failed to parse date field [2025-04-11T05:00:00.000] with format [yyyy-MM-dd'T'HH:mm:ss.SSS'Z']"

Issue Reasons:

• [8.19] 2 consecutive failures in step 8.11.4_bwc
• [8.19] 2 consecutive failures in step 8.13.4_bwc
• [8.19] 12 failures in test test {date.Convert no zone SYNC} (6.7% fail rate in 180 executions)
• [8.19] 4 failures in step 8.11.4_bwc (44.4% fail rate in 9 executions)
• [8.19] 3 failures in step 8.13.4_bwc (37.5% fail rate in 8 executions)
• [8.19] 5 failures in step 8.12.2_bwc (62.5% fail rate in 8 executions)
• [8.19] 8 failures in pipeline elasticsearch-periodic (88.9% fail rate in 9 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)

[nik9000]

@not-napoleon looks like this wasn't supported before 8.13. Want me to skip them back there?

[astefan]

@not-napoleon these tests are pretty fresh in 8.x. Would you mind having a look at them?

[not-napoleon]

I believe this is fixed by #127453