topic Re: CMIS Query with multiple LEFT OUTER JOINs returns empty result set in Nuxeo Forum

CMIS Query with multiple LEFT OUTER JOINs returns empty result set

rg1_ — Mon, 26 Aug 2013 15:03:47 GMT

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"

Re: CMIS Query with multiple LEFT OUTER JOINs returns empty result set

Florent_Guillau — Thu, 29 Aug 2013 19:10:49 GMT

That's unexpected. Please open a ticket.

Re: CMIS Query with multiple LEFT OUTER JOINs returns empty result set

rg1_ — Thu, 29 Aug 2013 21:31:49 GMT

See [NXP-12357][1].

Re: CMIS Query with multiple LEFT OUTER JOINs returns empty result set

Florent_Guillau — Tue, 28 Jan 2014 18:28:08 GMT

Now fixed, see NXP-12357.