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

Optimize MIN aggregate without group by when KeyPos > 0

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 5.5.0
    • 6.5.0
    • secondary-index
    • None
    • Untriaged
    • No

    Description

      This is an extension of Bug MB-27861 to optimize MIN aggregate without GROUP BY. As of vulcan, we want to handle optimization only for keyPos = 0 to avoid corner cases and regressions. It would be good to do the full optimization for KeyPos > 0 in mad-hatter.

      Attachments

        Issue Links

          relates to

          Improvement - An improvement or enhancement to an existing feature or task. MB-30871 MAX queries can be further optimized

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

          Activity

            Ascending order - Click to sort in descending order
            prathibha Prathibha Bisarahalli (Inactive) created issue -
            jeelan.poola Jeelan Poola made changes -
            Field Original Value New Value
            Link This issue relates to MB-30871 [ MB-30871 ]
            jeelan.poola Jeelan Poola made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Resolved [ 5 ]
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Labels request-dev-verify
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Description This is an extension of Bug MB-27861 to optimize MIN aggregate with GROUP BY. As of vulcan, we want to handle optimization only for keyPos = 0 to avoid corner cases and regressions. It would be good to do the full optimization for KeyPos > 0 in mad-hatter. This is an extension of Bug MB-27861 to optimize MIN aggregate without GROUP BY. As of vulcan, we want to handle optimization only for keyPos = 0 to avoid corner cases and regressions. It would be good to do the full optimization for KeyPos > 0 in mad-hatter.
            prathibha Prathibha Bisarahalli (Inactive) made changes -
            Labels request-dev-verify
            mihir.kamdar Mihir Kamdar (Inactive) made changes -
            Assignee Prathibha Bisarahalli [ prathibha ] Girish Benakappa [ girish.benakappa ]
            girish.benakappa Girish Benakappa made changes -
            Status Resolved [ 5 ] Closed [ 6 ]

            People

              girish.benakappa Girish Benakappa
              prathibha Prathibha Bisarahalli (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