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

Handler next limit scan the full table

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.0.7
    • None
    • None

    Description

      Populate a sysbench table

      handler `test`.`sbtest` open as t00000;                                                                                              
      handler t00000 read `PRIMARY` >= (4995723) where `id` >= 4995723 and `id` <= 4995822 and (`id` between 4995723  and  4995822) limit 2;
      +---------+---+---+----------------------------------------------------+
      | id      | k | c | pad                                                |
      +---------+---+---+----------------------------------------------------+
      | 4995723 | 0 |   | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
      | 4995724 | 0 |   | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
      +---------+---+---+----------------------------------------------------+
      2 rows in set (0,00 sec)
       
      handler t00000 read `PRIMARY` next         where `id` >= 4995723 and `id` <= 4995822 and (`id` between 4995723  and  4995822) limit 100;
      [1/28/14 10:31:50 AM] svaroqui: | 4995822 | 0 |   | qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt |
      +---------+---+---+----------------------------------------------------+
      98 rows in set (7,89 sec)
      | Handler_read_next             | 5004278 |

      Attachments

        Activity

          People

            elenst Elena Stepanova
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.