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

prepare statements that has correlated subqueries may not detect correlation

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Major
    • 5.5.0
    • 4.0.0, 4.1.0, 4.5.0, 4.6.0, 5.0.0, 5.1.0, 5.5.0
    • query
    • None

    Description

      plan stores as string for subqueries/expressions that are not in from clause (i.e. where, projection) During unmarshall we prepare expression/subqueries as satndalone.
      This leaves hole detection of correlation because this is done in algebra as part of Fromalizer. during unmarsalll we never cal Formalizer and leaves missing correlation and may use cached results. Which can result in wrong results.

      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:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty