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

select count(*) on hash partitions does a sorted index scan

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.0.12
    • 11.0
    • None
    • None
    • ubuntu

    Description

      select count(*) on hash partitions does a sorted index scan. the sort is unnecessary since the count operator is commutative. this problem also exists in MySQL 5.5 but is fixed in MySQL 5.6.19.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-371 Unique indexes for blobs

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

          Activity

            People

              psergei Sergei Petrunia
              prohaska7 Rich Prohaska
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.