Fulltext queries incorrectly translated using PostgreSQL
--------------------------------------------------------
Key: CMIS-19
URL: https://jira.nuxeo.org/browse/CMIS-19
Project: Nuxeo Chemistry
Issue Type: Bug
Reporter: Florent Guillaume
Assignee: Florent Guillaume
Priority: Major
When doing:
SELECT cmis:objectId, cmis:name FROM cmis:document WHERE
contains('whitepaper')
Using the PostgreSQL dialect the query maker translates this to:
SELECT "hierarchy"."id", "hierarchy"."name", "hierarchy"."primarytype" FROM
"hierarchy" LEFT JOIN "misc" ON "misc"."id" = "hierarchy"."id" WHERE
"hierarchy"."primarytype" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) AND
"misc"."lifecyclestate" <> $12 AND (NX_CONTAINS("fulltext"."fulltext", $13))
This is incorrect, there is a reference to the fulltext table but it is not
JOINed.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
