[CI] EsqlClientYamlIT test {p0=esql/46_downsample/Sort from multiple indices one with aggregate metric double} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #11544 / openjdk21_9.1.9_java-fips-matrix-bwc
• elasticsearch-periodic #11544 / openjdk21_9.1.9_java-matrix-bwc
• elasticsearch-periodic #11544 / openjdk25_9.1.9_java-matrix-bwc
• elasticsearch-intake #32049 / 9.1.9_bwc-snapshots
• elasticsearch-periodic #11544 / 8.19.9_bwc
• elasticsearch-periodic #11544 / 9.1.9_bwc
• elasticsearch-intake #32049 / 8.19.9_bwc-snapshots
• elasticsearch-pull-request #108067 / 9.1.9_part_3_bwc-snapshots
• elasticsearch-pull-request #108067 / 8.19.9_part_3_bwc-snapshots

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v9.1.9#yamlRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.EsqlClientYamlIT" -Dtests.method="test {p0=esql/46_downsample/Sort from multiple indices one with aggregate metric double}" -Dtests.seed=50996038D7A1AB7C -Dtests.bwc=true -Dtests.locale=mgo -Dtests.timezone=America/Atikokan -Druntime.java=21 -Dtests.fips.enabled=true

Applicable branches:
9.2

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Failure at [esql/46_downsample:679]: 
Expected: "aggregate_metric_double"
     but: was "unsupported"

Issue Reasons:

• [9.2] 9 failures in test test {p0=esql/46_downsample/Sort from multiple indices one with aggregate metric double} (28.1% fail rate in 32 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 9.2

Mute Reasons:

• [9.2] 3 failures in test test {p0=esql/46_downsample/Sort from multiple indices one with aggregate metric double} (10.3% fail rate in 29 executions)

Build Scans:

• elasticsearch-periodic #11544 / 9.1.9_bwc
• elasticsearch-pull-request #108067 / 9.1.9_part_3_bwc-snapshots
• elasticsearch-pull-request #108067 / 8.19.9_part_3_bwc-snapshots

[elasticsearchmachine]

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

[elasticsearchmachine]

Pinging @elastic/es-storage-engine (Team:StorageEngine)

[luigidellaquila]

At a first look it seems like a BWC problem.
I'm labeling this as low-prio

[craigtaverner]

These failures might be related to the PR I merged last week. A backport to 9.2 of an enhancement to the way we use transport version for unsupported and partially supported DataTypes. This should work for 9.2, but perhaps there is something missing for aggregate_metric_double. See #139098