{
    "dynamic": false,
    "properties" : {
        "id" : {
            "type" : "integer"
        },
        "version" : {
            "type" : "version"
        }
    }
}

implictCastingNotEqual
required_capability: string_literal_auto_casting_extended
from apps | where version != "1.2.3.4" | sort name, version | keep name, version | limit 2;

./gradlew ":x-pack:plugin:esql:qa:server:single-node:javaRestTest" --tests "org.elasticsearch.xpack.esql.qa.single_node.EsqlSpecIT" -Dtests.method="test {csv-spec:version.ImplictCastingNotEqual}"

Data mismatch:
row 1 column 0:a list containing
row 1 column 0:0: expected "bbbbb" but was "eeeee"
row 1 column 1:a list containing
row 1 column 1:0: expected "2.1" but was "1.11.0"
Actual:
name:keyword | version:version
aaaaa        | 1
eeeee        | 1.11.0

Expected:
name:keyword | version:version
aaaaa        | 1
bbbbb        | 2.1