Uploaded image for project: 'Alfresco One Platform'
  1. Alfresco One Platform
  2. ACE-5750

Wrong results are returned for CMIS queries with string comparison

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a bug
    • Affects Version/s: 5.2
    • Fix Version/s: None
    • Labels:
      None
    • Environment:

      Description

      Steps to reproduce:

      1. Upload tas-model.xml to Allfresco in Data Dictionary -> Models.
      2. Create the following documents with 'D:tas:document' type:
      guestc.txt
      restc.txt
      tesc.txt
      testtttc.txt
      testc.txt
      testc1.txt
      testc2.txt
      testc3.txt

      3. Execute the following queries:

      SELECT * FROM tas:document where cmis:name < 'testc.txt'
      Expected results: 3 (restc.txt, guestc.txt, tesc.txt)
      Actual results: 6 (guestc.txt, restc.txt, tesc.txt, testc1.txt, testc2.txt, testc3.txt)

      SELECT * FROM tas:document where cmis:name <= 'testc.txt'
      Expected results: 4 (restc.txt, guestc.txt, tesc.txt, testc.txt)
      Actual results: 7 (guestc.txt, restc.txt, tesc.txt, testc.txt, testc1.txt, testc2.txt, testc3.txt

      SELECT * FROM tas:document where cmis:name > 'testc.txt'
      Expected results: 4 (testc1.txt, testc2.txt, testtttc.txt, testc3.txt)
      Actual results: 1 (testtttc.txt)

      SELECT * FROM tas:document where cmis:name >= 'testc.txt'
      Expected results: 5 ( testc.txt, testc1.txt, testc2.txt, testtttc.txt, testc3.txt)
      Actual results: 2 (testtttc.txt, testc.txt)

      Note:
      The reported behavior is encountered only on Stack 2 environment:
      RHEL 7.2 x64
      PostgreSQL 9.4.4
      Tomcat 7.0.59
      Oracle JDK 1.8.0_111

        Attachments

          Activity

            People

            • Assignee:
              closedissues Closed Issues
              Reporter:
              mchitan Mihaela Chitan [X] (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: