Phrase-base searcing with PostgreSQL
I have a new clean 5.5 install running against a PostgreSQL 9.1 and phrase-based searching is not working.
For example if I enter “data migration” (with the double-quotes) I get documents with the words data AND migration no matter where in the document they are, i.e the same as using data migration with no enclosing double-quotes. I have tried in the quick-search, the advanced search and using the Administrator nxql search.
NXP-6720 states that it should work…. https://jira.nuxeo.com/browse/NXP-6720
(the query looks the same for both simple and phrase based searching)
data migration, not
"data migration"with quotes, because if it was the query would contain something like:
_nxquery @@ NX_TO_TSVECTOR("fulltext"."fulltext") AND "fulltext"."fulltext" LIKE '% data migration %'
So something strips your double quotes. It may have been a bug in Nuxeo 5.5, I don't remember. Could you check with Nuxeo 5.6 please?