• Satya B's avatar
    Additional Fix for BUG#44030 - Error: (1500) Couldn't read the MAX(ID) autoinc · 1eef7665
    Satya B authored
                                   value from the index (PRIMARY)
    
    
    With the fix for BUG#46760, we correctly flag the presence of row_type 
    only when it's actually changed and enables the FAST ALTER TABLE which was
    disabled with the BUG#39200.
    
    So the changes made by BUG#46760 makes MySQL data dictionaries to be out of 
    sync but they are handled already by InnoDB with this BUG#44030.
    
    The test was originally written to handle this but we requested Innodb to
    update the test as the data dictionaries were in sync after the fix for 
    BUG#39200.
    
    Adjusting the innodb-autoinc testcase as mentioned in the comments.
    
    mysql-test/lib/mtr_cases.pm:
      Re-enable the innodb-autoinc test case for plugin as we have a common
      result file.
    mysql-test/r/innodb-autoinc.result:
      Additional Fix for BUG#44030 - Error: (1500) Couldn't read the MAX(ID) autoinc 
                                     value from the index (PRIMARY)
      
      Adjust the innodb-autoinc testcase as the patch for BUG#46760 enables the 
      FAST ALTER TABLE and makes the data dictonaries go out of sync. This is 
      expected in the testcase.
    mysql-test/t/innodb-autoinc.test:
      Additional Fix for BUG#44030 - Error: (1500) Couldn't read the MAX(ID) autoinc 
                                     value from the index (PRIMARY)
      
      Adjust the innodb-autoinc testcase as the patch for BUG#46760 enables the 
      FAST ALTER TABLE and makes the data dictonaries go out of sync. This is 
      expected in the testcase.
    1eef7665
mtr_cases.pm 33.2 KB