FUZZY with NEAR queries fails on 10.2.0.5 with Parse Error ORA-29902 ORA-20000 DRG-50901
(Doc ID 1367462.1)
Last updated on FEBRUARY 24, 2019
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.
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 <TABLE_NAME>
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 <TABLE_NAME>
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |