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

[CX] Confusing error message reusing variable

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 6.0.0
    • 5.5.0
    • analytics
    • Untriaged
    • Unknown
    • CX Sprint 111, CX Sprint 112

    Description

      Running

       SELECT name
      FROM customers
      WHERE rating = 
       (SELECT MAX(rating) FROM customers)
      

      yields

      [
       {
       "code": 1,
       "msg": "ASX1002: Type mismatch: function scan-collection expects its 1st input parameter to be type multiset or array, but the actual input type is object",
       "query_from_user": "SELECT name\nFROM customers\nWHERE rating = \n (SELECT MAX(rating) FROM customers);"
       }
      ]
      

      The problem is that the variable customers defined in line 2 is used in line 4.

      Attachments

        Issue Links

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

          Activity

            People

              tanzeem.ahmed Tanzeem Ahmed (Inactive)
              till Till Westmann
              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