[
https://issues.apache.org/jira/browse/PHOENIX-2476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15035001#comment-15035001
]
Julian Hyde commented on PHOENIX-2476:
--------------------------------------
No, Calcite does not support string concatenation using {{+}}.
Supporting it might be ambiguous. For example, I haven't checked, but in
Oracle, I'd expect {{deptno + '1'}} to implicitly convert '1' to a numeric,
add the numbers, and produce a numeric result, say 11 if deptno = 10. If {{+}}
could mean string concatenation, then {{101}} could be the result.
I guess we could come up with a consistent semantics, but I don't see much
urgency to support a non-standard feature.
> Use the standard string concatenation operator symbol
> -----------------------------------------------------
>
> Key: PHOENIX-2476
> URL: https://issues.apache.org/jira/browse/PHOENIX-2476
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 4.6.0
> Reporter: Kevin Liew
> Labels: newbie, phoenix, string
>
> Phoenix uses '||' as the string concatenation operator symbol instead of the
> commonly used '+'
> https://msdn.microsoft.com/en-CA/library/ms177561.aspx
> If we try to use '+' we get an error from the queryserver
> {noformat}Type mismatch. VARCHAR for (COLUMN1 + KEYCOLUMN){noformat}
> The '+'
> operator is not implemented for VARCHAR so it would be an improvement to
> implement the standard function for that '+' symbol
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
