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