Complex Text Query using NOT (~) Operator and SECTION search fails with ORA-29903 DRG-50600
Last updated on SEPTEMBER 11, 2013
Applies to:Oracle Text - Version 18.104.22.168 to 22.214.171.124 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Sep-2013***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms