FUZZY with NEAR queries fails on 10.2.0.5 with Parse Error ORA-29902 ORA-20000 DRG-50901
Last updated on NOVEMBER 04, 2013
Applies to:
Oracle Text - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]Information in this document applies to any platform.
***Checked for relevance on 04-Nov-2013***
Symptoms
After upgrade from 10.2.0.3 to 10.2.0.5 FUZZY() with NEAR() queries fails with syntax parsing errors:
SQL> select * from ctxsys.ctx_version;
VER_DICT VER_CODE
---------- ----------
10.2.0.5.0 10.2.0.5.0
SQL> select id
from idu_ident_ut
where CONTAINS(nome_completo,'near((fuzzy({Ricardo},66,,W)=Ricardo, fuzzy({miguel},66,,W)=miguel), 20, true)') > 0;
select id
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 7
VER_DICT VER_CODE
---------- ----------
10.2.0.5.0 10.2.0.5.0
SQL> select id
from idu_ident_ut
where CONTAINS(nome_completo,'near((fuzzy({Ricardo},66,,W)=Ricardo, fuzzy({miguel},66,,W)=miguel), 20, true)') > 0;
select id
*
ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 7
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms