My Oracle Support Banner

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

Last updated on FEBRUARY 24, 2019

Applies to:

Oracle Text - Version 10.2.0.1 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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.