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

Revise patches that fixed calculation and usage of condition selectivity

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • 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

            Ascending order - Click to sort in descending order
            julien.fritsch Julien Fritsch added a comment -

            Automated message:
            ----------------------------
            Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

            julien.fritsch Julien Fritsch added a comment - Automated message: ---------------------------- Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.
            JIraAutomate JiraAutomate added a comment -

            Automated message:
            ----------------------------
            Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

            JIraAutomate JiraAutomate added a comment - Automated message: ---------------------------- Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.
            monty Michael Widenius added a comment -

            Not relevant anymore for 10.5.
            11.0 should not have this issue

            monty Michael Widenius added a comment - Not relevant anymore for 10.5. 11.0 should not have this issue

            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:

                Git Integration

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