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

UNIQUE indexes should not be considered for loose index scan

Details

    • Task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.0.5
    • None
    • None

    Description

      Currently the loose scan code in opt_range.cc considers all indexes as possible for the access method. Due to inexact statistics it may happen that a loose scan is selected over a unique index.

      This is clearly wrong since a "loose scan" over a unique index will read the same keys as a direct index scan, but the loose scan has more overhead.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-7118 Anemometer stop working after upgrade to from 5.6 to 10.0

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

          Activity

            Ascending order - Click to sort in descending order
            timour Timour Katchaounov (Inactive) created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Fix Version/s 10.0.3 [ 12900 ]
            Fix Version/s 10.0.2 [ 11900 ]
            timour Timour Katchaounov (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            timour Timour Katchaounov (Inactive) made changes -
            Assignee Timour Katchaounov [ timour ] Sergei Petrunia [ psergey ]
            timour Timour Katchaounov (Inactive) added a comment -

            Assigned to SergeyP for review.

            timour Timour Katchaounov (Inactive) added a comment - Assigned to SergeyP for review.
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.4 [ 13101 ]
            Fix Version/s 10.0.3 [ 12900 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0.5 [ 13201 ]
            Fix Version/s 10.0.4 [ 13101 ]
            psergei Sergei Petrunia made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            psergei Sergei Petrunia added a comment -

            Patch approved with comments (see email)

            psergei Sergei Petrunia added a comment - Patch approved with comments (see email)
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ] Timour Katchaounov [ timour ]
            timour Timour Katchaounov (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 26058 ] MariaDB v2 [ 44301 ]
            psergei Sergei Petrunia made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 44301 ] MariaDB v3 [ 63612 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 63612 ] MariaDB v4 [ 132070 ]

            People

              timour Timour Katchaounov (Inactive)
              timour Timour Katchaounov (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.