[
https://jira.nuxeo.com/browse/NXP-8491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julien Carsique moved CMIS-54 to NXP-8491:
------------------------------------------
Nuxeo Connect support: (was: NONE)
Fix Version/s: (was: nuxeo-5.5)
5.5
Component/s: (was: CMIS)
CMIS
Affects Version/s: (was: nuxeo-5.4.2)
5.4.2
Workflow: NXP-WF (was: jira)
Key: NXP-8491 (was: CMIS-54)
Project: Nuxeo Enterprise Platform (was: Nuxeo Chemistry)
> Fix query with join and nuxeo:secondaryObjectTypeIds
> ----------------------------------------------------
>
> Key: NXP-8491
> URL: https://jira.nuxeo.com/browse/NXP-8491
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: CMIS
> Affects Versions: 5.4.2
> Reporter: Florent Guillaume
> Assignee: Florent Guillaume
> Fix For: 5.5
>
>
> This JOIN query fails:
> {noformat}
> SELECT A.cmis:objectId FROM cmis:folder A JOIN cmis:folder B ON
> A.cmis:objectId = B.cmis:parentId
> WHERE ANY A.nuxeo:secondaryObjectTypeIds NOT IN ('Foo')
> {noformat}
> with error:
> {noformat}
> Exception: org.h2.jdbc.JdbcSQLException. message: Column
> HIERARCHY.PRIMARYTYPE not found
> {noformat}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
