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

ANY/ALL/FIRST/ARRAY collection operators do not allow you to reference values in the outer documents

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 3.0
    • 2.1.1
    • query
    • Security Level: Public
    • None

    Description

      This query returns 0 documents, but it should return 1 where the name matches.

      SELECT * FROM beer-sample WHERE ANY name = x OVER x IN ["21st Amendment Brewery Cafe"] END
      {
      "resultset": [
      ],
      "info": [

      { "caller": "http_response:152", "code": 100, "key": "total_rows", "message": "0" }

      ,

      { "caller": "http_response:154", "code": 101, "key": "total_elapsed_time", "message": "907.530083ms" }

      ]
      }

      Attachments

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

        Activity

          People

            iryna iryna
            mschoch Marty Schoch [X] (Inactive)
            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