Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-15907

Elasticsearch special characters in LIKE operator does not work

    XMLWordPrintable

    Details

      Description

      When using special characters in LIKE or ILIKE operator, the query does not return any results or raise invalid syntax error like:

      org.elasticsearch.action.search.SearchPhaseExecutionException: Failed to execute phase [query_fetch], all shards failed; shardFailures {[1E68CruyQISUXS4d-om-8A][nxutest][0]: SearchParseException[[nxutest][0]: from[0],size[10]: Parse Failure [Failed to parse source [{"from":0,"size":10,"query":{"regexp":{"dc:title":{"value":"File)^}{{[[])$..*1"}}},"fields":"_id"}]]]; nested: IllegalArgumentException[end-of-string expected at position 4]; }
      	at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.onFirstPhaseResult(TransportSearchTypeAction.java:276)
      	at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$3.onFailure(TransportSearchTypeAction.java:222)
      	at org.elasticsearch.search.action.SearchServiceTransportAction.sendExecuteFetch(SearchServiceTransportAction.java:307)
      	at org.elasticsearch.action.search.type.TransportSearchQueryAndFetchAction$AsyncAction.sendExecuteFirstPhase(TransportSearchQueryAndFetchAction.java:71)
      	at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:214)
      	at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$2.run(TransportSearchTypeAction.java:188)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      	at java.lang.Thread.run(Thread.java:745)
      
      

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: