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

Fix condition selectivity computation for join prefixes

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Critical
    • Resolution: Unresolved
    • None
    • 11.4
    • Optimizer

    Description

      There is a bunch of known issues with condition selectivity computations for join prefixes : (MDEV-20740, MDEV-20595, MDEV-20697, MDEV-20740, MDEV-17783, MDEV-21633, MDEV-21813, etc)

      This task is an umbrella task for fixing them.

      Attachments

        Issue Links

          includes

          Task - A task that needs to be done. MDEV-33697 Improve selectivity computations for multi-part keys

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17783 AddressSanitizer: stack-buffer-overflow in table_cond_selectivity with optimizer_use_condition_selectivity > 1, join_cache_level >2

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20697 Take selectivity of join conditions into account correctly with optimizer_use_condition_selectivity > 1

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20740 Odd computations in calculate_cond_selectivity_for_table

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21377 Eq_ref access not picked by query with optimizer_use_condition_selectivity > 1

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21633 Assertion `tmp >= 0' failed in best_access_path with rowid_filter=ON

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21813 Optimizer choosing the wrong index despite the cost calculation

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25830 optimizer_use_condition_selectivity=4 sometimes produces worse plan than optimizer_use_condition_selectivity=1

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29395 Review input for 10.7-selectivity tree

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-29577 Rebase 10.7-selectivity tree

          • Major - Major loss of function.
          • Closed
          mentioned in

          Page Loading...

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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