[CI] DateDiffTests class failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #31705 / part3
• elasticsearch-pull-request #106491 / part-3
• elasticsearch-pull-request #106463 / part-3
• elasticsearch-intake #31678 / part3
• elasticsearch-pull-request #106381 / part-3
• elasticsearch-pull-request #106372 / part-3
• elasticsearch-pull-request #106362 / part-3
• elasticsearch-periodic #11507 / release-tests
• elasticsearch-intake #31668 / part3
• elasticsearch-periodic-platform-support #11465 / rhel-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(ns<KEYWORD>, null, 2023-12-04T10:15:00Z<MILLIS>, 2023-12-04T10:15:01Z<MILLIS>) == 1000000000 null in 1}" -Dtests.seed=CB21652477FB9244 -Dtests.locale=gaa -Dtests.timezone=Antarctica/Davis -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] 67 failures in class org.elasticsearch.xpack.esql.expression.function.scalar.date.DateDiffTests (16.6% fail rate in 404 executions)
• [main] 13 failures in step part3 (29.5% fail rate in 44 executions)
• [main] 42 failures in step part-3 (16.0% fail rate in 262 executions)
• [main] 2 failures in step release-tests (66.7% fail rate in 3 executions)
• [main] 2 failures in step openjdk21_checkpart3_java-fips-matrix (66.7% fail rate in 3 executions)
• [main] 2 failures in step openjdk21_checkpart3_java-matrix (66.7% fail rate in 3 executions)
• [main] 13 failures in pipeline elasticsearch-intake (29.5% fail rate in 44 executions)
• [main] 37 failures in pipeline elasticsearch-pull-request (14.8% fail rate in 250 executions)
• [main] 3 failures in pipeline elasticsearch-periodic (75.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)

[elasticsearchmachine]

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

[nik9000]

Hey friendly robot, that test is very sad.

[nik9000]

@ivancea something blew up here. Probably two PRs passing each other.

[ivancea]

Suite timeout. Both DateTrunc and DateDiff have a lot of test cases. I added it for the first, but not for this one. But it seems like we'll need it. Adding it!