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

[N1QL] ANSI MERGE errors on multiple DELETE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.6.2
    • 7.6.0, 7.2.4
    • query
    • 7.6.0-2097
    • Untriaged
    • 0
    • Unknown

    Description

      default bucket with employee data
      travel-sample bucket

      Running this merge

      MERGE INTO default d USING `travel-sample`.inventory.hotel t ON t.country = d.country and any r in d.reviews satisfies r.author like 'M%' and r.ratings.Overall > 3 END WHEN MATCHED THEN DELETE WHERE d.free_parking = true

      now gives an error

      "msg": "Multiple UPDATE/DELETE of the same document (document key 'doc_10013') in a MERGE statement"

      in 7.2.x this error is not thrown.

      If the statement is run inside a transaction, then in both 7.6.0 and 7.2.x we'll get the above error.

      Backup data is attached

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              ajay.bhullar Ajay Bhullar
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty