tree 4675751c7f554e1142731ab2067ee61e1cee8dd4
parent 1f5ba75d686b5d7832a59cd5e82777b3527cf70d
author Tim Nieradzik <tim@sparse.tech> 1707927183 +0200
committer Mihai Budiu <mbudiu@feldera.com> 1712614874 -0700

[CALCITE-6265] Type coercion is failing for numeric values in prepared statements

Given a column of type `INT`. When providing a `short` value as a
placeholder in a prepared statement, a `ClassCastException` is thrown.

Test case:
```
final String sql =
    "select \"empid\" from \"hr\".\"emps\" where \"empid\" in (?, ?)";
CalciteAssert.hr()
    .query(sql)
    .consumesPreparedStatement(p -> {
        p.setShort(1, (short) 100);
        p.setShort(2, (short) 110);
    })
    .returnsUnordered("empid=100", "empid=110");
```

Stack trace:
```
java.lang.ClassCastException: class java.lang.Short cannot be cast to class java.lang.Integer (java.lang.Short and java.lang.Integer are in module java.base of loader 'bootstrap')
     at Baz$1$1.moveNext(Unknown Source)
     at org.apache.calcite.linq4j.Linq4j$EnumeratorIterator.<init>(Linq4j.java:679)
```