phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Terrell <sterr...@oculus360.us>
Subject Problem with String Concatenation with Fields
Date Wed, 17 Feb 2016 23:34:28 GMT
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