REG: Issue when querying using ilike

[Ns G]

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