ESQL: Major Issues for 8.11

[costin]

Description

A meta ticket tracking the main issues we want to solve for the 8.11:

• Accurate memory tracking ESQL: Add memory accountancy and circuit breaking #99173
• add warning header for default limit - ESQL: add a warning header on default limit application  #100555
• Prevent unsupported data extraction from blowing up ESQL: Replace unsupported data extraction with unsupported field #99506
  • fall back to field loading to keyword, if subfield exists ESQL: Error when loading text fields from indexes with synthetic source #99183
• default limit in Kibana ESQL: Improve default limit #99458
• count(*) / count() + push down filtered count ESQL: support count all / count(*) with push down count when dealing with a filter #99459
• request timeout - Add timeout to ESQL #99526

Bugs:

• EsqlSpecIT test {ints.MultipleWarnings} failing [CI] RestEsqlIT testWarningHeadersOnFailedConversions failing #98719
• mv_expand after sort fails ESQL: mv_expand after sort fails #99971
• RestEsqlIT testTextMode [CI] RestEsqlIT testTextMode failing #100257
• drop date_xxx() warning when arguments are in reverse order ESQL: drop date_xxx() warning when arguments are in reverse order #99562
• Improve parsing of query parameters ESQL: Improve parsing of query parameters #99570
• null layout on ECS schema with WHERE + STATS ESQL: null layout on ECS schema with WHERE + STATS #100807
• missing field in filter QL: IndexResolver issue when dealing with dotted fields #100869
• Relax ValueSources check in OrdinalsGroupingOperator Relax ValueSources check in OrdinalsGroupingOperator #100566
• Improve verifier for incorrect agg declaration ESQL: Improve verifier error for incorrect agg declaration #100650
• Aggregation don't preserve projection ESQL: Preserve the projection of an aggregation #99936
• Grouping on ordinals ignore null group ESQL: grouping by just a keyword ignores null values #100109
• Unhandled error when using multi-value as function argument [ES|QL] Unhandled error when using multi-value as function argument #100497
• org.elasticsearch.xpack.esql.qa.single_node.EsqlSpecIT failing [CI] org.elasticsearch.xpack.esql.qa.single_node.EsqlSpecIT failing #100081
• When double limiting the limit after mv_expand is not applied anymore ESQL: when double limiting the limit after mv_expand is not applied anymore #100774

Nice to have:

Postponed:

• fallback to source extraction for fields that have field data disabled ESQL: fallback to source extraction for numeric fields that have fielddata disabled #99213
• expose source as a metadata field ESQL: Expose _source as a metadata field #99456
• default project for Kibana queries ESQL: document/source/Kibana mode with default source projection #99457
• ES|QL does not consistently handle field names starting with a number ES|QL does not consistently handle field names starting with a number #100312
• emit warnings from all functions returning nulls on multivalues ESQL: emit warnings from all functions returning nulls on multivalues #98743
• Incorrect error messages - ESQL: Improve some validation/syntax error messages to be clearer #100047
• ESQL: have unary scalar functions operate on multivalues #99672
• syntax error on date math if date period variable is at the end of the expression ESQL: syntax error on date math if date period variable is at the end of the expression #99293
• ESQL: date_extract using a constant/literal chrono_field fails to record the warning ESQL: date_extract using a constant/literal chrono_field fails to record the warning #100038
• ESQL: Comparing a large long to an int field fails when pushed to source ESQL: Comparing a large long to an int field fails when pushed to source #99960
• fallback to source extraction for fields that have field data disabled ESQL: fallback to source extraction for numeric fields that have fielddata disabled #99213

[elasticsearchmachine]

Pinging @elastic/es-ql (Team:QL)

[elasticsearchmachine]

Pinging @elastic/elasticsearch-esql (:Query Languages/ES|QL)