[CI] FieldExtractorIT testIntFieldWithTextOrKeywordSubfield failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8731 / 8.14.3_bwc
• elasticsearch-periodic #8719 / 8.12.2_bwc
• elasticsearch-periodic #8707 / 8.12.2_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.14.3#javaRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.FieldExtractorIT" -Dtests.method="testIntFieldWithTextOrKeywordSubfield" -Dtests.seed=59753BAE78B01447 -Dtests.bwc=true -Dtests.locale=mg-MG -Dtests.timezone=Africa/Conakry -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected a map containing
columns: a list containing
        0: a map containing
       type: "integer"
       name: "integer_field"
        1: a map containing
       type: "text"
       name: "integer_field.str"
 values: a list containing
        0: a list containing
          0: <-161001172>
          1: expected "-161001172" but was null

Issue Reasons:

• [8.19] 3 failures in test testIntFieldWithTextOrKeywordSubfield (2.1% fail rate in 140 executions)
• [8.19] 2 failures in step 8.12.2_bwc (40.0% fail rate in 5 executions)
• [8.19] 3 failures in pipeline elasticsearch-periodic (60.0% fail rate in 5 executions)

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

[elasticsearchmachine]

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