### 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/CsvTestUtils.java
if (type == null) {
                    throw new IllegalArgumentException("Unknown type name: [" + typeName + "]");
                }
                columnTypes.add(type);
            }
            List<List<Object>> values = new ArrayList<>();
            List<String> row;
            while ((row = listReader.read()) != null) {
                List<Object> rowValues = new ArrayList<>(row.size());
                for (int i = 0; i < row.size(); i++) {
                    String value = row.get(i);
                    if (value == null || value.trim().equalsIgnoreCase(NULL_VALUE)) {
                        value = null;
                        rowValues.add(columnTypes.get(i).convert(value));
                        continue;
                    }
                    value = value.trim();
                    if (value.startsWith("[") ^ value.endsWith("]")) {
                        throw new IllegalArgumentException("Incomplete multi-value (opening and closing square brackets) found " + value);
                    }
                    if (value.contains(",") && value.startsWith("[")) {
                        List<Object> listOfMvValues = new ArrayList<>();
                        for (String mvValue : delimitedListToStringArray(value.substring(1, value.length() - 1), ",")) {
                            listOfMvValues.add(columnTypes.get(i).convert(mvValue.trim()));
                        }
                        rowValues.add(listOfMvValues);
                    } else {
                        rowValues.add(columnTypes.get(i).convert(value));
                    }
                }