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

[N1QL] n1ql query sometimes selects different indexes

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.5.1, 7.0.0
    • 6.5.1, Cheshire-Cat
    • query
    • 7.0.0-1336
    • Untriaged
    • Unknown

    Description

      Very similar scenario to MB-31203

      Create default bucket

      Insert docs like the following:

      {a:100, d:200}

      create 2 indexes:

      create index idx1 on default(a);
      create index idx2 on default(a,d);

      run queries:

      explain select * from default where a > 0;

      Sometimes idx1 is picked up, sometimes idx2 is picked up, however we should expect it to always pickup idx1 right? Will check if this problem also exists in 6.5.1

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              ajay.bhullar Ajay Bhullar
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty