Taras Ledkov created IGNITE-14961:
-------------------------------------

             Summary: 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


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)

Reply via email to