[
https://issues.apache.org/jira/browse/CALCITE-1924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726964#comment-17726964
]
Julian Hyde commented on CALCITE-1924:
--------------------------------------
When you propose a fix, you should also describe how people should enable the
functionality. I'm not sure that compliance is the right way to switch this;
because we're enabling additional overloads of '+', possibly {{fun=mssql}} is
the way to go.
> 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
> Priority: Minor
>
> Currently the following SQL is not supported.
> {code}
> select 'A' + 'B' + 'C';
> {code}
> We get the exception:
> {noformat}
> 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)
> {noformat}
> In this JIRA, I'll fix this by supporting operator "+" as string concat
> operator.
> Similar to CALCITE-1374 and CALCITE-1897.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
