### Description

As discussed in https://github.com/elastic/elasticsearch/issues/98995, queries will not have an implicit order - as such the CSV spec framework would have to account for this.
As some tests will want to check the order while others might not, it's best to have a flag or marker when the out of order occurs and use a different assertion method.
x-pack/plugin/esql/qa/testFixtures/src/main/java/org/elasticsearch/xpack/esql/CsvAssert.java
for (int row = 0; row < expectedValues.size(); row++) {
            try {
                assertTrue("Expected more data but no more entries found after [" + row + "]", row < actualValues.size());
                if (logger != null) {
                    logger.info(row(actualValues, row));
                }
                var expectedRow = expectedValues.get(row);
                var actualRow = actualValues.get(row);
                for (int column = 0; column < expectedRow.size(); column++) {
                    var expectedValue = expectedRow.get(column);
                    var actualValue = actualRow.get(column);
                    if (expectedValue != null) {
                        var expectedType = expected.columnTypes().get(column);
                        
                        if (expectedType == Type.DATETIME) {
                            expectedValue = rebuildExpected(expectedValue, Long.class, x -> UTC_DATE_TIME_FORMATTER.formatMillis((long) x));
                        } else if (expectedType == Type.IP) {
                            
                            expectedValue = rebuildExpected(expectedValue, BytesRef.class, x -> DocValueFormat.IP.format((BytesRef) x));
                        } else if (expectedType == Type.VERSION) {
                            
                            expectedValue = rebuildExpected(expectedValue, BytesRef.class, x -> new Version((BytesRef) x).toString());
                        } else if (expectedType == UNSIGNED_LONG) {
                            expectedValue = rebuildExpected(expectedValue, Long.class, x -> unsignedLongAsNumber((long) x));
                        }
                    }
                    assertEquals(valueTransformer.apply(expectedValue), valueTransformer.apply(actualValue));
                }
                var delta = actualRow.size() - expectedRow.size();
                if (delta > 0) {