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

Poor plan choice for ORDER BY key DESC optimization and possible range access

Details

    Description

      A case reported by stephanevaroqui.

      Unfortunately the most of the data is from a customer and is private.

      will post here as private comments.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-6846 Test tokudb_mariadb.mdev6657 fails in buildbot (and outside)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia added a comment -

            Commit is here: http://lists.askmonty.org/pipermail/commits/2014-September/006480.html

            psergei Sergei Petrunia added a comment - Commit is here: http://lists.askmonty.org/pipermail/commits/2014-September/006480.html
            jocel1 jocelyn fournier added a comment -

            Hi Sergei,

            Does this fix impact as well https://mariadb.atlassian.net/browse/MDEV-626 ?

            Thanks,
            Jocelyn

            jocel1 jocelyn fournier added a comment - Hi Sergei, Does this fix impact as well https://mariadb.atlassian.net/browse/MDEV-626 ? Thanks, Jocelyn
            psergei Sergei Petrunia added a comment -

            the patch was pushed to https://github.com/MariaDB/server/tree/bb-10.1-mdev6657.

            psergei Sergei Petrunia added a comment - the patch was pushed to https://github.com/MariaDB/server/tree/bb-10.1-mdev6657 .
            psergei Sergei Petrunia added a comment -

            jocel1, I'll check.

            psergei Sergei Petrunia added a comment - jocel1 , I'll check.
            psergei Sergei Petrunia added a comment -

            Hi Jocelyn,

            MDEV-465 and MDEV-626 are fixed not by this fix, but by fix for MDEV-6384. I've commented at MEV-465. Fix for MDEV-6384 is currently going through QA.

            psergei Sergei Petrunia added a comment - Hi Jocelyn, MDEV-465 and MDEV-626 are fixed not by this fix, but by fix for MDEV-6384 . I've commented at MEV-465. Fix for MDEV-6384 is currently going through QA.
            psergei Sergei Petrunia added a comment -

            Merged this fix with the latest ORDER BY fixes in 10.1, pushed to https://github.com/MariaDB/server/tree/bb-10.1-mdev6657-r2

            psergei Sergei Petrunia added a comment - Merged this fix with the latest ORDER BY fixes in 10.1, pushed to https://github.com/MariaDB/server/tree/bb-10.1-mdev6657-r2

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.