### 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
}
    private static String rowAsString(List<Object> list) {
        StringBuilder sb = new StringBuilder();
        StringBuilder column = new StringBuilder();
        for (int i = 0; i < list.size(); i++) {
            column.setLength(0);
            if (i > 0) {
                sb.append(" | ");
            }
            sb.append(trimOrPad(column.append(list.get(i))));
        }
        return sb.toString();
    }
    private static StringBuilder trimOrPad(StringBuilder buffer) {
        if (buffer.length() > MAX_WIDTH) {
            buffer.setLength(MAX_WIDTH - 1);
            buffer.append("~");
        } else {
            buffer.append(" ".repeat(Math.max(0, MAX_WIDTH - buffer.length())));
        }
        return buffer;
    }
    private static double scaledFloat(String value, String factor) {
        double scalingFactor = Double.parseDouble(factor);
        
        double scalingFactorInverse = 1d / scalingFactor;
        return new BigDecimal(value).multiply(BigDecimal.valueOf(scalingFactor)).longValue() * scalingFactorInverse;
    }
}