Fix ES reindex using NXQL

Using
Date-based 9.3 (2017-11-16)
Windows 10
Chrome
JSF UI
Redis
MongoDB

• Create two workspaces under default-domain
• Bananas containing a file called "Potatoes"
• Strawberries containing a file called "Forever"

• Using curl, launch curl -X DELETE "http://localhost:9200/nuxeo"
• Go to search tab in JSF UI and notice that it produces an error

Using BDE

• Reindex ES using the following NXQL

  SELECT * FROM Document WHERE ecm:path STARTSWITH "default-domain/workspaces/Bananas"

• BDE says success
• Go to search tab

=> error is still present
=> alternatively, the problem can be checked using a REST API query: http://localhost:8080/nuxeo/site/api/v1/query?query=SELECT%20*%20FROM%20Document%20WHERE%20dc%3Atitle%20LIKE%20%22Bananas%22 returns no result

Expected: ES should have been reindexed

Notes:

• Triggering a NXQL reindex from the admin center provides the same result
• This behavior cannot be reproduced on a LTS 2016 with h2 under linux