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

Delete query failing if using secondary indexes - "DELETE alias collection1 not found in item"

    XMLWordPrintable

Details

    Description

      Build : 7.1.0-2469
      Last known good build : 7.1.0-2464

      Steps to reproduce :
      1. Setup a 1-node cluster with kv, index and query services.
      2. Create a bucket, scope and collection - bucket1.scope1.collection1
      3. Insert 1 doc -

      insert into default:bucket1.scope1.collection1 (KEY, VALUE) VALUES ('doc1', {'val':1})
      

      4. Create secondary index -

      create index idx_val on default:bucket1.scope1.collection1(val)


      5. Now delete doc

      delete from default:bucket1.scope1.collection1 where val=1

      This fails with error :

      [
        {
          "code": 5080,
          "msg": "DELETE alias collection1 not found in item."
        }
      ]

      6. Now drop the secondary index and create a primary index on the collection

      create primary index on default:bucket1.scope1.collection1


      7. Re-run the delete doc query. It works this time

      delete from default:bucket1.scope1.collection1 where val=1

      This is a regression caused due to the following commit :

      • Commit: 697693d701e4ff0726b71d5e2f8cbf232761667a in build: couchbase-server-7.1.0-2469
        MB-51372 Break circular references for recursive functions.

      Change-Id: I3a52ffbde01f27fd1a51e66df07f68a7b407a85a
      Reviewed-on: https://review.couchbase.org/c/query/+/172070
      Reviewed-by: Sitaram Vemulapalli <sitaram.vemulapalli@couchbase.com>
      Reviewed-by: Marco Greco <marco.greco@couchbase.com>
      Tested-by: Donald Haggart <donald.haggart@couchbase.com>
      Author: dhaggart <donald.haggart@couchbase.com>
      Committer: Donald Haggart <donald.haggart@couchbase.com>

      Attachments

        Issue Links

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

          Activity

            People

              pierre.regazzoni Pierre Regazzoni
              mihir.kamdar Mihir Kamdar (Inactive)
              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