Thunderstone Support Forums

It is not currently possible to enable suffix processing with LIKEIN.

I tried with tsql to create a table, index it, and query it.

create table test(x varchar(20));
insert into test values('chair');
insert into test values('e-statement');
create metamorph counter index ix2 on test(x);
set minwordlen=5;
select * from test where x likein 'chair';
select * from test where x likein 'chairs';
select * from test where x likein 'e-statement';
drop table test;

That's ok.

Is minwordlen has anything to do with why e-statement=estatement in your example but didn't work for me?

BTW, do you guys consider this as limitation of LIKEIN and would address this issue or this is something of an unique requirement that I have and I have to figure out a work-around?

Thanks, John for making sure I get an answer.

No, minwordlen was to try suffix processing, otherwise there would be no suffix processing. The lack of suffix processing with an indexed LIKEIN is something we'll need to look at and see if it was designed that way, or can be fixed.