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

Optimizer chooses wrong index for ORDER BY

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.5(EOL), 10.0(EOL), 10.1(EOL)
    • 10.4(EOL)
    • Optimizer
    • None
    • 10.1.9-1, 10.1.9-2, 10.1.9-3

    Description

      It thinks that composite index is not good for ordering (WHY???) and so chooses primary one (removing ORDER BY leads to correct index chosen forcing correct index leads to filesort).

      Related to https://bugs.launchpad.net/percona-server/+bug/1501457

      Attachments

        1. test4.test
          2.71 MB
          Oleksandr Byelkin

        Activity

          People

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