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

Scans with IN operator in the query predicate not using the secondary index

    XMLWordPrintable

Details

    • Untriaged
    • 1
    • Yes
    • CX Sprint 196

    Description

      Setup :
      1. 1-node cluster with data & analytics service
      2. Default bucket loaded with cbworkloadgen data - 1000 docs.
      3. Create an analytics dataset and secondary index -
      create dataset default_ds on default
      create index default_idx1 on default_ds(name:STRING, age:BIGINT)
      4. Connect link Local
      5. Run query -
      select * from default_ds where age=70 and name in ["pymc171","pymc272"]
      6. Check the plan - default_idx1 should be used in the plan

      With 6.0.4, default_idx1 is used. But in 6.5.1-6298, default_idx1 is not used. Results are the same in both. Attached are the execution plans from 6.0.4 & 6.5.1.

      Attachments

        1. 604_plan.txt
          10 kB
        2. 650_plan.txt
          11 kB
        3. 651_plan.txt
          8 kB

        Issue Links

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

          Activity

            People

              dmitry.lychagin Dmitry Lychagin (Inactive)
              mihir.kamdar Mihir Kamdar (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