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

Possible incorrect results from OBJECT_ functions

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 7.2.0
    • 7.1.4, 7.1.3
    • query
    • Security Level: Public
    • Untriaged
    • 0
    • Unknown

    Description

      SELECT COUNT(1)
      FROM OBJECT TO_STR(pos): {"a": OBJECT TO_STR(pos2): {"c":v} FOR pos2:v1 IN ARRAY_RANGE(0,50) END} FOR pos:v IN ARRAY_RANGE(0,50) END AS d
      UNNEST OBJECT_VALUES(d) AS u1
      UNNEST OBJECT_VALUES(u1.a) AS u2
      UNNEST OBJECT_NAMES(d) AS u3;

      It suppose to give 125000 (50*50*50)

      each time gives random value

      Attachments

        Activity

          People

            pierre.regazzoni Pierre Regazzoni
            hitesh.walia Hitesh Walia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              PagerDuty