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”