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

Fix condition selectivity computation for join prefixes

    XMLWordPrintable

    Details

      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

          relates to

          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.
          • In Progress

          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.
          • In Review

          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.
          • In Review

          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.
          • In Progress

          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.
          • Stalled
          mentioned in

          Page Loading...

            Activity

              People

              Assignee:
              psergei Sergei Petrunia
              Reporter:
              psergei Sergei Petrunia
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration