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

index condition pushdown on partitioned tables

Details

    Description

      hi,

      index condition pushdown was added with in mysql 5.7.3 for partitioned tables with commit https://github.com/mysql/mysql-server/commit/67d2e4ef917e49b0c14cee50e47a498f3f3d95d1

      by what i found out by now this feature is not yet available in mariadb and would be a great addition.

      thx

      markus

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33792 ANALYZE for statement shows incorrect selectivity of pushed index condition for table with partitions

          • Major - Major loss of function.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32227 Partition Table do not using (Using index condition) ICP

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21625 Index condition pushdown is not used with ref access of partitioned tables

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            View 10 older comments
            psergei Sergei Petrunia added a comment -

            Gosselin, extra asserts we've discussed:
            https://github.com/MariaDB/server/pull/3123

            psergei Sergei Petrunia added a comment - Gosselin , extra asserts we've discussed: https://github.com/MariaDB/server/pull/3123
            psergei Sergei Petrunia added a comment -

            lstartseva, the branch for testing is bb-11.4-mdev12404-asserts.

            psergei Sergei Petrunia added a comment - lstartseva , the branch for testing is bb-11.4-mdev12404-asserts.
            psergei Sergei Petrunia added a comment - - edited

            Merged the above with ANALYZE support: 

            bb-11.4-MDEV-18478-v4-MDEV-12404

            psergei Sergei Petrunia added a comment - - edited Merged the above with ANALYZE support: bb-11.4-MDEV-18478-v4-MDEV-12404
            lstartseva Lena Startseva added a comment - - edited

            Testing done. Ok to push. Please, don't forget changes from branch

            bb-11.4-MDEV-18478-v4-MDEV-12404

            lstartseva Lena Startseva added a comment - - edited Testing done. Ok to push. Please, don't forget changes from branch bb-11.4-MDEV-18478-v4-MDEV-12404
            Gosselin Dave Gosselin added a comment -

            I rebased to 11.5 and will merge once the buildbot checks pass on the PR: https://github.com/MariaDB/server/pull/3040

            Gosselin Dave Gosselin added a comment - I rebased to 11.5 and will merge once the buildbot checks pass on the PR: https://github.com/MariaDB/server/pull/3040

            People

              Gosselin Dave Gosselin
              mdorfer Markus Dorfer
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.