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

META() in query with multiple FROM terms requires an argument

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.6.2
    • 7.6.2
    • query
    • 7.6.2-3570
    • Untriaged
    • 0
    • Yes

    Description

      During regression we are seeing many test using meta().id failing with

          "errors": [
              {
                  "code": 4310,
                  "column": 310,
                  "line": 1,
                  "msg": "META() in query with multiple FROM terms requires an argument (near line 1, column 310)." 

      Those same tests use to work before. Is this a change in behavior?

      For example, following:

      cbq> merge into default target USING [{"id":"21728", "month": 10, "year":2010, "day":25, "job":"Engineer"},{"id":"21730", "month": 7, "year":2008, "day":26, "job":"Support"}] source ON  target.job_title = source.job and target.join_day > 25 WHEN MATCHED THEN DELETE WHERE target.join_yr < 2009 LIMIT 200 RETURNING meta().id;
      {
          "requestID": "4c0d8ad1-970c-4ee9-98ec-88fe167a0ba1",
          "errors": [
              {
                  "code": 4310,
                  "column": 310,
                  "line": 1,
                  "msg": "META() in query with multiple FROM terms requires an argument (near line 1, column 310)."
              }
          ],
          "status": "fatal", 

       

      For reference http://qa.sc.couchbase.com/job/test_suite_executor-TAF/328024/consoleText

      Attachments

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

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            pierre.regazzoni Pierre Regazzoni
            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