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

[BP:MB-36198]Query: Advise function confusing message

    XMLWordPrintable

Details

    • Triaged
    • 1
    • Unknown

    Description

      Build 6.5.0-4380

      Steps to reproduce:

      1. Load standard `beer-sample` bucket.
      2. Runt the following query 

       

      select count from `beer-sample`

       

      this will be executed successfully.

      Now run this:

       

      advise select count from `beer-sample`

       

      and response will be this:

       

      [
      {
      "#operator": "Advise",
      "advice": {
      "#operator": "IndexAdvice",
      "adviseinfo": [
      {| |"recommended_indexes": "No index recommendation at this time: no keyspace found."| |}
      ]
      },
      "query": "select count from `beer-sample`"
      }
      ]

       

      Here is the question: which keyspace is not found?

      Same actions for build 6.5.0-4349 give this advise response:

       

      [
      {
      "#operator": "Advise",
      "advice": {
      "#operator": "IndexAdvice",
      "adviseinfo": [
      {| |"recommended_indexes": "No index recommendation at this time."| |}
      ]
      },
      "query": "select count from `beer-sample`"
      }
      ]

      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
              kamini.jagtiani Kamini Jagtiani
              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