Thunderstone Support Forums

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)

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.

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.

Makes sense-- thanks, guys!