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

[ADVISE] using advise on an query that has USE index keyword returns incorrect error

    XMLWordPrintable

Details

    • Triaged
    • Unknown

    Description

      Create a bucket bucket0

      Run this query:
      advise select id,url,address,title,city,name,country,public_likes from bucket0 use index (def_primary) where some p in public_likes satisfies p like "Ge%" END AND type = "hotel" order by id, url, address, title, city DESC, name, country

      No index recommendation at this time: no keyspace found.

      You will get an error that there is no keyspace, this isn't very clear as the issue is that you have the use index keyword, the keyspace itself exists.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty