Double Underscore Wildcard Query (Ex: 'T__ Time') Returns Unexpected Results
(Doc ID 463026.1)
Last updated on SEPTEMBER 03, 2010
Applies to:Oracle Text - Version: 10.2.0.3 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2010***
A Text (contains) query for a term with two single character wildcards such as:
returns unexpected results, for instance this row:
the time of their country
This problem occurs:
- with 'the' specified as a stopword
- prefix indexing enabled
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!