[CI] MultiClusterSpecIT test {date.IN operator with null in list, doesn't find match, EVAL to check value} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #5915 / 8.13.4_bwc
• elasticsearch-periodic #5910 / 8.13.4_bwc
• elasticsearch-periodic #5905 / 8.13.4_bwc
• elasticsearch-periodic #5900 / 8.13.4_bwc
• elasticsearch-periodic #5895 / 8.13.4_bwc
• elasticsearch-periodic #5890 / 8.13.4_bwc
• elasticsearch-periodic #5885 / 8.13.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v8.13.4#oldToNew" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {date.IN operator with null in list, doesn't find match}" -Dtests.seed=3005B39B4FBFD890 -Dtests.bwc=true -Dtests.locale=mgh-MZ -Dtests.timezone=Asia/Hebron -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected an empty list
0: <unexpected> but was "Line 3:24: evaluation of [TO_DATETIME(\\\"1900-02-19T00:00:00Z\\\")] failed, treating result as null. Only first 20 failures recorded."
1: <unexpected> but was "Line 3:24: java.lang.IllegalArgumentException: failed to parse date field [1900-02-19T00:00:00Z] with format [yyyy-MM-dd'T'HH:mm:ss.SSS'Z']"

Issue Reasons:

• [8.x] 7 failures in test test {date.IN operator with null in list, doesn't find match, EVAL to check value} (0.7% fail rate in 956 executions)
• [8.x] 7 failures in step 8.13.4_bwc (100.0% fail rate in 7 executions)
• [8.x] 7 failures in pipeline elasticsearch-periodic (100.0% fail rate in 7 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)