Build Scans:

• elasticsearch-intake #26851 / part3
• elasticsearch-intake #26848 / part3
• elasticsearch-pull-request #85536 / part-3
• elasticsearch-pull-request #85541 / part-3

Reproduction Line:

./gradlew ":x-pack:plugin:esql:test" --tests "org.elasticsearch.xpack.esql.CsvTests" -Dtests.method="test {csv-spec:string.SpaceNegative}" -Dtests.seed=4837220943A3D4A1 -Dtests.locale=nqo -Dtests.timezone=America/Cancun -Druntime.java=24 

Applicable branches:
main

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: Expected a list containing 0: expected "Line 1:51: evaluation of [SPACE(-LENGTH(first_name))] failed, treating result as null. Only first 20 failures recorded." but was <missing> 1: expected "Line 1:51: java.lang.IllegalArgumentException: Number parameter cannot be negative, found [-6]" but was <missing> 

Issue Reasons:

• [main] 4 failures in test test {csv-spec:string.SpaceNegative} (1.7% fail rate in 229 executions)
• [main] 2 failures in step part3 (3.9% fail rate in 51 executions)
• [main] 2 failures in step part-3 (2.0% fail rate in 101 executions)
• [main] 2 failures in pipeline elasticsearch-intake (3.9% fail rate in 51 executions)
• [main] 2 failures in pipeline elasticsearch-pull-request (2.0% fail rate in 99 executions)

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