[CI] EsqlClientYamlIT test {p0=esql/30_types/constant_keyword} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8351 / 8.15.5_bwc
• elasticsearch-periodic #8351 / 8.13.4_bwc
• elasticsearch-periodic #8351 / 8.14.3_bwc
• elasticsearch-periodic #8351 / 8.12.2_bwc
• elasticsearch-periodic #8345 / 8.14.3_bwc
• elasticsearch-periodic #8345 / 8.13.4_bwc
• elasticsearch-periodic #8339 / 8.14.3_bwc
• elasticsearch-periodic #8339 / 8.12.2_bwc
• elasticsearch-periodic #8339 / 8.13.4_bwc
• elasticsearch-periodic #8298 / 8.11.4_bwc

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:mixed-cluster:v8.15.5#yamlRestTest" -Dtests.class="org.elasticsearch.xpack.esql.qa.mixed.EsqlClientYamlIT" -Dtests.method="test {p0=esql/30_types/constant_keyword}" -Dtests.seed=70695B1A70C67FD2 -Dtests.bwc=true -Dtests.locale=ur-IN -Dtests.timezone=Portugal -Druntime.java=24

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Failure at [esql/30_types:152]: expected [2xx] status code but api [esql.query] returned [400 Bad Request] [{"error":{"root_cause":[{"type":"verification_exception","reason":"Found 1 problem\nline 1:23: argument of [max(kind)] must be [datetime or numeric except unsigned_long or counter types], found value [max(kind)] type [keyword]","stack_trace":"org.elasticsearch.xpack.esql.VerificationException: Found 1 problem\nline 1:23: argument of [max(kind)] must be [datetime or numeric except unsigned_long or counter types], found value [max(kind)] type [keyword]\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.verify(Analyzer.java:165)\n\tat org.elasticsearch.xpack.esql.analysis.Analyzer.analyze(Analyzer.java:159)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.lambda$analyzedPlan$2(EsqlSession.java:147)\n\tat org.elasticsearch.xpack.esql.session.EsqlSession.lambda$preAnalyze$8(EsqlSession.java:186)\n\tat org.elasticsearch.server@8.15.5/org.elasticsearch.
[truncated]

Issue Reasons:

• [8.19] 3 consecutive failures in step 8.13.4_bwc
• [8.19] 3 consecutive failures in step 8.14.3_bwc
• [8.19] 2 consecutive failures in step 8.12.2_bwc
• [8.19] 2 consecutive failures in step 8.11.4_bwc
• [8.19] 11 failures in test test {p0=esql/30_types/constant_keyword} (2.3% fail rate in 481 executions)
• [8.19] 3 failures in step 8.13.4_bwc (18.8% fail rate in 16 executions)
• [8.19] 3 failures in step 8.14.3_bwc (18.8% fail rate in 16 executions)
• [8.19] 2 failures in step 8.12.2_bwc (22.2% fail rate in 9 executions)
• [8.19] 2 failures in step 8.11.4_bwc (100.0% fail rate in 2 executions)
• [8.19] 5 failures in pipeline elasticsearch-periodic (31.3% fail rate in 16 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)

[nik9000]

@luigidellaquila, is this from your recent work?

[luigidellaquila]

Yes, I'm checking it

[luigidellaquila]

Ah, my bad, it's just that 8.14 doesn't support max() on keywords (introduced in 8.16)