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

do not open partitions excluded by automatic partition pruning

    XMLWordPrintable

Details

    Description

      extend MDEV-11084 to also not open automatically excluded partitions

      In particular, INSERT, DELETE, UPDATE and SELECT should not open any partitions that can be excluded by parsing the WHERE clause.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17613 MIN/MAX Optimization (Select tables optimized away) does not work

          • Major - Major loss of function.
          • Stalled
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11084 Select statement with partition selection against MyISAM table opens all partitions

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-19002 Partition performance optimization

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20376 Assertion in ha_maria::close() upon complex SELECT from specific data

          • Major - Major loss of function.
          • Closed

          Activity

            People

              holyfoot Alexey Botchkov
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              12 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.