Phrase-base searcing with PostgreSQL

[seanradford]

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

Any ideas?

Thanks,

Sean

[Florent_Guillau]

Could you activate debugging for the VCS queries and check what is executed? Set log category org.nuxeo.ecm.core.storage.sql.jdbc to TRACE.

[seanradford]

2012-11-14 22

[Florent_Guillau]

The logged query is the execution of just data migration, not "data migration" with quotes, because if it was the query would contain something like