Build Scans:

• elasticsearch-intake #32285 / part3
• elasticsearch-intake #32286 / part3
• elasticsearch-pull-request #109581 / part-3
• elasticsearch-pull-request #109576 / part-3
• elasticsearch-pull-request #109576 / part-3-fips
• elasticsearch-pull-request #109574 / part-3
• elasticsearch-intake #32284 / part3
• elasticsearch-intake #32283 / part3
• elasticsearch-intake #32281 / part3
• elasticsearch-pull-request #109494 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.rules.logical.local.ReplaceDateTruncBucketWithRoundToTests.testPushDownFunctionsLookupJoin" -Dtests.seed=B0CAAB99FA88ABA1 -Dtests.locale=ml-IN -Dtests.timezone=America/Argentina/Rio_Gallegos -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Expected: an instance of org.elasticsearch.xpack.esql.core.expression.FieldAttribute
     but: <length(last_name)> is a org.elasticsearch.xpack.esql.expression.function.scalar.string.Length

Issue Reasons:

• [main] 4 consecutive failures in test testPushDownFunctionsLookupJoin
• [main] 5 consecutive failures in step part3
• [main] 2 consecutive failures in step part-3
• [main] 5 consecutive failures in pipeline elasticsearch-intake
• [main] 2 consecutive failures in pipeline elasticsearch-pull-request
• [main] 10 failures in test testPushDownFunctionsLookupJoin (19.2% fail rate in 52 executions)
• [main] 5 failures in step part3 (29.4% fail rate in 17 executions)
• [main] 4 failures in step part-3 (14.8% fail rate in 27 executions)
• [main] 5 failures in pipeline elasticsearch-intake (29.4% fail rate in 17 executions)
• [main] 4 failures in pipeline elasticsearch-pull-request (14.8% fail rate in 27 executions)

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