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 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.
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