Complex Text Query using NOT (~) Operator and SECTION search fails with ORA-29903 DRG-50600 (Doc ID 1385849.1)

Last updated on SEPTEMBER 11, 2013

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.
***Checked for relevance on 11-Sep-2013***

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.


Patch 10012271 does not fix the problem on 11.2

Changes

Database was upgraded from 10gR2 to 11g.

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