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

NOT IN/ WITHIN queries should able to use secondary index

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 5.0.0
    • query
    • None

    Description

      The following variations of queries not able to use secondary index.

      create index ix22 on default(a);
      explain select 1 from default where NOT (a IN [ 1]);
      explain select 1 from default where NOT (a WITHIN [ 1]);
      explain select 1 from default where a NOT WITHIN [ 1];
      explain select 1 from default where a NOT IN [ 1];
      {
      "requestID": "b6ac5dc0-5b3b-4a79-a681-3fe324981453",
      "errors": [

      { "code": 4000, "msg": "No index available on keyspace default that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online." }

      ],
      "status": "fatal",
      "metrics":

      { "elapsedTime": "1.36388ms", "executionTime": "1.345888ms", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      Attachments

        Issue Links

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

          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