[
https://issues.apache.org/jira/browse/CALCITE-1124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15179598#comment-15179598
]
Arina Ielchiieva commented on CALCITE-1124:
-------------------------------------------
As part of solution I am registering all timestamp intervals as tokens to
convert them to literals whenever they come inside timestamp[add|diff]
structure.
Also I have added them into SqlStdOperatorTable.
> Add support for timestampadd / timestampdiff functions
> ------------------------------------------------------
>
> Key: CALCITE-1124
> URL: https://issues.apache.org/jira/browse/CALCITE-1124
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: next
> Reporter: Arina Ielchiieva
> Assignee: Julian Hyde
>
> When calling timestampadd / timestampdiff with first parameter:
> MICROSECOND (MICROSECONDS, FRAC_SECOND (deprecated)), (SQL_TSI_)SECOND,
> (SQL_TSI_)MINUTE, (SQL_TSI_)HOUR, (SQL_TSI_)DAY,
> (SQL_TSI_)WEEK,(SQL_TSI_)MONTH, (SQL_TSI_)QUARTER, (SQL_TSI_)YEAR
> (ex: timestampadd(second, 1, current_datetime), calcite throws an error:
> Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered "(
> SECOND" at line 1, column 25.
> Was expecting one of:
> "(" "*" ...
> "(" ")" ...
> "(" "WITH" ...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
