Done! https://issues.apache.org/jira/browse/PHOENIX-2689
Thanks, Steve On Wed, Feb 17, 2016 at 5:58 PM, Thomas D'Silva <tdsi...@salesforce.com> wrote: > Steve, > > That is a bug, can you please file a JIRA. > > Thanks, > Thomas > > On Wed, Feb 17, 2016 at 3:34 PM, Steve Terrell <sterr...@oculus360.us> > wrote: > > Can someone please tell me if this is a bug in Phoenix 4.6.0 ? > > > > This works as expected: > > 0: jdbc:phoenix:localhost> select * from BUGGY where > > ('tortilla'||F2)='tortillachip'; > > PK1 0 > > F1 tortilla > > F2 chip > > > > But this does not: > > 0: jdbc:phoenix:localhost> select * from BUGGY where > > (F1||F2)='tortillachip'; > > No rows selected (0.01 seconds) > > > > If it is a bug, is there a work-around? > > > > Here's how I built my table in case it's part of the problem: > > create table BUGGY (PK1 integer, F1 varchar, F2 varchar, constraint PK > > primary key (PK1)); > > upsert into BUGGY values(0, 'tortilla', 'chip'); > > > > Thank you, > > Steve >