Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-8491

Fix query with join and nuxeo:secondaryObjectTypeIds

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4.2
    • Fix Version/s: 5.5
    • Component/s: CMIS

      Description

      This JOIN query fails:

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

      with error:

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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                fguillaume Florent Guillaume
                Reporter:
                fguillaume Florent Guillaume
                Participants:
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.