[CI] PhysicalPlanOptimizerTests testPushSpatialIntersectsEvalToSource {default} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-intake #11054 / part3
• elasticsearch-intake #11056 / part3
• elasticsearch-pull-request #35896 / part-3
• elasticsearch-pull-request #35894 / part-3
• elasticsearch-pull-request #35890 / part-3
• elasticsearch-pull-request #35886 / part-3
• elasticsearch-pull-request #35887 / part-3
• elasticsearch-intake #11048 / part3
• elasticsearch-pull-request #35883 / part-3
• elasticsearch-pull-request #35875 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.PhysicalPlanOptimizerTests.testPushWhereEvalToSource {default}" -Dtests.seed=F7A13A0A1418C1BE -Dtests.locale=ta-MY -Dtests.timezone=America/Port_of_Spain -Druntime.java=22

Applicable branches: main

Reproduces locally?: N/A

Failure History: See dashboard&_a=(controlGroupInput:(chainingSystem:HIERARCHICAL,controlStyle:twoLine,ignoreParentSettings:(ignoreFilters:!f,ignoreQuery:!f,ignoreTimerange:!f,ignoreValidations:!t),panels:('0c0c9cb8-ccd2-45c6-9b13-96bac4abc542':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:task.keyword,grow:!t,id:'0c0c9cb8-ccd2-45c6-9b13-96bac4abc542',searchTechnique:wildcard,selectedOptions:!(),singleSelect:!t,title:'Gradle%20Task',width:medium),grow:!t,order:0,type:optionsListControl,width:small),'144933da-5c1b-4257-a969-7f43455a7901':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:name.keyword,grow:!t,id:'144933da-5c1b-4257-a969-7f43455a7901',searchTechnique:wildcard,selectedOptions:!('testPushSpatialIntersectsEvalToSource%20%7Bdefault%7D'),title:Test,width:medium),grow:!t,order:2,type:optionsListControl,width:medium),'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850':(explicitInput:(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,enhancements:(),fieldName:className.keyword,grow:!t,id:'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850',searchTechnique:wildcard,selectedOptions:!('org.elasticsearch.xpack.esql.optimizer.PhysicalPlanOptimizerTests'),title:Suite,width:medium),grow:!t,order:1,type:optionsListControl,width:medium)))))

Failure Message:

java.lang.AssertionError: 
Expected: an instance of org.elasticsearch.xpack.esql.plan.physical.LimitExec
     but: <EvalExec[[scalerank{f}#173312 AS rank]]
\_LimitExec[1000[INTEGER]]
  \_ExchangeExec[[],false]
    \_FragmentExec[filter=null, estimatedRowSize=0, reducer=[], fragment=[<>
Limit[1000[INTEGER]]
\_Filter[scalerank{f}#173312 < 4[INTEGER]]
  \_EsRelation[airports][abbrev{f}#173310, city{f}#173316, city_location{f}#..]<>]]> is a org.elasticsearch.xpack.esql.plan.physical.EvalExec

Issue Reasons:

• [main] 2 consecutive failures in test testPushSpatialIntersectsEvalToSource {default}
• [main] 4 consecutive failures in step part3
• [main] 4 consecutive failures in pipeline elasticsearch-intake
• [main] 19 failures in test testPushSpatialIntersectsEvalToSource {default} (63.3% fail rate in 30 executions)
• [main] 4 failures in step part3 (50.0% fail rate in 8 executions)
• [main] 15 failures in step part-3 (68.2% fail rate in 22 executions)
• [main] 4 failures in pipeline elasticsearch-intake (50.0% fail rate in 8 executions)
• [main] 14 failures in pipeline elasticsearch-pull-request (66.7% fail rate in 21 executions)

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

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 14 consecutive failures in test testPushSpatialIntersectsEvalToSource {default}
• [main] 13 consecutive failures in step part-3
• [main] 2 consecutive failures in step part3
• [main] 13 consecutive failures in pipeline elasticsearch-pull-request
• [main] 2 consecutive failures in pipeline elasticsearch-intake
• [main] 16 failures in test testPushSpatialIntersectsEvalToSource {default} (61.5% fail rate in 26 executions)
• [main] 14 failures in step part-3 (70.0% fail rate in 20 executions)
• [main] 2 failures in step part3 (33.3% fail rate in 6 executions)
• [main] 13 failures in pipeline elasticsearch-pull-request (68.4% fail rate in 19 executions)
• [main] 2 failures in pipeline elasticsearch-intake (33.3% fail rate in 6 executions)

Build Scans:

• elasticsearch-pull-request #35894 / part-3
• elasticsearch-pull-request #35890 / part-3
• elasticsearch-pull-request #35886 / part-3
• elasticsearch-pull-request #35887 / part-3
• elasticsearch-intake #11048 / part3
• elasticsearch-pull-request #35883 / part-3
• elasticsearch-pull-request #35875 / part-3
• elasticsearch-pull-request #35880 / part-3
• elasticsearch-pull-request #35876 / part-3
• elasticsearch-pull-request #35872 / part-3

[elasticsearchmachine]

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