Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-544

LP #939485: Broken fast index creation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      **Reported in Launchpad by Laurynas Biveinis last update 19-03-2012 11:29:44

      Upstream bug 54330 was not fixed in 5.5 (that 5.5 claims to have it fixed is upstream bug 64432).

      CREATE TABLE t1 (
      id BIGINT(20) AUTO_INCREMENT PRIMARY KEY,
      bar BIGINT(20)
      ) ENGINE=InnoDB;

      --disable_query_log
      SET @old_autocommit=@@AUTOCOMMIT;
      SET AUTOCOMMIT=0;
      let $1= 515641;
      while ($1)
      {
      eval INSERT INTO t1 (bar) VALUES (NULL);
      dec $1;
      }
      let $1= 2031;
      while ($1)
      {
      eval INSERT INTO t1 (bar) VALUES ($1);
      dec $1;
      }
      COMMIT;
      SET AUTOCOMMIT=@old_autocommit;
      --enable_query_log

      SELECT COUNT FROM t1;

      ALTER TABLE t1 ADD INDEX baz (bar);

      1. With the bug present this will differ from the SELECT above!
        SELECT COUNT FROM t1 FORCE INDEX (baz);

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Smart Checklist