Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-12203

update description for WITH Recursive's CYCLE clause

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Minor
    • None
    • 7.6.0
    • query
    • None
    • DOC-2023-S26
    • 0

    Description

      https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/with-recursive.html#cycle-clause
      Expr's description needs to be updated:

      (Required) An identifier representing field or path representing a field/nested-field.

      May be link the definition for identifier: https://docs.couchbase.com/server/7.2/n1ql/n1ql-language-reference/identifiers.html 

      And for path:https://docs.couchbase.com/server/7.2/n1ql/n1ql-language-reference/select-syntax.html#path 

      Also note:
      in 7.6.0
      Any other expression(for eg: 1+1 arithmetic expression) would be ignored

      in 7.6.2
      an error would be raised:

      "errors": [

              {

                  "code": 3307,

                  "msg": "Cycle fields validation failed for with term: <with_alias> - cause: invalid cycle field expression term: (1 + 1) only identifier/path expressions are allowed"

              }

          ]

      Attachments

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

        Activity

          People

            julia.browne Julia Browne (Inactive)
            gaurav.jayaraj Gaurav Jayaraj
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty