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

[BP 7.2.0 MB-53107] [N1QL] insert returning does not trigger memory quota

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 7.2.0
    • 7.1.2
    • query
    • 7.1.2-3390
    • Untriaged
    • 1
    • No

    Description

      Basically we are seeing that this insert does not trigger a memory quota exceeded

      empty bucket default

      curl -v -u Administrator:password http://172.23.104.110:8093/query/service -d 'statement=insert into default (key, value) values("1", { "abcd": { "def": repeat("abcd", 29990), "arr": array_repeat(repeat("efgh", 1000), 5000)}}) returning *&memory_quota=1'

      but if we do select * from default; where the only document is above, we are seeing the memory quota is exceeded, but the returning in insert will return the exact same document

      insert into default (key a, value v ) select a, { "abcd": { "def": repeat("abcd", 29990), "arr": array_repeat(repeat("efgh", 1000), 5000)}} as v from ["1"] as a returning abcd.def ;

      this does trigger memory quota error

      Attachments

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

        Activity

          People

            ajay.bhullar Ajay Bhullar
            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