[jira] [Created] (CALCITE-1840) Date floor is broken when used with reflective schema

[Chris Baynes (JIRA)]

Chris Baynes created CALCITE-1840:
-------------------------------------

             Summary: Date floor is broken when used with reflective schema
                 Key: CALCITE-1840
                 URL: https://issues.apache.org/jira/browse/CALCITE-1840
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Chris Baynes
            Assignee: Julian Hyde


Using the everyTypes reflective schema the following query:

{code:java}
select floor("sqlDate" to month) from "s"."everyTypes"
{code}

fails with:

{code}
Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to 
java.sql.Date
        at 
org.apache.calcite.avatica.util.AbstractCursor$DateAccessor.getDate(AbstractCursor.java:1031)
        at 
org.apache.calcite.avatica.util.AbstractCursor$DateAccessor.getLong(AbstractCursor.java:1052)
        at 
org.apache.calcite.avatica.util.AbstractCursor$AccessorImpl.getInt(AbstractCursor.java:305)
        at 
org.apache.calcite.avatica.util.AbstractCursor$DateAccessor.getString(AbstractCursor.java:1044)
        at 
org.apache.calcite.avatica.AvaticaResultSet.getString(AvaticaResultSet.java:257)
        at 
org.apache.calcite.test.CalciteAssert$ResultSetFormatter.rowToString(CalciteAssert.java:1720)
        at 
org.apache.calcite.test.CalciteAssert$ResultSetFormatter.toStringList(CalciteAssert.java:1738)
        at 
org.apache.calcite.test.CalciteAssert.toStringList(CalciteAssert.java:611)
        at org.apache.calcite.test.CalciteAssert$9.apply(CalciteAssert.java:383)
        at org.apache.calcite.test.CalciteAssert$9.apply(CalciteAssert.java:375)
        at 
org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:533)
        at 
org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1266)
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)