Done! https://issues.apache.org/jira/browse/PHOENIX-2689
Thanks,
Steve
On Wed, Feb 17, 2016 at 5:58 PM, Thomas D'Silva <[email protected]>
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 <[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
>