Andrei Stefan

ESQL: push down "[text_field] is not null"

2

Addresses https://github.com/elastic/elasticsearch/issues/102786. I have noticed an improvement in response times for the following setup: - `nyc_taxis` index with 1mil documents in it. 1 node. 5 shards, no replicas - one...

SQL: "Unexpected end of ZLIB input stream" when reading the rolled over audit file

3

**Build scan**: https://gradle-enterprise.elastic.co/s/ensysdvzylal6 https://gradle-enterprise.elastic.co/s/knviewjp4hvus **Repro line**: `gradlew ':x-pack:plugin:sql:qa:server:security:without-ssl:integTest' --tests "org.elasticsearch.xpack.sql.qa.security.RestSqlSecurityIT.testDescribeSingleFieldGranted" -Dtests.seed=D3D8A09C04D6FEF8 -Dtests.locale=en-AU -Dtests.timezone=Etc/GMT-14 -Druntime.java=11` **Reproduces locally?**: no **Applicable branches**: master **Failure excerpt**: ``` java.io.EOFException: Unexpected end of ZLIB input stream...

ES|QL: support name qualifiers

5

### Description - [ ] revisit https://github.com/elastic/elasticsearch/pull/110581 which removed the original implementation for qualifiers - [ ] implement qualifiers for LOOKUP https://github.com/elastic/elasticsearch/issues/112014 - [ ] investigate and expand the name...

"No such remote cluster" error message for non-CCS URL

2

### Description Index with date math taken from [the documentation](https://www.elastic.co/guide/en/elasticsearch/reference/8.15/api-conventions.html#api-date-math-index-names). The URL below should decode to `POST /localhost:9200/-` (notice the minus sign before the date math index pattern). ``` POST...

ES|QL: Wait a bit before .async-search index shard is available (#115905)

7

(cherry picked from commit 36ed99c6ca5e1381d56d3aecfc9793be0124d318)