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 to [Release 11.1 to 11.2]
Information in this document applies to any platform.


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


Switching from WORLD_LEXER to AUTO_LEXER.


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

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