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

Add LEN() general purpose length function.

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: Neo
    • Fix Version/s: Neo
    • Component/s: query
    • Labels:
      None
    • Story Points:
      1

      Description

      Add function OBJECT_COUNT(a) counts number returns number of fields in the object

      https://forums.couchbase.com/t/how-to-count-number-of-objects-in-subdocument-using-n1ql-query/31482

        Attachments

          Issue Links

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

            Activity

            Hide
            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment -

            Synonym to OBJECT_LENGTH()

            Show
            Sitaram.Vemulapalli Sitaram Vemulapalli added a comment - Synonym to OBJECT_LENGTH()
            Hide
            Donald.haggart Donald Haggart added a comment -

            LEN() is the general-purpose length function.

            Show
            Donald.haggart Donald Haggart added a comment - LEN() is the general-purpose length function.
            Hide
            Donald.haggart Donald Haggart added a comment -

            To verify, issue SQL using the function passing in different types, e.g.

            SELECT LEN(100.54), LEN("Hello world"), LEN({"one":1,"two":2}),LEN([0,1,2,3,4,5,6,7,8,9]),LEN(true),LEN(false),LEN(NULL),LEN(MISSING);

            Show
            Donald.haggart Donald Haggart added a comment - To verify, issue SQL using the function passing in different types, e.g. SELECT LEN( 100.54 ), LEN( "Hello world" ), LEN({ "one" : 1 , "two" : 2 }),LEN([ 0 , 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 ]),LEN( true ),LEN( false ),LEN(NULL),LEN(MISSING);
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.1.0-1439 contains query commit 61a002b with commit message:
            MB-48027 Add LEN() function as a general-purpose length function

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1439 contains query commit 61a002b with commit message: MB-48027 Add LEN() function as a general-purpose length function
            Hide
            build-team Couchbase Build Team added a comment -

            Build couchbase-server-7.1.0-1445 contains query commit 380bd68 with commit message:
            MB-48027. Fix test

            Show
            build-team Couchbase Build Team added a comment - Build couchbase-server-7.1.0-1445 contains query commit 380bd68 with commit message: MB-48027 . Fix test

              People

              Assignee:
              pierre.regazzoni Pierre Regazzoni
              Reporter:
              Sitaram.Vemulapalli Sitaram Vemulapalli
              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