[
https://jira.nuxeo.org/browse/CMIS-19?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Florent Guillaume resolved CMIS-19.
-----------------------------------
Resolution: Fixed
Fixed.
http://hg.nuxeo.org/addons/nuxeo-chemistry/rev/11548c0c71fc
> 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
