Inconsistent result using WORLD_LEXER and searching for a text long more then 42 characters (Doc ID 1364314.1)

Last updated on OCTOBER 11, 2011

Applies to:

Oracle Text - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

You are using an Oracle TEXT query searching for a long text more then 42 characters and you get inconsistent results.

Example:

CREATE TABLE items (id number, doc varchar2(1000));
INSERT INTO items
  VALUES (1, '0123456789.0123456789.0123456789.012345678XYZW');
COMMIT;

exec ctx_ddl.create_preference('my_lexer','WORLD_LEXER');

CREATE INDEX items_indx
  ON items(doc)
  INDEXTYPE IS CTXSYS.CONTEXT
  PARAMETERS('lexer my_lexer');
 

SQL> SELECT id FROM items WHERE CONTAINS(doc, '0123456789.0123456789.0123456789.012345678AAA') >0;

       ID
---------
        1


SQL> SELECT id FROM items WHERE CONTAINS(doc, '%X%')>0;

no rows selected

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