[ESQL] Class cast exception mixing division and comparison

[not-napoleon]

Elasticsearch Version

main

Installed Plugins

No response

Java Version

bundled

OS Version

n/a

Problem Description

FROM test | EVAL x = double / 2 > 4 results in a ClassCastException:

        "reason": "class org.elasticsearch.compute.data.DoubleVectorBlock cannot be cast to class org.elasticsearch.compute.data.IntBlock (org.elasticsearch.compute.data.DoubleVectorBlock and org.elasticsearch.compute.data.IntBlock are in unnamed module of loader java.net.FactoryURLClassLoader @45e11627)"

This seems to only happen when both division and comparison are involved. Neither FROM test | EVAL x = double / 2 and FROM test | EVAL x = double > 4 trigger the error.

Steps to Reproduce

PUT http://localhost:9200/test
content-type: application/json

{
  "mappings": {
    "properties": {
        "float": {"type": "float"},
        "int": {"type": "integer"},
        "double": {"type": "double"}
    }
  }
}


POST http://localhost:9200/_query?format=txt
content-type: application/json

{
  "version": "2024.04.01",
  "query": "FROM test | EVAL x = double / 2 > 4" 
}

Logs (if relevant)

No response

[elasticsearchmachine]

Pinging @elastic/es-analytical-engine (Team:Analytics)