CMIS Query with multiple LEFT OUTER JOINs returns empty result set

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”

0 votes

1 answers

1627 views

ANSWER

That's unexpected. Please open a ticket.
08/29/2013

rg1
08/29/2013



Now fixed, see NXP-12357.

0 votes