[jira] [Created] (CALCITE-898) explicit cast required where not expected

[Jan Van Besien (JIRA)]

Jan Van Besien created CALCITE-898:
--------------------------------------

             Summary: explicit cast required where not expected
                 Key: CALCITE-898
                 URL: https://issues.apache.org/jira/browse/CALCITE-898
             Project: Calcite
          Issue Type: Bug
            Reporter: Jan Van Besien
            Assignee: Julian Hyde


As discussed on the mailinglist, there seems to be a bug related to unexpected 
casting of Long to Integer.

Queries such as these result in a ClassCastException.

{code}
select EMPNO * 3 as EMPNO from EMPS where EMPNO = 100
{code}

{code}
java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
        at 
org.apache.calcite.avatica.util.AbstractCursor$IntAccessor.getInt(AbstractCursor.java:485)
        at org.apache.calcite.avatica.AvaticaSite.get(AvaticaSite.java:338)
        at 
org.apache.calcite.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:381)
{code}

I was able to reproduce the problem with the CsvTest, see attached patch. Note 
that, in the patch, I changed the datatype of EMPNO from int to long and that I 
use resultSet.getObject in stead of resultSet.getString to output the result 
set. With getString it works because it doesn't try to cast the Long to an 
Integer first.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)