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: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL)
    • N/A
    • 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:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 32d 3h
                  32d 3h

                  Git Integration

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