You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2022/05/17 14:46:00 UTC
[jira] [Commented] (IGNITE-14961) Calcite engine. Arithmetic operators cannot be applied to +
[ https://issues.apache.org/jira/browse/IGNITE-14961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17538245#comment-17538245 ]
Vladimir Steshin commented on IGNITE-14961:
-------------------------------------------
Does it correspond the standard? Why do we need this operator?
> Calcite engine. Arithmetic operators cannot be applied to <DATE> + <INTEGER>
> ----------------------------------------------------------------------------
>
> Key: IGNITE-14961
> URL: https://issues.apache.org/jira/browse/IGNITE-14961
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Taras Ledkov
> Priority: Major
>
> The query
> {{SELECT CAST('2000-10-10' AS DATE) + 2}}
> fails with *SqlValidatorException*
> {code}
> Cannot apply '+' to arguments of type '<DATE> + <INTEGER>'. Supported form(s): '<NUMERIC> + <NUMERIC>'
> '<DATETIME_INTERVAL> + <DATETIME_INTERVAL>'
> '<DATETIME> + <DATETIME_INTERVAL>'
> '<DATETIME_INTERVAL> + <DATETIME>'
> {code}
> Tests:
> {{function/date/test_extract_edge_cases.test_ignore}}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)