ntBaseLucene index

Hi,

We are using search by fileName.

Example:

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%\_us'

Explain query display WARNINGThis query has characteristics that may cause performance issues when executed against large repositories.

I've adjusted ntBaseLucene index (Add indexNodeName= true on /oak:index/ntBaseLucene/indexRules/nt:base node.Using Oak Utilities : Index Definition Generator.

After such change:

+ Warning disappear and query is much faster

- Query stopping return results with escaping

Example:

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%\_us'

Return: No results.

SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE('/etc/project/test') AND NAME() LIKE '%_us'

Return: /etc/project/test/en_us

Does anyone know what's wrong here?

We are using AEM6.1 with SP1. OAK version 1.2.11

Thanks,

Alex