[CI] DateDiffTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #11483 / oraclelinux-8_platform-support-unix
• elasticsearch-periodic-platform-support #11479 / windows-2022_checkpart3_platform-support-windows
• elasticsearch-pull-request #106745 / part-3
• elasticsearch-periodic-platform-support #11475 / rocky-9_platform-support-unix
• elasticsearch-pull-request #106616 / part-3
• elasticsearch-pull-request #106616 / part-3
• elasticsearch-pull-request #106600 / part-3
• elasticsearch-pull-request #106555 / part-3
• elasticsearch-intake #31705 / part3
• elasticsearch-pull-request #106491 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.expression.function.scalar.date.DateDiffTests.testSerializationOfSimple {TestCase=DateDiff(ms<TEXT>, null, 2023-12-04T10:15:00Z<NANOS>, 2023-12-04T10:15:01Z<NANOS>) == 1000 null in 1}" -Dtests.seed=276D587705B6561 -Dtests.locale=en-BI -Dtests.timezone=Australia/Melbourne -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.xpack.esql.core.QlIllegalArgumentException: location [@1:1] and length [6] overrun query size [4]

Issue Reasons:

• [main] 75 failures in class org.elasticsearch.xpack.esql.expression.function.scalar.date.DateDiffTests (10.8% fail rate in 697 executions)
• [main] 2 failures in step oraclelinux-8_platform-support-unix (28.6% fail rate in 7 executions)
• [main] 2 failures in step openjdk21_checkpart3_java-fips-matrix (28.6% fail rate in 7 executions)
• [main] 2 failures in step openjdk21_checkpart3_java-matrix (28.6% fail rate in 7 executions)
• [main] 47 failures in step part-3 (11.3% fail rate in 417 executions)
• [main] 2 failures in step release-tests (40.0% fail rate in 5 executions)
• [main] 13 failures in step part3 (15.9% fail rate in 82 executions)
• [main] 4 failures in pipeline elasticsearch-periodic-platform-support (57.1% fail rate in 7 executions)
• [main] 3 failures in pipeline elasticsearch-periodic (37.5% fail rate in 8 executions)
• [main] 41 failures in pipeline elasticsearch-pull-request (10.1% fail rate in 404 executions)
• [main] 13 failures in pipeline elasticsearch-intake (15.9% fail rate in 82 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)