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

[Query TAB in UI] Array fields inside a document giving warning on query page

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.0.0
    • 5.0.0
    • UI
    • 5.0.0-2652
    • Untriaged
    • No

    Description

      Example document:

      {
        "tasks": [
          {
            "Marketing": [
              {
                "region2": "International",
                "region1": "South"
              },
              {
                "region2": "South"
              }
            ],
            "Developer": [
              "IOS",
              "Indexing"
            ]
          },
          "Sales",
          "QA"
        ],
        "name": [
          {
            "FirstName": "employeefirstname-9"
          },
          {
            "MiddleName": "employeemiddlename-9"
          },
          {
            "LastName": "employeelastname-9"
          }
        ],
        "address": [
          [
            {
              "city": "Delhi"
            },
            {
              "street": "12th street"
            }
          ],
          [
            {
              "country": "EUROPE",
              "apartment": 123
            }
          ]
        ],
        "email": "9-mail@couchbase.com",
        "mutated": 0,
        "hobbies": {
          "hobby": [
            {
              "sports": [
                "Badminton",
                "Football",
                "Basketball"
              ]
            },
            {
              "dance": [
                "hip hop",
                "bollywood",
                "contemporary"
              ]
            },
            "art"
          ]
        },
        "department": "Support",
        "join_yr": [
          2013,
          2015,
          2012
        ],
        "_id": "query-testemployee10153.1877827-0",
        "VMs": [
          {
            "RAM": 10,
            "os": "ubuntu",
            "name": "vm_10",
            "memory": 10
          },
          {
            "RAM": 10,
            "os": "windows",
            "name": "vm_11",
            "memory": 10
          },
          {
            "RAM": 10,
            "os": "centos",
            "name": "vm_12",
            "memory": 10
          },
          {
            "RAM": 10,
            "os": "macos",
            "name": "vm_13",
            "memory": 10
          }
        ]
      }
      

      Example query:
      select VMs[0].os from default where _id like 'query-test%' order by _id limit 4;
      There is a warning as shown in screenshot.

      Attachments

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

        Activity

          People

            eben Eben Haber
            Prerna.Manaktala Prerna Manaktala (Inactive)
            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