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

FR: use index when IN list contains tuples

        Details

        • Type: Task
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: Optimizer
        • Labels:

          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?

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    jkavalik Jiri Kavalik
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: