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

[CX] Need to document Difference in syntax of array in n1ql vs SQL++

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • CBAS DP
    • feature-backlog
    • analytics
    • Untriaged
    • Unknown

    Description

      N1QL QUERY:

      SELECT ARRAY vm.memory FOR vm IN VMs END AS vm_memories FROM default_shadow WHERE VMs IS NOT NULL ;

      SQL++
      SELECT (SELECT VALUE vm.memory FROM VMs AS vm) AS vm_memories FROM default_shadow WHERE VMs IS NOT NULL ;

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. MB-21119 [CX] N1QL queries with end keyword work fine in SQL++ without end keyword

          • Major - Major loss of function.
          • Resolved
          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              will.gardella Will Gardella (Inactive)
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty