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

    • 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

              jplindst Jan Lindström (Inactive)
              ccalender Chris Calender (Inactive)
              Votes:
              2 Vote for this issue
              Watchers:
              7 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.