CONTAINS Query of Un-Escaped Wildcard With Special Symbol Like CONTAINS(<indexed_col>,'\*%') Does Not Return Any Row (Doc ID 1336438.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Text - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

The following query:

select * from quick where contains(text,'\*%') > 0;

Returns rows in 11.1.0.7:

SQL> select version from v$instance;

VERSION
-----------------
11.1.0.7.0

SQL> select * from quick where contains(text,'\*%') > 0;

QUICK_ID TEXT
-------- --------------------------------------------------
       1 The cat sat on the mat
       2 The quick brown fox jumps over the lazy dog


But does not return any row in 11.2.0.2:

SQL> select version from v$instance;

VERSION
-----------------
11.2.0.2.0

SQL> select * from quick where contains(text,'\*%') > 0;

no rows selected



Changes

Database was upgraded to 11.2.0.2.

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