Build Scans:

• elasticsearch-periodic #11577 / release-tests
• elasticsearch-periodic #11577 / release-tests
• elasticsearch-periodic-java-ea #112 / release-tests
• elasticsearch-pull-request #109767 / checkpart3_release-tests
• elasticsearch-pull-request #109751 / checkpart3_release-tests
• elasticsearch-pull-request #109674 / checkpart3_release-tests
• elasticsearch-pull-request #109641 / checkpart3_release-tests
• elasticsearch-pull-request #109613 / checkpart3_release-tests
• elasticsearch-periodic #11573 / release-tests
• elasticsearch-pull-request #109561 / checkpart3_release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.LocalLogicalPlanOptimizerTests.testReductionPlanForTopNWithPushedDownFunctionsInOrder" -Dtests.seed=D7B618077402F208 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=as -Dtests.timezone=America/Indiana/Winamac -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(text)> is a org.elasticsearch.xpack.esql.expression.function.scalar.string.Length

Issue Reasons:

• [main] 4 consecutive failures in step release-tests
• [main] 2 consecutive failures in step checkpart3_release-tests
• [main] 10 failures in test testReductionPlanForTopNWithPushedDownFunctions (5.0% fail rate in 202 executions)
• [main] 4 failures in step release-tests (100.0% fail rate in 4 executions)
• [main] 6 failures in step checkpart3_release-tests (75.0% fail rate in 8 executions)
• [main] 2 failures in pipeline elasticsearch-periodic (100.0% fail rate in 2 executions)
• [main] 6 failures in pipeline elasticsearch-pull-request (5.5% fail rate in 109 executions)

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