[ https://issues.apache.org/jira/browse/CALCITE-1924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726892#comment-17726892 ]
ZheHu commented on CALCITE-1924: -------------------------------- According to the above discussions, I think we can resolve operator "+" to CONCAT when both operand are CHARACTER type, and it's only *enabled in MSSQL*. I've alse run the following SQL in JdbcTest, which means Calcite now is able to convert strings to numbers. {code} SELECT '1' + '2' as alia -- returns 3 {code} Hi [~R0ger], do you have any progress yet? I'd like to take a look at this case to see if I can help. > 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)