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

let clause does not use qualified index

    XMLWordPrintable

Details

    • Bug
    • Resolution: User Error
    • Major
    • 6.5.0
    • 6.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      create default bucket

      create only the following indexes:

      create index idx1 on default(field1)

      create index idx2 on default(log(field1)

      run the following queries:

      select a from default let a=field1

      select a from default let a=log(field1)

      you will get back this error:

      "No index available on keyspace simple_table_db_52119513_simple_table that matches your query. Use CREATE INDEX or CREATE PRIMARY INDEX to create an index, or check that your expected index is online."

      Attachments

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

        Activity

          People

            keshav Keshav Murthy
            korrigan.clark Korrigan Clark (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