phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <tdsi...@salesforce.com>
Subject Re: Problem with String Concatenation with Fields
Date Wed, 17 Feb 2016 23:58:04 GMT
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