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

NXQL complex type clauses select only a subset of the documents

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5-SNAPSHOT
    • Fix Version/s: 5.5
    • Component/s: Core VCS

      Description

      Giving that we have a note and a file that match the following criteria:

      SELECT * from Note, File WHERE ecm:isProxy = 0 AND (dc:title = 'testfile1_Title' OR content/name = 'testfile.txt')
      

      This is returning only the file document instead of both the file and the note.

      Here is the SQL statement executed:

      SELECT DISTINCT "HIERARCHY"."ID" AS "_C1" FROM "HIERARCHY"
      LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID" 
           JOIN "HIERARCHY" "_H1" ON "HIERARCHY"."ID" = "_H1"."PARENTID" 
      LEFT JOIN "CONTENT" "_F2" ON "_H1"."ID" = "_F2"."ID"
      WHERE 
      ("HIERARCHY"."PRIMARYTYPE" IN ('File2', 'File', 'Note')
        AND ("_F1"."TITLE" = 'testfile1_Title' OR "_F2"."NAME" = 'testfile.txt'))
      AND "_H1"."NAME" = 'content'
      

        Attachments

          Issue Links

            Activity

              People

              • 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.