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.
Support operator "%" as an alternative to "mod"
Support operator "!=" as an alternative to "<>"