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

QWB: Not picking up full text of advise statement under certain conditions

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      Build 4429

       

      As per some recent changes in https://issues.couchbase.com/browse/MB-34548, the advise statement is now returning a bit more information when no indexes can be recommended.  However, the QWB isn't showing this full information when pressing the "Advise" button:

      1) "select * from default"

      Manual advise output:

      [
        {
          "#operator": "Advise",
          "advice": {
            "#operator": "IndexAdvice",
            "adviseinfo": [
              {
                "recommended_indexes": "No secondary index recommendation at this time, primary index may apply."
              }
            ]
          },
          "query": "select * from `default`;"
        }
      ]
      

       QWB output from Advise button:
      "No index recommendation at this time." (missing "primary index may apply"). We might also consider changing the color from green to yellow/orange since this wouldn't be considered a "successful" recommendation

      2) "select * from non_bucket" (where the bucket/keyspace doesn't exist)
      Manual advise output:

      [
        {
          "#operator": "Advise",
          "advice": {
            "#operator": "IndexAdvice",
            "adviseinfo": [
              {
                "recommended_indexes": "No index recommendation at this time: no keyspace found."
              }
            ]
          },
          "query": "select id from test where id = 5;"
        }
      ]
      

      QWB output:
       QWB output from Advise button:
      "No index recommendation at this time." (missing "no keyspace found"). We might also consider changing the color from green to yellow/orange since this wouldn't be considered a "successful" recommendation

      Attachments

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

        Activity

          People

            eben Eben Haber
            perry Perry Krug
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty