My Oracle Support Banner

AUTO_LEXER with XMLData is not returning results but returns if using the WORLD_LEXER (Doc ID 1378269.1)

Last updated on APRIL 06, 2022

Applies to:

Oracle Text - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

The AUTO_LEXER is not returning some values after migration from WORLD_LEXER.
We have a table with a CLOB column where we store some data in XML format and we search via INPATH, ie

WHERE CONTAINS (XML,'(( (2005) INPATH(/record/extend/identifier) ))' ) > 0

For the WORDL_LEXER I get results but the AUTO_LEXER returns zero rows.


Looks clear why the INPATH in case of term '2005' and with AUTO_LEXER is not returning rows.
WORLD_LEXER is creating the tokens '2005' & 'C' when the AUTO_LEXER just only 'C-2005'.

Changes

Switching from WORLD_LEXER to AUTO_LEXER.

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.