[
https://issues.apache.org/jira/browse/CALCITE-1629?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15860794#comment-15860794
]
hongbin ma commented on CALCITE-1629:
-------------------------------------
from julian:
You’re running into the problem I feared when I wrote "I'd rather that we
convert java.sql.Date values when they enter the system” in
https://issues.apache.org/jira/browse/CALCITE-1569
<https://issues.apache.org/jira/browse/CALCITE-1569>. EXTRACT needs its input
to be in internal format, which is a long (or Long) for a TIMESTAMP, an int (or
Integer) for a DATE or TIME.
> 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)
