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 created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            Assignee Sergei Petrunia [ psergey ]
            psergei Sergei Petrunia made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            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 made changes -
            Description A case reported by [~stephanevaroqui].

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

            will post here as private comments.
            		 A case reported by [~stephanevaroqui].

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

            will post here as private comments.
            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 made changes -
            Affects Version/s 10.0.13 [ 16300 ]
            psergei Sergei Petrunia made changes -
            Fix Version/s 10.1 [ 16100 ]
            psergei Sergei Petrunia made changes -
            Labels optimizer order-by-optimization
            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
            psergei Sergei Petrunia made changes -
            Component/s Optimizer [ 10200 ]
            Fix Version/s 10.1.1 [ 16801 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            psergei Sergei Petrunia made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 53306 ] MariaDB v3 [ 62816 ]
            psergei Sergei Petrunia made changes -
            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.
            		  A case reported by [~stephanevaroqui].

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

            will post here as private comments.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 62816 ] MariaDB v4 [ 148169 ]

            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.