Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-29711

Support ANSI MERGE

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 6.5.0
    • 6.5.0
    • query
    • None

    Description

      MERGE is only supported with ON KEY clause currently (similar to lookup join and index join). Since we are now supporting ANSI JOIN in Vulcan, we should also support ANSI version of MERGE, i.e., allow MERGE to have ON clause instead of ON KEY clause, such that the join between source and target of the MERGE can be done using ANSI JOIN instead of lookup join only. This will make it much easier to migrate MERGE statement from relational database to N1QL.

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              bingjie.miao Bingjie Miao
              bingjie.miao Bingjie Miao
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty