Build Scans:

• elasticsearch-periodic #5970 / 8.14.3_bwc
• elasticsearch-periodic #5875 / 8.14.3_bwc
• elasticsearch-periodic #5875 / 8.15.5_bwc
• elasticsearch-periodic #5875 / 8.13.4_bwc
• elasticsearch-pull-request #50850 / 8.14.3_bwc
• elasticsearch-pull-request #50850 / 8.13.4_bwc
• elasticsearch-pull-request #50850 / 8.15.5_bwc
• elasticsearch-periodic #5870 / 8.15.5_bwc
• elasticsearch-periodic #5870 / 8.13.4_bwc
• elasticsearch-periodic #5870 / 8.14.3_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-clusters:v8.14.3#newToOld" -Dtests.class="org.elasticsearch.xpack.esql.ccq.MultiClusterSpecIT" -Dtests.method="test {date.Implicit casting strings to dates for IN operator}" -Dtests.seed=FF019A261106D068 -Dtests.bwc=true -Dtests.locale=en-MG -Dtests.timezone=America/Argentina/Catamarca -Druntime.java=23

Applicable branches:
8.x

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected more data but no more entries found after [0]
Data mismatch:

Actual:
emp_no:integer | first_name:keyword

Expected:
emp_no:integer | first_name:keyword
10006          | Anneke            
10025          | Prasadram         

Issue Reasons:

• [8.x] 5 consecutive failures in step 8.14.3_bwc
• [8.x] 4 consecutive failures in step 8.15.5_bwc
• [8.x] 4 consecutive failures in step 8.13.4_bwc
• [8.x] 13 failures in test test {date.Implicit casting strings to dates for IN operator} (2.5% fail rate in 519 executions)
• [8.x] 5 failures in step 8.14.3_bwc (100.0% fail rate in 5 executions)
• [8.x] 4 failures in step 8.15.5_bwc (100.0% fail rate in 4 executions)
• [8.x] 4 failures in step 8.13.4_bwc (100.0% fail rate in 4 executions)
• [8.x] 4 failures in pipeline elasticsearch-periodic (100.0% fail rate in 4 executions)

Note:
This issue was created using new test triage automation. Please report issues or feedback to es-delivery.