[CI] MixedClusterEsqlSpecIT test {union_types.MultiIndexSortIpStringEval ASYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #7922 / openjdk23_8.19.0_java-matrix-bwc
• elasticsearch-pull-request #69454 / 8.19.0_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.19.0#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.MixedClusterEsqlSpecIT" -Dtests.method="test {union_types.MultiIndexSortIpStringEval ASYNC}" -Dtests.seed=C7CEC9DEFEB0EEC1 -Dtests.bwc=true -Dtests.locale=mt-MT -Dtests.timezone=Israel -Druntime.java=23

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: expected:<[{name=@timestamp, type=date}, {name=client_ip, type=unsupported, original_types=[ip, keyword], suggested_cast=keyword}, {name=event_duration, type=long}, {name=message, type=keyword}, {name=client_ip_as_ip, type=ip}]> but was:<[{name=@timestamp, type=date}, {name=client_ip, type=unsupported}, {name=event_duration, type=long}, {name=message, type=keyword}, {name=client_ip_as_ip, type=ip}]>

Issue Reasons:

• [main] 2 failures in test test {union_types.MultiIndexSortIpStringEval ASYNC} (0.7% fail rate in 306 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] 2 failures in test test {union_types.MultiIndexSortIpStringEval ASYNC} (0.7% fail rate in 306 executions)

Build Scans:

• elasticsearch-periodic #7922 / openjdk23_8.19.0_java-matrix-bwc
• elasticsearch-pull-request #69454 / 8.19.0_bwc-snapshots

[elasticsearchmachine]

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

[alex-spies]

The query result JSON is somehow missing the suggested cast (from #127139) in the 8.19 bwc tests; maybe we need to update the test assertion to not expect the suggested cast when the capability for it is missing.

@limotova , do you think you could take a look at this one?