calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "hongbin ma (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1629) EXTRACT function not working in CSVTest
Date Fri, 10 Feb 2017 06:06:41 GMT
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)

Mime
View raw message