topic Re: Phrase-base searcing with PostgreSQL in Nuxeo Forum

Phrase-base searcing with PostgreSQL

seanradford — Wed, 14 Nov 2012 16:05:30 GMT

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

Re: Phrase-base searcing with PostgreSQL

Florent_Guillau — Wed, 14 Nov 2012 17:36:57 GMT

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.

Re: Phrase-base searcing with PostgreSQL

seanradford — Wed, 14 Nov 2012 23:38:42 GMT

2012-11-14 22

Re: Phrase-base searcing with PostgreSQL

Florent_Guillau — Fri, 16 Nov 2012 14:34:37 GMT

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