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)