Cmis LEFT JOIN Query Nuxeo 5.9.2

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.

https://github.com/nuxeo/nuxeo-chemistry/commits/master https://github.com/nuxeo/nuxeo-chemistry/commit/fe1cf363c21fa0a9f453fc286f388e723d110d14 https://github.com/nuxeo/nuxeo-chemistry/commit/9002dab1e30a88d00421de22f6a8530449fe8e13

1 votes

1 answers

1085 views

ANSWER



Works on 5.9.3

0 votes



Yes there have been LEFT JOIN fixes in NXP-12357 but they should be in 5.9.2 already.
04/17/2014