Fix query with join and nuxeo:secondaryObjectTypeIds

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')

Exception: org.h2.jdbc.JdbcSQLException. message: Column HIERARCHY.PRIMARYTYPE not found