[CI] JdbcSqlSpecIT test {case-functions.testSelectInsertWithLcaseAndLengthWithOrderBy} failing

[elasticsearchmachine]

Build Scans:

• elasticsearch-periodic-platform-support #5253 / ubuntu-2204_platform-support-unix
• elasticsearch-periodic-platform-support #5205 / ubuntu-1804_platform-support-unix

Reproduction Line:

./gradlew ':x-pack:plugin:sql:qa:server:single-node:javaRestTest' --tests "org.elasticsearch.xpack.sql.qa.single_node.JdbcSqlSpecIT" -Dtests.method="test {case-functions.testUcaseInline3}" -Dtests.seed=114829B71060352E -Dtests.locale=az-AZ -Dtests.timezone=America/Louisville -Druntime.java=22

Applicable branches:
8.15

Reproduces locally?:
N/A

Failure History:
See dashboard

Failure Message:

org.junit.ComparisonFailure: Different result for column [upper], entry [1] expected:< ELAST[İ]C > but was:< ELAST[I]C >

Issue Reasons:

• [8.15] 2 failures in test test {case-functions.testSelectInsertWithLcaseAndLengthWithOrderBy} (0.9% fail rate in 224 executions)
• [8.15] 2 failures in pipeline elasticsearch-periodic-platform-support (22.2% fail rate in 9 executions)

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

[elasticsearchmachine]

Pinging @elastic/es-delivery (Team:Delivery)

[elasticsearchmachine]

This has been muted on branch main

Mute Reasons:

• [main] 3 failures in test test {case-functions.testSelectInsertWithLcaseAndLengthWithOrderBy} (1.0% fail rate in 299 executions)
• [main] 2 failures in pipeline elasticsearch-periodic-platform-support (28.6% fail rate in 7 executions)

Build Scans:

• elasticsearch-intake #9492 / part3
• elasticsearch-periodic-platform-support #3968 / amazonlinux-2023_platform-support-aws
• elasticsearch-periodic-platform-support #3956 / windows-2016_checkpart3_platform-support-windows

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)