[jira] [Commented] (CALCITE-307) Implement CAST between date-time types

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

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

Julian Hyde commented on CALCITE-307:
-------------------------------------

Implement cast between date-time types, e.g. CAST(aTimestamp AS DATE), CAST(aTime AS TIMESTAMP).

When you cast a TIME to a TIMESTAMP it should yield a time in the current day (per CURRENT_DATE).

Also be careful to round down when dealing with timestamps before the epoch (which are represented as negative numbers).

> Implement CAST between date-time types
> --------------------------------------
>
>                 Key: CALCITE-307
>                 URL: https://issues.apache.org/jira/browse/CALCITE-307
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Julian Hyde
>            Assignee: Julian Hyde
>
> See test case in misc.oq. Throws the following: 
> {code}
> java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
> 	at net.hydromatic.optiq.runtime.AbstractCursor$IntAccessor.getInt(AbstractCursor.java:452)
> 	at net.hydromatic.optiq.runtime.AbstractCursor$DateFromIntAccessor.getString(AbstractCursor.java:720)
> 	at net.hydromatic.avatica.AvaticaResultSet.getString(AvaticaResultSet.java:205)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)