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