hello,
We're in the process of evaluating Oracle Text search engine so far so good until yesterday when we added Synonyms to our progressive search criterion and it stop working depending on where we place the synonym search. If we place it first everything else stops working (stemming, fuzzy...) If we place it last then the synonym search stops working. I saw a reference to a bug in this conference that seemed similar to the problem, I believe it mentioned that it had been fixed in 10.2.0.3 (this is the version were on).
The following is a sample of plsql code were executing
select score(1), nm_resource, ADDR_RSRC_ST_LN_1, id_resource, ADDR_RSRC_CITY FROM caps_resource where
CONTAINS (nm_resource,
'<query>
<textquery lang="ENGLISH" grammar="CONTEXT">' || res_name ||
'<progression>
<seq><rewrite>transform((TOKENS, ?{?, ?}?, ?AND?))</rewrite></seq>
<seq><rewrite>transform((TOKENS, ??{?, ?}?, ?AND?))</rewrite>/seq>
<seq><rewrite>transform((TOKENS, ?{?, ?}?, ?OR?))</rewrite></seq>
<seq><rewrite>transform((TOKENS, ??{?, ?}?, ?OR?))</rewrite>/seq>
<seq><rewrite>transform((TOKENS, ?{?, ?}?, ?ACCUM?))</rewrite></seq>
<seq><rewrite>transform((TOKENS, ?{?, ?}?, ?NEAR?))</rewrite></seq>
<seq>' || 'SYN(' || REPLACE('' || res_name || '', ' ', ',IMPACT_tst) AND SYN(') || ',IMPACT_tst)' || '</seq>
</progression>
</textquery>
<score datatype="INTEGER" algorithm="default"/>
</query>', 1)>0