[
https://issues.apache.org/jira/browse/PHOENIX-1026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14315490#comment-14315490
]
Rajeshbabu Chintaguntla commented on PHOENIX-1026:
--------------------------------------------------
[~jamestaylor]
If we want concat constants to indexed column value if possible we can use
inde. I have fixed this in 4.0 and 5.0.0 branches as part of local index work.
Examples.
{code}
SELECT x_decimal||5||'bar' FROM atable limit 1
{code}
> ParseNodeRewriter can rewrite StringConcatParseNode children
> -------------------------------------------------------------
>
> Key: PHOENIX-1026
> URL: https://issues.apache.org/jira/browse/PHOENIX-1026
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0, 3.1, 4.1
> Reporter: rajeshbabu
> Priority: Minor
>
> if SQL expression with string concatenation has indexed columns then directly
> we can use index if possible. At present ColumnParseNodes not having proper
> name in StringConcatParseNode so we are not able to use index.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
