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

Keylookup with bitmask

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.3.34
    • N/A
    • Optimizer
    • None
    • Debian 10

    Description

      Keylookup with Bitmask is slower than it could be

      Create a big Table with normal key on tinyint column status

      select * from table where status &7 = 2
      takes much much longer than
      select * from table where status IN (2, 18, 34, 50, 66, 82, ....etc )

      Attachments

        Activity

          People

            danblack Daniel Black
            Balen Michael
            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.