As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.
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
Works on 5.9.3
Yes there have been LEFT JOIN fixes in [NXP-12357](https
