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 188.8.131.52 to 184.108.40.206 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Text query using the NOT (~) operator to search in a section fields, fails with below errors:
where contains(dok, '((("james" within MW_PERS)
not ("james" within MW_FKT_TAL)) within MW)')>0;
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
Database was upgraded from 10gR2 to 11g.
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