### 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/ql/test-fixtures/src/main/java/org/elasticsearch/xpack/ql/CsvSpecReader.java
}
            }
            
            else {
                
                if (line.toLowerCase(Locale.ROOT).startsWith("warning:")) {
                    testCase.expectedWarnings.add(line.substring("warning:".length()).trim());
                } else if (line.startsWith(";")) {
                    testCase.expectedResults = data.toString();
                    
                    CsvTestCase result = testCase;
                    testCase = null;
                    data.setLength(0);
                    return result;
                } else {
                    data.append(line);
                    data.append("\r\n");
                }
            }
            return null;
        }
    }
    public static class CsvTestCase {
        public String query;
        public String earlySchema;
        public String expectedResults;
        public List<String> expectedWarnings = new ArrayList<>();
    }
}