As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
When I invoke the following CMIS Query that contains multiple LEFT OUTER JOINs to both File and Note against the Nuxeo Demo server, no results are returned. OTOH, when I invoke separate queries with a single LEFT OUTER JOIN to File and Note respectively, results are returned as expected. Am I correct that this is a nuxeo-chemistry bug?
Query:
curl -u Administrator:Administrator "http://demo.nuxeo.com/nuxeo/atom/cmis/default/query?q=SELECT+d.*+FROM+cmis:document+d+LEFT+OUTER+JOIN+File+f+ON+d.cmis:objectId=f.cmis:objectId+LEFT+OUTER+JOIN+Note+n+ON+d.cmis:objectId=n.cmis:objectId+WHERE+d.nuxeo:isVersion=false&searchAllVersions=true&includeRelationships=none"
That's unexpected. Please open a ticket.
See [NXP-12357][1].
Now fixed, see NXP-12357.
