[jira] [Resolved] (CALCITE-1629) EXTRACT function not working in CSVTest

["Julian Hyde (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-1629?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved CALCITE-1629.
----------------------------------
       Resolution: Duplicate
    Fix Version/s: 1.12.0

Closing as duplicate of CALCITE-1569.

> 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
>             Fix For: 1.12.0
>
>
> 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)