• Satya B's avatar
    Applying InnoDB snapshot 5.1-ss5282, Fixes BUG#44030 · 17339c74
    Satya B authored
    1. Fixes BUG#44030 - Error: (1500) Couldn't read the MAX(ID) autoinc value 
                         from the index (PRIMARY)
    
    2. Disables the innodb-autoinc test for innodb plugin temporarily.
       The testcase for this bug has different result file for InnoDB plugin.
       Should add the testcase to Innodb suite with a different result file.
    
    Detailed revision comments:
    
    r5243 | sunny | 2009-06-04 03:17:14 +0300 (Thu, 04 Jun 2009) | 14 lines
    branches/5.1: When the InnoDB and MySQL data dictionaries go out of sync, before
    the bug fix we would assert on missing autoinc columns. With this fix we allow
    MySQL to open the table but set the next autoinc value for the column to the
    MAX value. This effectively disables the next value generation. INSERTs will
    fail with a generic AUTOINC failure. However, the user should be able to
    read/dump the table, set the column values explicitly, use ALTER TABLE to
    set the next autoinc value and/or sync the two data dictionaries to resume
    normal operations.
    
    Fix Bug#44030 Error: (1500) Couldn't read the MAX(ID) autoinc value from the
    index (PRIMARY)
    
    rb://118
    
    r5252 | sunny | 2009-06-04 10:16:24 +0300 (Thu, 04 Jun 2009) | 2 lines
    branches/5.1: The version of the result file checked in was broken in r5243.
    
    r5259 | vasil | 2009-06-05 10:29:16 +0300 (Fri, 05 Jun 2009) | 7 lines
    branches/5.1:
    
    Remove the word "Error" from the printout because the mysqltest suite
    interprets it as an error and thus the innodb-autoinc test fails.
    
    Approved by:	Sunny (via IM)
    r5466 | vasil | 2009-07-02 10:46:45 +0300 (Thu, 02 Jul 2009) | 6 lines
    branches/5.1:
    
    Adjust the failing innodb-autoinc test to conform to the latest behavior
    of the MySQL code. The idea and the comment in innodb-autoinc.test come
    from Sunny.
    
    17339c74
innodb-autoinc.result 21.7 KB