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

Implement CMISQL on top of NXQL

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0
    • Component/s: CMIS, Core MongoDB
    • Epic Link:
    • Tags:
    • Impact type:
      Configuration Change
    • Upgrade notes:
      Hide

      CMISQL to NXQL translation (and therefore no JOINs) is enabled by default.

      To re-enable the previous mode allowing JOINs and using VCS, set the following property in nuxeo.conf:

      org.nuxeo.cmis.joins=true

      Show
      CMISQL to NXQL translation (and therefore no JOINs) is enabled by default. To re-enable the previous mode allowing JOINs and using VCS, set the following property in nuxeo.conf: org.nuxeo.cmis.joins=true
    • Sprint:
      Sprint RepoTeam 5.9.5-2

      Description

      Today CMISQL is translated directly into SQL.

      It would be better to translate to NXQL, because this would allow other query backends like Elasticsearch or MongoDB to take advantage of it.

      Of course this would prevent some queries to be executable, for instance JOINs are not possible in NXQL (and neither in Elasticsearch or MongoDB so it's not really a loss).

      We'll keep the possibility to use the current CMISQLQueryMaker translating to SQL for those that really needs CMISQL JOINs.

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-11617 Apply security policies not just for NXQL (CMISQL)

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-15076 Fix NXQL ecm:isLatestVersion = 0 and ecm:isLatestMajorVersion = 0

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. NXP-15078 NXQL query by ancestor id

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          New Feature - A new feature of the product, which has yet to be developed. NXP-15083 Explicit fulltext score in NXQL

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-16573 Fix CMISQL/NXQL iterator re-acquisition

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-14005 CMISQL should support PostgreSQL arrays

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. NXP-17313 Allow proxies to be visible through CMIS

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 week
                  1w
                  Remaining:
                  Remaining Estimate - 3 hours, 30 minutes
                  3h 30m
                  Logged:
                  Time Spent - Not Specified Time Not Required
                  Not Specified