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

ALTER TABLE CHANGE and ADD INDEX on auto_increment column fails with "Incorrect key file for table..."

    XMLWordPrintable

    Details

    • Sprint:
      10.0.34

      Description

      An ALTER TABLE CHANGE and ADD INDEX on auto_increment column fails with "Incorrect key file for table...".

      CREATE TABLE t ( 
      a bigint(20) unsigned NOT NULL AUTO_INCREMENT, 
      c bigint(20) unsigned NOT NULL, 
      PRIMARY KEY (a) 
      ) ENGINE=InnoDB ;
       
      ALTER TABLE t CHANGE a b BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, ADD KEY uk (c);
       
      ERROR 1034 (HY000): Index for table 't' is corrupt; try to repair it
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              ccalender Chris Calender
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: