Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-11865

Potential behavioral change for ANSI MERGE statement with DELETE action

    XMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • Major
    • 7.6.1
    • Trinity, 7.6.1
    • query

    Description

      See MB-60762.

      For an ANSI MERGE statement with only DELETE option specified, our previous behavior (7.2.x and earlier) is not compliant with SQL standard. Specifically, if a target document (to be deleted) matches with multiple source documents, the SQL standard specifies that an error should be returned, but in 7.2.x we may not return an error depending on how fast the target document is deleted vs a duplicate join result (between the relevant target document and multiple source document) being generated.

      The fix for MB-60762 (in 7.6.0 and later) ensures that we now returns an error in such situations. This is for compliance with SQL standard, and should be noted in release note.

      Attachments

        Issue Links

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

          Activity

            People

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

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty