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

For Dynamic index IndexProjection is empty when it uses covered index

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      create index ix1 on default(distinct pairs(self)) where type = 'user' and address.country = 'United States of America' and gender = 'M';
      explain select count(*) from default where type = 'user' and address.country = 'United States of America' and gender = 'M';
      

      Above query uses Dynamic index. The predicate is matched with index condition. So it become cover through filters. But dynamic index predicate is rewritten but Covers.Expressions() are different index projections are empty.

      Incase of array index include Primary_key

      Attachments

        Activity

          People

            Sitaram.Vemulapalli Sitaram Vemulapalli
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty