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

Symptoms

-- Problem Statement:
A Text (contains) query for a term with two single character wildcards such as:

     t__ time

(i.e. t<SingleCharacterWildcard><SingleCharacterWildcard><Space>time)

returns unexpected results, for instance this row:

   the time of their country

This problem occurs:
- with 'the' specified as a stopword
- prefix indexing enabled

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