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

Remove empty Sequence in DELETE plan

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 4.5.0
    • 4.5.0
    • query
    • None
    • Untriaged
    • Unknown

    Description

      The following statement generates an empty Sequence that should be removed:

      explain delete from `beer-sample` limit 5;

      {
      "requestID": "ee4f83b9-1c73-4582-80a1-4180ac2ffc1f",
      "signature": "json",
      "results": [
      {
      "plan": {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "IndexScan",
      "covers": [
      "cover ((meta(`beer-sample`).`id`))"
      ],
      "index": "#primary",
      "index_id": "ba960459e5f2ed75",
      "keyspace": "beer-sample",
      "limit": "5",
      "namespace": "default",
      "spans": [
      {
      "Range":

      { "Inclusion": 0, "Low": [ "null" ] }

      }
      ],
      "using": "gsi"
      },
      {
      "#operator": "Sequence",
      "~children": [
      {
      "#operator": "Parallel",
      "~child":

      { "#operator": "Sequence", "~children": [] }

      },

      { "#operator": "Limit", "expr": "5" }

      ,
      {
      "#operator": "Parallel",
      "~child": {
      "#operator": "Sequence",
      "~children": [

      { "#operator": "SendDelete", "alias": "beer-sample", "keyspace": "beer-sample", "limit": "5", "namespace": "default" }

      ]
      }
      }
      ]
      },

      { "#operator": "Discard" }

      ]
      },
      "text": "delete from `beer-sample` limit 5"
      }
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "1.157163ms", "executionTime": "1.124308ms", "resultCount": 1, "resultSize": 2557 }

      }

      Attachments

        For Gerrit Dashboard: MB-19451
        # Subject Branch Project Status CR V

        Activity

          People

            ajay.bhullar Ajay Bhullar
            gerald Gerald Sangudi (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