Odd errors on LIKE query

[miker]

For some reason I have a simple like query that fails with certain search words.

SQL 1>SELECT objectid,storageid FROM textrep WHERE text LIKE 'over';
115 Nothing to search for in query in the function get equivs
100 Setmmapi over Failed
100 Metamorph open failed.
objectid storageid
------------+------------+

The query actually works with other words.
SQL 1>SELECT objectid,storageid FROM textrep WHERE text LIKE 'jhkl';
objectid storageid
------------+------------+

This one intentionally does not match.

SQL 1>SELECT objectid,storageid FROM textrep WHERE text LIKE 'contamination';
objectid storageid
------------+------------+
107893 617

This one does.

Here are the columns:
NAME TBNAME TYPE SIZE ORDINAL_POSITION IDX NULLABLE SQLTYPE PRECIS LENGTH SCALE RADIX REMARK
------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+------------+
objectid textrep int 1 1 1 4 10 4 0 10
storageid textrep int 1 2 1 4 10 4 0 10
text textrep varchar 1000 3 1 -1 1000 1000 0 10

Here are the indexes:
NAME TBNAME FNAME COLLSEQ TYPE NON_UNIQUE FIELDS
------------+------------+------------+------------+------------+------------+------------+
textrep_text textrep textrep_text A F 01 text

-Michael

[mark]

"over" is a noise word. If you want to search for noise words you need to rebuild your metamorph index with "set keepnoise=1" and also "set keepnoise=1" in your search script.