[jira] [Created] (PHOENIX-2689) VARCHAR Field Not Working With String Concatenation

["Steve T (JIRA)" <ji...@apache.org>]

Steve T created PHOENIX-2689:
--------------------------------

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


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)