[CI] LogicalPlanOptimizerTests testMatchFunctionIsNotNullable failing

Build Scans:

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.LogicalPlanOptimizerTests.testMatchWithNonIndexedColumnCurrentlyUnsupported" -Dtests.seed=DC5441D824CCF48 -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=ff-Adlm-SN -Dtests.timezone=Africa/Bissau -Druntime.java=23

Applicable branches: 8.16

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:!(testMatchFunctionIsNotNullable),title:'Test',type:optionsListControl)))))

Failure Message:

org.junit.ComparisonFailure: expected:<1:6[7: [MATCH] cannot operate on [initial], which is not a field from an index mapping]> but was:<1:6[1: Unknown function [match], did you mean [cidr_match]?]>

Issue Reasons:

[8.16] 6 consecutive failures in step release-tests
[8.16] 6 failures in test testMatchFunctionIsNotNullable (2.4% fail rate in 250 executions)
[8.16] 6 failures in step release-tests (100.0% fail rate in 6 executions)
[8.16] 6 failures in pipeline elasticsearch-periodic (85.7% fail rate in 7 executions)

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

elastic / elasticsearch

[CI] LogicalPlanOptimizerTests testMatchFunctionIsNotNullable failing #115704