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

LET and LETTING should not affect index selection

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Critical
    • 4.6.2, 5.0.0
    • 4.5.1, 4.6.0
    • query
    • None

    Description

      Currently, LET and LETTING clauses affect index selection and covering indexing. The variables from LET and LETTING clauses are not understood by the planner.

      During index selection, rewrite the query to remove the LET and LETTING clauses completely. After planning, restore the original query with the LET and LETTING clauses for plan generation and execution.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MB-22188 4.6.2 Minor Release

          • Major - Major loss of function.
          • Closed
          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