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

[UI][QWB] advise on a query statement tries to run explain

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.0.0
    • Cheshire-Cat
    • UI
    • 7.0.0-3980
    • Untriaged
    • 1
    • Unknown

    Description

      Fresh install (kv,index,n1ql)
      no bucket
      Run this advise statement:
      ADVISE SELECT DISTINCT( bool_field1 ) FROM bucket_01 WHERE NOT ( ( bool_field1 ) ) ORDER BY bool_field1 DESC

      {
      "errors": [

      { "code": 3000, "msg": "syntax error - at ADVISE", "query_from_user": "explain ADVISE SELECT DISTINCT( bool_field1 ) FROM bucket_01 WHERE NOT ( ( bool_field1 ) ) ORDER BY bool_field1 DESC" }

      ]
      }

      It seems like the UI is trying to run an explain against this ADVISE (note this query panics see related bug MB-43239) This should be disabled correct?

      Attachments

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

        Activity

          People

            eben Eben Haber
            ajay.bhullar Ajay Bhullar
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty