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

            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