[ 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