Steve, That is a bug, can you please file a JIRA.
Thanks, Thomas On Wed, Feb 17, 2016 at 3:34 PM, Steve Terrell <[email protected]> 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
