Tim Nieradzik created CALCITE-6265: -------------------------------------- Summary: Cannot provide different numeric type as placeholder Key: CALCITE-6265 URL: https://issues.apache.org/jira/browse/CALCITE-6265 Project: Calcite Issue Type: Bug Components: core Reporter: Tim Nieradzik Assignee: Tim Nieradzik
The `empid` column is of type `INT`. When providing a `short` value as a placeholder, a `ClassCastException` is thrown. ```java 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) ``` -- This message was sent by Atlassian Jira (v8.20.10#820010)