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

Back-port the code to optimize ORDER BY with small LIMIT from mysql 5.6

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.0
    • None
    • None

    Description

      Within this task the patches that support a more efficient handling of
      the queries with ORDER BY <order> LIMIT <n>, such that n is small enough and
      no indexes are used for order, will be back-ported from 5.6. The feature were developed in WL#1393.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          igor Igor Babaev (Inactive) created issue -
          igor Igor Babaev (Inactive) made changes -
          Field Original Value New Value
          Assignee Igor Babaev [ igor ]
          igor Igor Babaev (Inactive) made changes -
          Description Within this task the patches that support a more efficient handling of
          the queries with ORDER BY <order> LIMIT <n>, such that n is small enough and
          no indexes are used for order, will be back-ported from 5.6.           		Within this task the patches that support a more efficient handling of
          the queries with ORDER BY <order> LIMIT <n>, such that n is small enough and
          no indexes are used for order, will be back-ported from 5.6. The feature were developed in WL#1393.
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          igor Igor Babaev (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          igor Igor Babaev (Inactive) made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          serg Sergei Golubchik added a comment -

          pushed in 10.0-base

          serg Sergei Golubchik added a comment - pushed in 10.0-base
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          igor Igor Babaev (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 13585 ] MariaDB v2 [ 44790 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 44790 ] MariaDB v3 [ 64290 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 64290 ] MariaDB v4 [ 131954 ]

          People

            igor Igor Babaev (Inactive)
            igor Igor Babaev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.