[CI] MixedClusterClientYamlTestSuiteIT test {p0=search/400_columnar_default_field/query_string is lenient about unparseable literals in columnar mode} failing

**Build Scans:**
- [elasticsearch-intake #48068 / 9.5.4_bwc-snapshots](https://gradle-enterprise.elastic.co/s/lffmwp3hy2ipw)
- [elasticsearch-intake #48068 / 9.5.4_bwc-snapshots](https://gradle-enterprise.elastic.co/s/5e2eimbqw7n5g)
- [elasticsearch-intake #48069 / 9.5.4_bwc-snapshots](https://gradle-enterprise.elastic.co/s/poyaqr2kkjgmu)
- [elasticsearch-intake #48057 / 9.5.4_bwc-snapshots](https://gradle-enterprise.elastic.co/s/aj4iswqpfrblw)
- [elasticsearch-intake #48059 / 9.5.4_bwc-snapshots](https://gradle-enterprise.elastic.co/s/6553dhn4et3du)
- [elasticsearch-intake #48057 / 9.5.4_bwc-snapshots](https://gradle-enterprise.elastic.co/s/elr23s4pa5nww)
- [elasticsearch-pull-request #180649 / 9.5.4_part_6_bwc-snapshots](https://gradle-enterprise.elastic.co/s/ak2nxww26ks3s)
- [elasticsearch-pull-request #180643 / 9.5.4_part_6_bwc-snapshots](https://gradle-enterprise.elastic.co/s/xgtrhnv3xtzsu)
- [elasticsearch-pull-request #180642 / 9.5.4_part_6_bwc-snapshots](https://gradle-enterprise.elastic.co/s/2vamczlfwshme)
- [elasticsearch-pull-request #180643 / 9.5.4_part_6_bwc-snapshots](https://gradle-enterprise.elastic.co/s/lbuz5dad2aw4s)

**Reproduction Line:**
```
./gradlew ":qa:mixed-cluster:v9.5.4#yamlRestTest" -Dtests.class="org.elasticsearch.backwards.MixedClusterClientYamlTestSuiteIT" -Dtests.method="test {p0=search/400_columnar_default_field/field-less query over a numeric and a keyword field in columnar mode}" -Dtests.seed=2BB0A64634AAAFD4 -Dtests.bwc=true -Dtests.locale=es-BR -Dtests.timezone=Etc/GMT+2 -Druntime.java=26
```

**Applicable branches:**
main

**Reproduces locally?:**
N/A

**Failure History:**
[See dashboard](https://es-delivery-stats.elastic.dev/app/dashboards#/view/dcec9e60-72ac-11ee-8f39-55975ded9e63?_g=(refreshInterval:(pause:!t,value:60000),time:(from:now-7d%2Fd,to:now))&_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.backwards.MixedClusterClientYamlTestSuiteIT),title:'Suite',type:optionsListControl),'144933da-5c1b-4257-a969-7f43455a7901':(dataViewId:fbbdc689-be23-4b3d-8057-aa402e9ed0c5,fieldName:name.keyword,order:2,selectedOptions:!('test%20%7Bp0%3Dsearch%2F400_columnar_default_field%2Fquery_string%20is%20lenient%20about%20unparseable%20literals%20in%20columnar%20mode%7D'),title:'Test',type:optionsListControl)))))

**Failure Message:**
```
java.lang.AssertionError: org.junit.internal.runners.model.MultipleFailureException: There were 7 errors:
java.lang.AssertionError(expected [2xx] status code but api [search] returned [400 Bad Request] [{"error":{"root_cause":[{"type":"query_shard_exception","reason":"failed to create query: For input string: \"hello\"","index_uuid":"vWYP4YsWRqayDhyw_AK0sg","index":"mixed","stack_trace":"[mixed/vWYP4YsWRqayDhyw_AK0sg] org.elasticsearch.index.query.QueryShardException: failed to create query: For input string: \"hello\"\n\tat org.elasticsearch.index.query.SearchExecutionContext.toQuery(SearchExecutionContext.java:614)\n\tat org.elasticsearch.search.SearchService.parseSource(SearchService.java:2127)\n\tat org.elasticsearch.search.SearchService.createContext(SearchService.java:1815)\n\tat org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:1036)\n\tat org.elasticsearch.search.SearchService.lambda$executeQueryPhaseAsync$12(SearchService.java:878)\n\tat org.elastic
[truncated]
```

**Issue Reasons:**
- [main] 3 consecutive failures in test test {p0=search/400_columnar_default_field/query_string is lenient about unparseable literals in columnar mode}
- [main] 3 consecutive failures in step 9.5.4_bwc-snapshots
- [main] 2 consecutive failures in pipeline elasticsearch-intake
- [main] 12 failures in test test {p0=search/400_columnar_default_field/query_string is lenient about unparseable literals in columnar mode} (48.0% fail rate in 25 executions)
- [main] 6 failures in step 9.5.4_bwc-snapshots (60.0% fail rate in 10 executions)
- [main] 6 failures in step 9.5.4_part_6_bwc-snapshots (42.9% fail rate in 14 executions)
- [main] 4 failures in pipeline elasticsearch-intake (57.1% fail rate in 7 executions)
- [main] 4 failures in pipeline elasticsearch-pull-request (40.0% fail rate in 10 executions)

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