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 01:34:10 UTC

[jira] [Created] (PHOENIX-2476) Use the standard string concatenation operator symbol

Kevin Liew created PHOENIX-2476:
-----------------------------------

             Summary: 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


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)