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

Use new HIERARCHY.ISVERSION column for version tests in NXQL

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.5

      Description

      In NXQL when testing ecm:isCheckedInVersion = 0 we generate:

      ... LEFT JOIN versions ON h.id = versions.id ... WHERE ...versions.id IS NULL
      

      This is costly and since NXP-5797 can be improved using the new hierarchy.isversion boolean.

        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.