phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2476) Use the standard string concatenation operator symbol
Date Wed, 02 Dec 2015 00:49:11 GMT

    [ 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)

Mime
View raw message