[
https://issues.apache.org/jira/browse/PHOENIX-2689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-2689:
----------------------------------
Attachment: PHOENIX-2689_v3.patch
Had to modify the patch due to null handling with string concatenation. Most
SQL operators return null if any of their inputs are null, but string
concatenation treats null as an empty string.
> VARCHAR Field Not Working With String Concatenation
> ---------------------------------------------------
>
> Key: PHOENIX-2689
> URL: https://issues.apache.org/jira/browse/PHOENIX-2689
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0
> Reporter: Steve T
> Assignee: James Taylor
> Priority: Minor
> Fix For: 4.7.0
>
> Attachments: PHOENIX-2689.patch, PHOENIX-2689_v2.patch,
> PHOENIX-2689_v3.patch
>
>
> Set up:
> {code:sql}
> create table BUGGY (PK1 integer, F1 varchar, F2 varchar, constraint PK
> primary key (PK1));
> upsert into BUGGY values(0, 'tortilla', 'chip');
> {code}
> This works as expected:
> {code:sql}
> select * from BUGGY where ('tortilla'||F2)='tortilla chip';
> PK1 0
> F1 tortilla
> F2 chip
> {code}
> But this does not:
> {code:sql}
> select * from BUGGY where (F1||F2)='tortilla chip';
> No rows selected (0.01 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
