[CALCITE-1924] Support operator "+" as string concat operator(enabled in MSSQL library)

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: ZheHu
• Reporter: Roger Shi
• Created: 04/Aug/17 02:51
• Updated: 07/Jul/23 20:06

Description

Currently 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 CALCITE-1374 and CALCITE-1897.

Issue Links

• is related to: CALCITE-1897 Support operator "%" as an alternative to "mod"
• is related to: CALCITE-1374 Support operator "!=" as an alternative to "<>"
• relates to: CALCITE-5741 Add CONCAT_WS function (enabled in MSSQL, MySQL, Postgres libraries)