Thunderstone Support Forums

When doing as search via vortex I am getting an error.. The search is this:

select * from books where TITLE like ` who moved my cheese '

I get this error:

!-- 115 /searchermw Query ` who moved my cheese ' would require post-processing: Index expression(s) do not match term `m' -->

and it finds 0 rows even though there are 30+ rows.. any ideas??

Sounds like you may have your minwordlen too low and are not indexing single letters. The default expression indexes 2 or more alpha numerics.

as an interesting side note.. if I change the query to 'moved my cheese' it works fine.. so why does 'who' break it?

What is you suffix list? Do you have a custom thesaurus, that might see a phrase in there somewhere?

Here is everything that precedes the select..

<$suffixlist= "'s" "'t" "'">
<apicp suffix $suffixlist>
<apicp minwordlen 2>
<$noiselist= "as" "at" "else" "for" "from" "front" "if" "in" "into" "isn't" "of" "on" "or" "per" "put" "so" "the" "their" "them">
<apicp noise $noiselist>
<apicp qminprelen 2>
<apicp "eqprefix" "">
<apicp sdexp "">
<apicp edexp "">
<sql "set keepnoise=1"></sql>
<apicp keepeqvs 0 >

no custom thesaurus either..

I get that behavior with or without the "who". With minwordlen that low you might want to turn off defsufrm to prevent "my" from becoming "m".