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

use index when IN list contains tuples

    XMLWordPrintable

Details

    Description

      When query contains condition on multiple columns using IN list with multiple tuples, it won't use index. If IN contains only single tuple, then optimizer seems to rewrite it into multiple ANDs (can be seen with EXPLAIN EXTENDED).

      Upstream has it tracked in https://bugs.mysql.com/bug.php?id=31188 and said to be fixed in 5.7.3

      Would it be possible to implement such optimization?

      Attachments

        Activity

          People

            Unassigned Unassigned
            jkavalik Jiri Kavalik
            Votes:
            3 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.