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

Revise patches that fixed calculation and usage of condition selectivity

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 10.5
    • Optimizer
    • None

    Description

      The patches that fixed the bugs in the code of calculate_cond_selectivity_for_table() and
      table_cond_selectivity() effectively changed the original ideas how selectivity of condition should be calculated and how it should be used. As result many inconsistencies in the code has appeared and they induce new and bugs in cardinality estimations.

      Attachments

        Issue Links

          blocks

          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

          Activity

            People

              igor Igor Babaev (Inactive)
              igor Igor Babaev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.