Complex Text Query using NOT (~) Operator and SECTION search fails with ORA-29903 DRG-50600
(Doc ID 1385849.1)
Last updated on DECEMBER 06, 2019
Applies to:
Oracle Text - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]Information in this document applies to any platform.
Symptoms
Text query using the NOT (~) operator to search in a section fields, fails with below errors:
select ... from test
where contains(dok, '((("james" within MW_PERS)
not ("james" within MW_FKT_TAL)) within MW)')>0;
...
ERROR:
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-50600: assertion failed
2586 rows selected.
where contains(dok, '((("james" within MW_PERS)
not ("james" within MW_FKT_TAL)) within MW)')>0;
...
ERROR:
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-50600: assertion failed
2586 rows selected.
Patch 10012271 does not fix the problem on 11.2
Changes
Database was upgraded from 10gR2 to 11g.
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 |