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

[N1QL] merge query throws an error that it didnt use to

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • None
    • 5.5.0-2730 (observed also in 5.5.0-2709)
    • Untriaged
    • Unknown

    Description

      There are two buckets with primary indexes on both buckets, backup data will be attached. 2 nodes in the cluster with data query and index services. Buckets names are default and standard_bucket0.

      This query:

      MERGE INTO default USING standard_bucket0 s0 on key "merge_delete_wherequery-testemployee13436.4244112-0" when matched then delete where s0.name LIKE "employee"

       

      Returns this:

      [
      {
      "code": 5320,
      "msg": "Multiple UPDATE/DELETE of the same document (document key 'merge_delete_wherequery-testemployee13436.4244112-0') in a MERGE statement"
      }
      ]

      Attachments

        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:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty