Bug #65225 InnoDB miscalculates auto-increment after changing auto_increment_increment
| Submitted: | 7 May 2012 16:39 | Modified: | 10 Feb 2014 14:23 |
|---|---|---|---|
| Reporter: | Elena Stepanova | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.1, 5.5, 5.6 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | regression | ||
[7 May 2012 16:39]
Elena Stepanova
[8 May 2012 19:20]
Sveta Smirnova
Thank you for the report. Verified as described. Problem is not repeatable with version 5.0.
[10 Feb 2014 14:23]
Daniel Price
Fixed as of 5.5.37, 5.6.17, 5.7.4 and here's the changelog entry: Decreasing the "auto_increment_increment" value would have no affect on the next auto-increment value. Thank you for the bug report.
[27 Mar 2014 14:23]
Laurynas Biveinis
5.5$ bzr log -r 4596 -n0
------------------------------------------------------------
revno: 4596
committer: Thirunarayanan B<thirunarayanan.balathandayuth@oracle.com>
branch nick: mysql-5.5
timestamp: Mon 2014-02-10 10:13:35 +0530
message:
Bug #14049391 INNODB MISCALCULATES AUTO-INCREMENT AFTER DECREASING
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]
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.061 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.