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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Ruben Q L
• Reporter: Tim Nieradzik
• Created: 14/Feb/24 16:09
• Updated: 06/May/24 22:19
• Resolved: 16/Apr/24 17:29

Description

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)

Issue Links

• is related to: CALCITE-6284 Invalid conversion triggers ClassCastException
• is related to: CALCITE-6366 Code generated by EnumUtils#convert should throw an exception if the target type is overflowed
• links to: GitHub Pull Request #3687
• links to: GitHub Pull Request #3758