-
Type: Bug
-
Status: Resolved
-
Priority: Major
-
Resolution: Won't Fix
-
Affects Version/s: 10.10
-
Fix Version/s: None
-
Component/s: Elasticsearch, Query & PageProvider
-
Tags:
-
Backlog priority:500
-
Sprint:nxplatform next
It is not possible to escape the "*" wildcard character in Elasticsearch-enabled NXQL queries, making it impossible to make specific MatchPhrasePrefix queries on terms that use the character.
Steps to reproduce:
- Configure ES indexing to enable ILIKE queries on some test field (e.g. dc:title, or a String field from a custom schema)
- Add nxql_search to the list of page providers in elasticsearch.override.pageproviders in nuxeo.conf
- After starting nuxeo, create a set of documents with varying values for the term:
-TestWild
-TestWild* - Add the following term to the query (attempting to escape '*' character) and run search:
AND [testproperty] ILIKE 'TestWild\\*'
Expected Result:
Query returns one result with 'TestWild*' value
Actual Result:
Query returns all entries beginning with 'TestWild', as if '*' character was not escaped