hongbin ma created CALCITE-1629:
-----------------------------------
Summary: EXTRACT function not working in CSVTest
Key: CALCITE-1629
URL: https://issues.apache.org/jira/browse/CALCITE-1629
Project: Calcite
Issue Type: Bug
Reporter: hongbin ma
Assignee: Julian Hyde
According to this doc https://calcite.apache.org/docs/reference.html the
EXTRACT function should work in Calcite. So I'm trying a query with EXTRACT in
CSVTest:
@Test public void testSelectx() throws SQLException {
checkSql("model", "select extract(year from JOINEDAT) from EMPS ");
}
the query failed due to:
java.lang.ClassCastException: java.sql.Date cannot be cast to java.lang.Integer
I also tried to change column JOINDAT's type to timestamp and datetime, but end
up with similar exceptions.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
