Build Scans:

• elasticsearch-periodic #5975 / 8.15.5_bwc
• elasticsearch-periodic #5975 / 8.14.3_bwc
• elasticsearch-periodic #5970 / 8.15.5_bwc
• elasticsearch-periodic #5875 / 8.13.4_bwc
• elasticsearch-pull-request #50850 / 8.13.4_bwc
• elasticsearch-pull-request #50850 / 8.11.4_bwc
• elasticsearch-pull-request #50850 / 8.12.2_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.15.5#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {date.Implicit casting strings to dates for IN operator SYNC}" -Dtests.seed=DF3CECBC02B23A2A -Dtests.bwc=true -Dtests.locale=ceb -Dtests.timezone=Asia/Qyzylorda -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] 2 consecutive failures in test test {date.IN operator with null in list, finds match SYNC}
• [8.x] 2 consecutive failures in step 8.15.5_bwc
• [8.x] 2 consecutive failures in step 8.13.4_bwc
• [8.x] 7 failures in test test {date.IN operator with null in list, finds match SYNC} (6.5% fail rate in 108 executions)
• [8.x] 2 failures in step 8.15.5_bwc (50.0% fail rate in 4 executions)
• [8.x] 2 failures in step 8.13.4_bwc (100.0% fail rate in 2 executions)
• [8.x] 3 failures in pipeline elasticsearch-periodic (100.0% fail rate in 3 executions)

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