JdbcCsvSpecIT.testAverageWithOneValueAndLimit failing

[ywelsch]

java.lang.AssertionError: 
Elasticsearch [JdbcResultSet:row 4:cursor size 2:[languages<type=[BYTE]>, 'F'<type=[DOUBLE]>]] still has data after [3] entries:
3                    | 53660.0     



REPRODUCE WITH: ./gradlew ':x-pack:plugin:sql:qa:single-node:integTestRunner' --tests "org.elasticsearch.xpack.sql.qa.single_node.JdbcCsvSpecIT" -Dtests.method="test {pivot.testAverageWithOneValueAndLimit}" -Dtests.seed=81AF0740AC9F7D95 -Dtests.security.manager=true -Dtests.locale=yo -Dtests.timezone=Etc/GMT-10 -Dcompiler.java=12 -Druntime.java=11

Build scan: https://gradle-enterprise.elastic.co/s/ryxn3kl4orgom

[elasticmachine]

Pinging @elastic/es-search

[ywelsch]

Failure on 7.x : https://gradle-enterprise.elastic.co/s/bimadqxmhc6rk

[ywelsch]

Don't know how to mute this single test, so I just removed it for now (see f903d92 (master) and 056ac32 (7.x))

[costin]

I've tried reproducing this without success - I think that's because there was a race condition, the fix being about to be merged: #47121

[costin]

Indeed, on both 7.x and master I cannot reproduce the failure. I'm asking around for some folks to try it out, otherwise, I'll enable the tests back.