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

items are not updated in merge query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Blocker
    • cbq-beta, 4.0.0
    • cbq-DP4, 4.0.0
    • query
    • Security Level: Public
    • Untriaged
    • Unknown

    Description

      items are not updated in merge query
      cbq> select meta(b0).id, click from b0 ;
      {
      "request_id": "6315dc36-691e-467c-baa2-941afd277048",
      "signature":

      { "click": "json", "id": "json" }

      ,
      "results": [

      { "click": "to edit", "id": "d1" }

      ,

      { "click": "to edit", "id": "d2" }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "8.628ms", "executionTime": "8.503ms", "resultCount": 2, "resultSize": 132 }

      }

      cbq> select meta(b1).id, click from b1 ;
      {
      "request_id": "a0c5b802-a274-4361-b2c2-bfd7d4ee5771",
      "signature":

      { "click": "json", "id": "json" }

      ,
      "results": [

      { "click": "to edit", "id": "d0" }

      ,

      { "click": "to edit", "id": "d1" }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "6.653ms", "executionTime": "6.534ms", "resultCount": 2, "resultSize": 132 }

      }

      cbq> merge into b0 using b1 on key "d1" when matched then update set b0.click='abc';

      {
      "request_id": "00e61c66-1c52-46e0-85f2-467800db4924",
      "signature": null,
      "results": [
      ]
      "errors": [

      { "code": 5000, "msg": "Failed to perform update - cause: MCResponse status=KEY_ENOENT, opcode=GET, opaque=0, msg: Not found" }

      ],
      "status": "errors",
      "metrics":

      { "elapsedTime": "10.622ms", "executionTime": "10.501ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      cbq> select meta(b0).id, click from b0 ;
      {
      "request_id": "ca2f9d20-a8e7-4c34-b5ad-54bf55e18b4b",
      "signature":

      { "click": "json", "id": "json" }

      ,
      "results": [

      { "click": "to edit", "id": "d1" }

      ,

      { "click": "to edit", "id": "d2" }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "8.28ms", "executionTime": "8.151ms", "resultCount": 2, "resultSize": 132 }

      }

      cbq> select meta(b1).id, click from b1 ;
      {
      "request_id": "1dd1c01e-f1af-4958-afcf-4f5f0f37ccf0",
      "signature":

      { "click": "json", "id": "json" }

      ,
      "results": [

      { "click": "to edit", "id": "d0" }

      ,

      { "click": "to edit", "id": "d1" }

      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "5.797ms", "executionTime": "5.69ms", "resultCount": 2, "resultSize": 132 }

      }

      Attachments

        Activity

          People

            gerald Gerald Sangudi (Inactive)
            iryna iryna
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 8h
                8h
                Logged:
                Time Spent - Not Specified
                Not Specified

                PagerDuty