### 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
return testName.endsWith("-Ignore") == false;
    }
    public static Tuple<Page, List<String>> loadPageFromCsv(URL source) throws Exception {
        record CsvColumn(String name, Type type, BuilderWrapper builderWrapper) {
            void append(String stringValue) {
                if (stringValue.contains(",")) {
                    builderWrapper().builder().beginPositionEntry();
                    String[] arrayOfValues = delimitedListToStringArray(stringValue, ",");
                    List<Object> convertedValues = new ArrayList<>(arrayOfValues.length);
                    for (String value : arrayOfValues) {
                        convertedValues.add(type.convert(value));
                    }
                    convertedValues.stream().sorted().forEach(v -> builderWrapper().append().accept(v));
                    builderWrapper().builder().endPositionEntry();
                    return;
                }
                var converted = stringValue.length() == 0 ? null : type.convert(stringValue);
                builderWrapper().append().accept(converted);
            }
        }
        CsvColumn[] columns = null;
        try (BufferedReader reader = org.elasticsearch.xpack.ql.TestUtils.reader(source)) {
            String line;
            int lineNumber = 1;
            while ((line = reader.readLine()) != null) {
                line = line.trim();
                
                if (shouldSkipLine(line) == false) {
                    String[] entries = multiValuesAwareCsvToStringArray(line, lineNumber);