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

["hongbin ma (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-1629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15968695#comment-15968695 ] 

hongbin ma commented on CALCITE-1629:
-------------------------------------

The same test case passes at calcite 1.12, guess it is solved along with CALCITE-1569, suggest to close this issue

> 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)