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 Stephane VAROQUI.

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

          will post here as private comments.

            Gliffy Diagrams

              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
                  Hide
                  Permalink
                  psergey Sergei Petrunia added a comment -

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

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

                  Hi Sergei,

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

                  Thanks,
                  Jocelyn

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

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

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

                  jocelyn fournier, I'll check.

                  Show
                  psergey Sergei Petrunia added a comment - jocelyn fournier , I'll check.
                  Hide
                  Permalink
                  psergey 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.

                  Show
                  psergey 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.
                  Hide
                  Permalink
                  psergey 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

                  Show
                  psergey 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

                    • Assignee:
                      psergey Sergei Petrunia
                      Reporter:
                      psergey Sergei Petrunia
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      3 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: