[
https://issues.apache.org/jira/browse/IGNITE-14961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Taras Ledkov updated IGNITE-14961:
----------------------------------
Description:
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}
was:
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}
> 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}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
