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

Queries with "Is not null" and "is valued" in predicate is not using secondary indexes.

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Minor
    • feature-backlog
    • 5.5.0
    • analytics
    • 5.5.0-2268

    Description

      1. create index idx_result on ds(result:string)
      2. Run:

      • Explain select result from ds where result is valued;
      • Explain select result from ds where result is not null;

      Observe that both the queries are not using secondary indexes.

      For N1QL, "Is not null" or "is valued" uses secondary indexes.

      Attachments

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

        Activity

          People

            dmitry.lychagin Dmitry Lychagin (Inactive)
            ritesh.agarwal Ritesh Agarwal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty