[
https://issues.apache.org/jira/browse/CALCITE-5659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17713690#comment-17713690
]
Julian Hyde commented on CALCITE-5659:
--------------------------------------
[~oliverlee], Do you not expect EXTRACT to occur inside an INTERVAL expression?
Or TRANSLATE, OVERLAY or FLOOR? Obviously, there are many bugs similar to this
one. You can't just stop at CAST for an arbitrary reason. You need to figure
out where to stop.
> Allow CAST in an INTERVAL definition
> -------------------------------------
>
> Key: CALCITE-5659
> URL: https://issues.apache.org/jira/browse/CALCITE-5659
> Project: Calcite
> Issue Type: Bug
> Reporter: Oliver Lee
> Assignee: Oliver Lee
> Priority: Major
>
> Running queries that contain a CAST as part of the INTERVAL definition is
> throwing a parser error.
> i.e.
> {{INTERVAL CAST(5 as int64) YEAR}}
> We can make parser changes to allow the Cast function tokens to be accepted
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
