[CI] LogicalPlanOptimizerTests testNestedExpressionsInGroupsWithCategorize failing

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.LogicalPlanOptimizerTests.testNestedExpressionsInGroupsWithCategorize" -Dtests.seed=8E771D3CDC413052 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=asa -Dtests.timezone=SystemV/PST8PDT -Druntime.java=23

Applicable branches: main

Reproduces locally?: N/A

Failure History: See dashboard&_a=(controlGroupState:(initialChildControlState:('0c0c9cb8-ccd2-45c6-9b13-96bac4abc542':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:task.keyword,order:0,selectedOptions:!(),title:'GradleTask',type:optionsListControl),'4e6ad9d6-6fdc-4fcc-bf1a-aa6ca79e0850':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:className.keyword,order:1,selectedOptions:!(org.elasticsearch.xpack.esql.optimizer.LogicalPlanOptimizerTests),title:'Suite',type:optionsListControl),'144933da-5c1b-4257-a969-7f43455a7901':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:name.keyword,order:2,selectedOptions:!(testNestedExpressionsInGroupsWithCategorize),title:'Test',type:optionsListControl)))))

Failure Message:

org.elasticsearch.xpack.esql.VerificationException: Found 1 problem
line 2:30: Unknown function [CATEGORIZE]

Issue Reasons:

[main] 2 consecutive failures in step release-tests
[main] 2 failures in test testNestedExpressionsInGroupsWithCategorize (2.7% fail rate in 75 executions)
[main] 2 failures in step release-tests (100.0% fail rate in 2 executions)
[main] 2 failures in pipeline elasticsearch-periodic (100.0% fail rate in 2 executions)

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

elastic / elasticsearch

[CI] LogicalPlanOptimizerTests testNestedExpressionsInGroupsWithCategorize failing #117676