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

Fix CMIS qualifier-related query issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8
    • Fix Version/s: 5.8.0-HF04, 5.9.1
    • Component/s: CMIS

      Description

      These CMISQL queries fail to generate proper SQL:

      SELECT A.cmis:objectId FROM cmis:document A WHERE A.dc:subjects IS NULL;
SELECT A.cmis:objectId FROM cmis:document A WHERE ANY A.dc:subjects IN ('foo')";

      Also this may be evaluated with the wrong qualifier depending in the order if there is a JOIN:

      'foo' = ANY A.nuxeo:secondaryObjectTypeIds

        Attachments

          Issue Links

          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-12357 CMIS Query with multiple LEFT OUTER JOINs returns empty result set

          • Major - Major loss of function.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: