JdbcSqlSpecIT test {subselect.testSimpleSubSelect} failure

[davidkyle]

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

Repro line:

./gradlew ':x-pack:plugin:sql:qa:server:single-node:integTest' --tests "org.elasticsearch.xpack.sql.qa.single_node.JdbcSqlSpecIT" \
  -Dtests.method="test {subselect.testSimpleSubSelect}" \
  -Dtests.seed=32C4B0F4FD776FF6 \
  -Dtests.security.manager=true \
  -Dtests.locale=ar-YE \
  -Dtests.timezone=Africa/Luanda \
  -Druntime.java=11

Reproduces locally?:
No

Applicable branches:
master

Failure history:
This is the first failure of the test I could find. Leaving unmuted as not reproducible and is a one-off for now

Failure excerpt:

java.lang.AssertionError: test_emp should have no search contexts expected:<0> but was:<1>
	at __randomizedtesting.SeedInfo.seed([32C4B0F4FD776FF6:BA908F2E538B020E]:0)
	at org.junit.Assert.fail(Assert.java:88)
	at org.junit.Assert.failNotEquals(Assert.java:834)
	at org.junit.Assert.assertEquals(Assert.java:645)
	at org.elasticsearch.xpack.sql.qa.rest.RestSqlTestCase.assertNoSearchContexts(RestSqlTestCase.java:1096)
	at org.elasticsearch.xpack.sql.qa.jdbc.JdbcIntegrationTestCase.checkSearchContent(JdbcIntegrationTestCase.java:38)

[elasticmachine]

Pinging @elastic/es-ql (:Query Languages/SQL)