You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2015/12/02 02:13:11 UTC
[jira] [Updated] (PHOENIX-2476) Recognize '+' as a string
concatenation operator symbol
[ https://issues.apache.org/jira/browse/PHOENIX-2476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Liew updated PHOENIX-2476:
--------------------------------
Summary: Recognize '+' as a string concatenation operator symbol (was: Use the standard string concatenation operator symbol)
> Recognize '+' as a 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 '||' (Oracle) as the string concatenation operator symbol instead of the commonly used '+'
> (SQL Server)
> 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)