Build Scans:

• elasticsearch-periodic #11495 / release-tests
• elasticsearch-pull-request #105982 / checkpart3_release-tests
• elasticsearch-pull-request #105979 / checkpart3_release-tests
• elasticsearch-pull-request #105968 / checkpart3_release-tests

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.optimizer.rules.physical.local.SubstituteRoundToTests.testSubqueryWithCountStarAndDateTrunc {default}" -Dtests.seed=CA1572EF7FE8197A -Dbuild.snapshot=false -Dtests.jvm.argline="-Dbuild.snapshot=false" -Dlicense.key=x-pack/license-tools/src/test/resources/public.key -Dtests.locale=en-MW -Dtests.timezone=US/Aleutian -Druntime.java=25

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.elasticsearch.xpack.esql.parser.ParsingException: line 1:12: no viable alternative at input '('

Issue Reasons:

• [main] 3 consecutive failures in step checkpart3_release-tests
• [main] 4 failures in test testSubqueryWithCountStarAndDateTrunc {default} (12.1% fail rate in 33 executions)
• [main] 3 failures in step checkpart3_release-tests (100.0% fail rate in 3 executions)
• [main] 3 failures in pipeline elasticsearch-pull-request (16.7% fail rate in 18 executions)

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