org.elasticsearch.xpack.sql.qa.single_node.Jdbc*CsvSpecIT failing reliably

[jasontedor]

The failures look like:

2> org.junit.ComparisonFailure: Different result for column [first_name], entry [2] expected:<[Kenroku]> but was:<[Lillian]>
        at __randomizedtesting.SeedInfo.seed([8A53D22B1133691A:207EDF1BFCF04E2]:0)
        at org.elasticsearch.xpack.sql.qa.single_node.JdbcDocCsvSpecIT.docs.testFilterToday(docs.csv-spec:2415)
        at org.junit.Assert.assertEquals(Assert.java:115)
        at org.elasticsearch.xpack.sql.qa.jdbc.JdbcAssert.doAssertResultSetData(JdbcAssert.java:261)
        at org.elasticsearch.xpack.sql.qa.jdbc.JdbcAssert.assertResultSetData(JdbcAssert.java:180)
        at org.elasticsearch.xpack.sql.qa.jdbc.JdbcAssert.assertResultSets(JdbcAssert.java:82)
        at org.elasticsearch.xpack.sql.qa.single_node.JdbcDocCsvSpecIT.assertResults(JdbcDocCsvSpecIT.java:72)
        at org.elasticsearch.xpack.sql.qa.single_node.JdbcDocCsvSpecIT.doTest(JdbcDocCsvSpecIT.java:87)

The failures are in test {docs.testFilterToday} and test {date.testCurrentDateFilter}. I simply muted the entire suites of JdbcCsvSpecIT and JdbcDocCsvSpecIT. The seed 8A53D22B1133691A reproduces these failures reliably.

[elasticmachine]

Pinging @elastic/es-search

[jasontedor]

Muted in master in b80e279.

[jasontedor]

I opted for more targeted muting in 529eda3.

[mark-vieira]

I've cherry picked this to 7.x and 7.0 as well as this test seems to have started failing there as well.

https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+7.x+periodic/339/

[DaveCTurner]

Cherry-picked 639bfe6 to 6.7 as 0a88e7f since https://elasticsearch-ci.elastic.co/job/elastic+elasticsearch+6.7+intake/528/ failed for similar reasons too.