LIKE problem with metamorph index

jkj2001 · Post by **jkj2001** » Wed Mar 26, 2003 5:48 pm

Hi,

I've created an index like so:

tsql "create metamorph inverted index myindex on mytable(TRIAL_EXHIBIT)"

...and can get results back when I run this command:

tsql "select count(*) from mytable where TRIAL_EXHIBIT ='None'"

...however, when I run this command:

tsql "select count(*) from mytable where TRIAL_EXH
IBIT like 'None'"

I get a message which reads:

115 Nothing to search for in query in the function get equivs
100 Setmmapi None Failed
100 Metamorph open failed.

Just in case, I dropped and recreated the index with no errors, but the same thing happened.

As an FYI, every record in the table does have "None" as the TRIAL_EXHIBIT value; not sure if that makes a difference here. We're using your NT edition, version 03.01.992447526(20010613)

doran · Post by **doran** » Wed Mar 26, 2003 9:08 pm

I think the problem is "none" is on the default noise list so it is dropped automatically and there's nothing to search for. Try the same test with a different word or edit the noise list.

Post by **Kai** » Thu Mar 27, 2003 9:53 am

Correct. You can drop all noise words (eg. have an empty list) with "set keepnoise=1", or <apicp keepnoise 1> in Vortex, before you make the index. Just make sure to have the same setting when you search with that index as well.

jkj2001 · Post by **jkj2001** » Thu Mar 27, 2003 12:17 pm

Makes sense-- thanks, guys!