Cmis LEFT JOIN Query Nuxeo 5.9.2

Rafael_Bueno — Tue, 25 Mar 2014 18:37:01 GMT

Scenario:

1 - Create two Files.

2 - Create a Note.

3 - Create a Relation using File and Note.

4 - Want Return all files in a LEFT JOIN Query with Notes.

SELECT F.* FROM File F 
LEFT JOIN Relation R ON R.cmis:sourceId = F.cmis:objectId

Expected:

All Files include the files that doent have Relation with Note.

Problem:

A message "connection: Parsing Exception!" appears on Workbench Cmis after execute the query.

Google Search:

I updated the Nuxeo because I saw on github that the new version solved the left join query.

Re: Cmis LEFT JOIN Query Nuxeo 5.9.2

Rafael_Bueno — Thu, 17 Apr 2014 07:18:09 GMT

Works on 5.9.3

Florent_Guillau — Thu, 17 Apr 2014 21:05:18 GMT

Yes there have been LEFT JOIN fixes in [NXP-12357](https