Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5123

Remove duplicated conditions pushed both to join_tab->select_cond and join_tab->cache_select->cond for blocked joins.

    XMLWordPrintable

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.5
    • None
    • None

    Description

      If there is a condition that depends only on the second table in a blocked join,
      the following blocked join algorithms (BNL, BNLH) use this condition to pre-filter records from this table prior to joining the records.

      Currently the optimizer extracts such a single table condition independently from the generic condition pushdown. As a result the same condition may be evaluated up to two times more. This is a problem if the condition is expensive. It also makes it problematic to move the condition to an optimal partial join (see MDEV-83).

      Attachments

        1. md5123.1.diff
          7 kB
          Timour Katchaounov

        Issue Links

          Activity

            People

              timour Timour Katchaounov (Inactive)
              timour Timour Katchaounov (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.