My Oracle Support Banner

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: to - Release: 10.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2010***


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


To view full details, 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 a vibrant support community of peers and Oracle experts.