Index Expressions

Post Reply
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Index Expressions

Post by MiniMe »

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:1612: 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??
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Index Expressions

Post by mark »

Sounds like you may have your minwordlen too low and are not indexing single letters. The default expression indexes 2 or more alpha numerics.
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Index Expressions

Post by MiniMe »

as an interesting side note.. if I change the query to 'moved my cheese' it works fine.. so why does 'who' break it?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Index Expressions

Post by John »

What is you suffix list? Do you have a custom thesaurus, that might see a phrase in there somewhere?
John Turnbull
Thunderstone Software
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Index Expressions

Post by MiniMe »

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 >
MiniMe
Posts: 210
Joined: Thu Mar 15, 2001 4:30 pm

Index Expressions

Post by MiniMe »

no custom thesaurus either..
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Index Expressions

Post by mark »

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".
Post Reply