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

Multiple NestedLoop index joins are not being generated in CBO

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • Morpheus
    • Morpheus
    • analytics

    Description

      Some of these queries produced an internal edge with an assign statement such as $$25 <-- tobigint ($$20)
      The assign statement is then used to modify the next join predicate eq($$25, $$30) to
      eq(tobigint($$20), $$30).

      It turns out that NL index join code only accepts the original join predicate.

      The fix will be to push down the assigns from the internal edge to the corresponding leaf node.

      Attachments

        Issue Links

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

          Activity

            People

              murali.krishna Murali Krishna
              murali.krishna Murali Krishna
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty