Hi All, 

I am using Apache phoenix 4.3.1 version of Cloudera labs. 

I have one of the column in a table like below

Name

FUR EARMUFFS BLACK ONE V
FUR EARMUFFS BLACK ONE V
T ROSE GOLD LARIAT MULTI ONE
T ROSE GOLD LARIAT MULTI ONE
UNISEX SNUGGLER IVORY ONE NV
UNISEX SNUGGLER IVORY ONE NV

so when i query like 
 select * from table1 where Name ilike '%gold%';

I expect a resultset of 2 but I am always getting only one record as output. Is this an issue previously raised?

Thanks,
Satya