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

Update and delete queries not picking up array indexes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 5.5.0
    • query
    • Untriaged
    • Centos 64-bit
    • Yes

    Description

      Version: 5.1.0-1511 

      test: tuqquery/tuq_2i_index.py test_array_index_delete 

      Run the test conf: python testrunner.py -i /Users/korrigan.clark/Desktop/resources/vagrant-2.ini -c conf/tuq/py-tuq-arrayindexing.conf -p doc-per-day=6,primary_indx_type=GSI,array_indexing=True 

      The test has two indexes: primary and arraydel_idx 

      CREATE INDEX array_delidx ON default( DISTINCT ARRAY v FOR v in join_yr END) USING gsi 

      Then run: 
      EXPLAIN delete from default where any v in join_yr SATISFIES v=2012 end LIMIT 1 

      This will show PrimaryScan when DistinctScan is expected. 

      You can run: 

      EXPLAIN select * from default where any v in join_yr SATISFIES v=2012 end LIMIT 1 

      and you will see that DistinctScan is occuring

      Attachments

        Issue Links

          For Gerrit Dashboard: MB-27188
          # Subject Branch Project Status CR V

          Activity

            People

              korrigan.clark Korrigan Clark (Inactive)
              korrigan.clark Korrigan Clark (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty