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

n1ql: confusing error message

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Minor
    • feature-backlog
    • 6.5.0
    • query
    • Untriaged
    • Centos 64-bit
    • Unknown

    Description

      Build: 6.5.0-4106

      I'm trying to run the following query:

      SELECT * FROM multiple_table_db_10719787_simple_table_10 a3 USE KEYS META(a3).id

      This query is invalid since the following construction: META(a3).id does not return list of ids or single id. But the corresponding error message is really confusing:

      [
      		 
       {
      		 
       "code": 3000,
      		 
       "msg": "Ambiguous reference to field a3.",
      		 
       "query": "SELECT * FROM multiple_table_db_10719787_simple_table_10 a3 USE KEYS META(a3).id"
      		 
       }
      		 
      ] 

      Attachments

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

        Activity

          People

            isha Isha Kandaswamy (Inactive)
            evgeny.makarenko Evgeny Makarenko (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