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

IN clause is not using IndexCountScan

    XMLWordPrintable

Details

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

    Description

      create index ix5 on default(age) where type = "user";
      explain select count(1) from default where age IN [50,60] AND type = "user";
      

      Attachments

        Activity

          People

            Prerna.Manaktala Prerna Manaktala (Inactive)
            Sitaram.Vemulapalli Sitaram Vemulapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty