phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Terrell <sterr...@oculus360.us>
Subject Re: Problem with String Concatenation with Fields
Date Thu, 18 Feb 2016 00:43:30 GMT
Done!  https://issues.apache.org/jira/browse/PHOENIX-2689

Thanks,
    Steve

On Wed, Feb 17, 2016 at 5:58 PM, Thomas D'Silva <tdsilva@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 <sterrell@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
>

Mime
View raw message