• Thirunarayanan B's avatar
    Bug #14049391 INNODB MISCALCULATES AUTO-INCREMENT AFTER DECREASING · 7c12a9e5
    Thirunarayanan B authored
                            AUTO_INCREMENT_INCREMENT
    Problem:
    =======
    When auto_increment_increment system variable decreases,
    immediate next value of auto increment column is not affected.
    
    Solution:
    ========
    	Get the previous inserted value of auto increment column by
    subtracting the previous auto_increment_increment from next
    auto increment value. After that calculate the current autoinc value
    using newly changed auto_increment_increment variable.
    
    	Approved by Sunny [rb#4394]
    7c12a9e5
innodb-autoinc.test 24 KB