[CI] DateDiffTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #11527 / single-processor-node-tests
• elasticsearch-pull-request #106071 / part-3
• elasticsearch-pull-request #106893 / checkpart3_release-tests
• elasticsearch-pull-request #106892 / part-3
• elasticsearch-pull-request #106870 / part-3
• elasticsearch-pull-request #106847 / part-3
• 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

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.expression.function.scalar.date.DateDiffTests.testSerializationOfSimple {TestCase=DateDiff(ms<KEYWORD>, null, 2023-12-04T10:15:00Z<NANOS>, 2023-12-04T10:15:01Z<MILLIS>) == 1000 null in 0}" -Dtests.seed=A1915651F4FC0AAA -Dtests.configure_test_clusters_with_one_processor=true -Dtests.locale=guz -Dtests.timezone=Australia/Perth -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 [1]

Issue Reasons:

• [main] 81 failures in class org.elasticsearch.xpack.esql.expression.function.scalar.date.DateDiffTests (9.3% fail rate in 873 executions)
• [main] 2 failures in step single-processor-node-tests (22.2% fail rate in 9 executions)
• [main] 51 failures in step part-3 (9.9% fail rate in 513 executions)
• [main] 13 failures in step part3 (12.7% fail rate in 102 executions)
• [main] 2 failures in step openjdk21_checkpart3_java-matrix (25.0% fail rate in 8 executions)
• [main] 2 failures in step openjdk21_checkpart3_java-fips-matrix (25.0% fail rate in 8 executions)
• [main] 2 failures in step release-tests (28.6% fail rate in 7 executions)
• [main] 2 failures in step oraclelinux-8_platform-support-unix (28.6% fail rate in 7 executions)
• [main] 4 failures in pipeline elasticsearch-periodic (44.4% fail rate in 9 executions)
• [main] 45 failures in pipeline elasticsearch-pull-request (9.1% fail rate in 497 executions)
• [main] 4 failures in pipeline elasticsearch-periodic-platform-support (50.0% fail rate in 8 executions)
• [main] 13 failures in pipeline elasticsearch-intake (12.7% fail rate in 102 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)

[julian-elastic]

This seems to be caused by #138316. @ivancea Can you please take a look? If you don't think it is caused by your change, feel free to pass back to me.