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

N1QL: Incomplete Error Msg displayed when quotes not given for a particular key in USE KEYS Array

    XMLWordPrintable

Details

    • Bug
    • Resolution: Incomplete
    • Major
    • 4.1.0
    • 4.1.0
    • query
    • Security Level: Public
    • None
    • Darwin OS
    • Untriaged
    • MacOSX 64-bit
    • Unknown

    Description

      The following query has a key not specified in double quotes in USE KEYS array:

      cbq> select * from `beer-sample` USE KEYS ["21st_amendment_brewery_cafe",512_brewing_company-512_bruin];

      {
      "requestID": "1396ec2b-07ff-4816-82df-515401d85e13",
      "errors": [

      { "code": 3000, "msg": "syntax error - at _brewing_company" }

      ],
      "status": "fatal",
      "metrics":

      { "elapsedTime": "816.536µs", "executionTime": "764.707µs", "resultCount": 0, "resultSize": 0, "errorCount": 1 }

      }

      For a smaller array of use keys the error message might be understood, but if we have a bigger collection of similar keys , then one needs to know the exact error message.
      In above scenario, error message should be:
      "msg": "syntax error - 512_at _brewing_company"

      Attachments

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

        Activity

          People

            manik Manik Taneja (Inactive)
            Prerna.Manaktala Prerna Manaktala (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