[CI] EsqlSpecIT test {categorize.On REVERSE(CONCAT()) SYNC} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic #8851 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic #8851 / openjdk17_checkpart3_java-matrix
• elasticsearch-periodic #8851 / graalvm-ce17_checkpart3_java-matrix
• elasticsearch-periodic #8845 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic #8845 / openjdk17_checkpart3_java-matrix
• elasticsearch-periodic #8845 / graalvm-ce17_checkpart3_java-matrix
• elasticsearch-periodic #8839 / graalvm-ce17_checkpart3_java-matrix
• elasticsearch-periodic #8839 / openjdk17_checkpart3_java-fips-matrix
• elasticsearch-periodic #8839 / openjdk17_checkpart3_java-matrix

Reproduction Line:

./gradlew ":x-pack:plugin:esql:qa:server:multi-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.multi_node.EsqlSpecIT" -Dtests.method="test {categorize.On REVERSE(CONCAT()) ASYNC}" -Dtests.seed=37E0D2ABC15B720B -Dtests.locale=bem -Dtests.timezone=Australia/Tasmania -Druntime.java=17 -Dtests.fips.enabled=true

Applicable branches:
8.19

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

java.lang.AssertionError: 
Data mismatch:
row 0 column 1:a list containing
row 0 column 1:0: expected ".*?😊.+?👍🏽.+?detcennocsiD.*?" but was ".*?😊🏽.+?👍.+?detcennocsiD.*?"
row 1 column 1:a list containing
row 1 column 1:0: expected ".*?😊.+?👍🏽.+?ot.+?detcennoC.*?" but was ".*?😊🏽.+?👍.+?ot.+?detcennoC.*?"
row 2 column 1:a list containing
row 2 column 1:0: expected ".*?😊.+?👍🏽.+?rorre.+?noitcennoC.*?" but was ".*?😊🏽.+?👍.+?rorre.+?noitcennoC.*?"
Actual:
COUNT():long | category:keyword
1            | .*?😊🏽.+?👍.+?detcennocsiD.*?
3            | .*?😊🏽.+?👍.+?ot.+?detcennoC.*?
3            | .*?😊🏽.+?👍.+?rorre.+?noitcennoC.*?

Expected:
COUNT():long | category:keyword
1            | .*?😊.+?👍🏽.+?detcennocsiD.*?
3            | .*?😊.+?👍🏽.+?ot.+?detcennoC.*?
3            | .*?😊.+?👍🏽.+?rorre.+?noitcennoC.*?

Issue Reasons:

• [8.19] 3 consecutive failures in step openjdk17_checkpart3_java-fips-matrix
• [8.19] 3 consecutive failures in step openjdk17_checkpart3_java-matrix
• [8.19] 3 consecutive failures in step graalvm-ce17_checkpart3_java-matrix
• [8.19] 9 failures in test test {categorize.On REVERSE(CONCAT()) SYNC} (7.6% fail rate in 118 executions)
• [8.19] 3 failures in step openjdk17_checkpart3_java-fips-matrix (100.0% fail rate in 3 executions)
• [8.19] 3 failures in step openjdk17_checkpart3_java-matrix (100.0% fail rate in 3 executions)
• [8.19] 3 failures in step graalvm-ce17_checkpart3_java-matrix (100.0% fail rate in 3 executions)
• [8.19] 3 failures in pipeline elasticsearch-periodic (75.0% fail rate in 4 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)