[ https://issues.apache.org/jira/browse/PHOENIX-2476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Liew updated PHOENIX-2476: -------------------------------- Summary: Recognize common string concatenation operator symbols (was: Recognize '+' as a string concatenation operator symbol) > Recognize common string concatenation operator symbols > ------------------------------------------------------ > > 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 > Priority: Minor > 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)