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

Add ability to limit pattern matching space to individual field names in object_paths and object_pairs_nested.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: Neo
    • Fix Version/s: Neo
    • Component/s: query
    • Story Points:
      1

      Description

      Currently when specifying the "pattern" option to these functions it is matched against the composite names.  To filter against specific individual field names requires multiple expressions to cater for all ways the field name may appear in the composite name.

      This is to add ability to limit pattern matching space to individual field names instead of the composite names.

        Attachments

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

          Activity

          Hide
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-7.1.0-1158 contains query commit 30cbf0b with commit message:
          MB-47980 Add ability to limit pattern matching space to individual field names.

          Show
          build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1158 contains query commit 30cbf0b with commit message: MB-47980 Add ability to limit pattern matching space to individual field names.
          Hide
          build-team Couchbase Build Team added a comment -

          Build couchbase-server-7.1.0-1159 contains query commit eaa90b7 with commit message:
          MB-47980 Correct option case.

          Show
          build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1159 contains query commit eaa90b7 with commit message: MB-47980 Correct option case.
          Hide
          Donald.haggart Donald Haggart added a comment - - edited

          To verify, run a statement such as:

          select object_pairs_nested(eg,{"pattern":"^c$"}) from {"a":{"b":{"c":1},"cc":2},"ccc":3} eg;

          and compare it with:

          select object_pairs_nested(eg,{"pattern":"^c$","patternspace":"field"}) from {"a":{"b":{"c":1},"cc":2},"ccc":3} eg;

          Valid values for "patternspace" are "field" and "path" [edit: was "composite" but a later change revised this] (which is the default if not specified).

          Show
          Donald.haggart Donald Haggart added a comment - - edited To verify, run a statement such as: select object_pairs_nested(eg,{"pattern":"^c$"}) from {"a":{"b":{"c":1},"cc":2},"ccc":3} eg; and compare it with: select object_pairs_nested(eg,{"pattern":"^c$","patternspace":"field"}) from {"a":{"b":{"c":1},"cc":2},"ccc":3} eg; Valid values for "patternspace" are "field" and "path"  [edit: was "composite" but a later change revised this] (which is the default if not specified).

            People

            Assignee:
            pierre.regazzoni Pierre Regazzoni
            Reporter:
            Donald.haggart Donald Haggart
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Gerrit Reviews

                There are no open Gerrit changes

                  PagerDuty