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

Remove equality predicates and constants from ORDER BY

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.6.2, 5.0.0
    • 4.6.2, 5.0.0
    • query
    • None

    Description

      During ORDER BY pushdown, the query planner ignores equality predicates and constants in the ORDER BY keys.

      These equality and constant keys should be removed from the ORDER BY clause in advance, so that OrderedIntersectScan and sorting are not performed unnecessarily.

      Transform this.order in build_select_sub.go (make a copy and transform the copy), before calling buildScan().

      Attachments

        Issue Links

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

          Activity

            People

              ajay.bhullar Ajay Bhullar
              gerald Gerald Sangudi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                PagerDuty