Roger Shi created CALCITE-1924:
----------------------------------

             Summary: Support operator "+" as string concat operator
                 Key: CALCITE-1924
                 URL: https://issues.apache.org/jira/browse/CALCITE-1924
             Project: Calcite
          Issue Type: Improvement
            Reporter: Roger Shi
            Assignee: Julian Hyde
            Priority: Minor


Current the following sql is not supported.

select 'A' + 'B' + 'C';

We get the exception:

Error while executing SQL "select 'A' + 'B' + 'C'": From line 1, column 8 to 
line 1, column 16: Cannot apply '+' to arguments of type '<CHAR(1)> + 
<CHAR(1)>'. Supported form(s): '<NUMERIC> + <NUMERIC>'
'<DATETIME_INTERVAL> + <DATETIME_INTERVAL>'
'<DATETIME> + <DATETIME_INTERVAL>'
'<DATETIME_INTERVAL> + <DATETIME>' (state=,code=0)

In this JIRA, I'll fix this by supporting operator "+" as string concat 
operator.
Similar to https://issues.apache.org/jira/browse/CALCITE-1374 and 
https://issues.apache.org/jira/browse/CALCITE-1897 .



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to