Bug #35367 Abnormal behavior on assigning lesser value to auto_increment_offset
Submitted: 18 Mar 2008 6:34 Modified: 19 Apr 2008 9:32
Reporter: Salman Rawala Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.22 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: auto_increment_offset

[18 Mar 2008 6:34] Salman Rawala
When we assign value to variable auto_increment_offset lesser than current offset value, it starts increasing value of index column randomly.

How to repeat:
Current index value is 69 and then I have assigned following value to variable:

SET @@session.auto_increment_offset = 5;
INSERT into t1(name) values('Record_9');
--echo 'Bug: Random value of id is increasing on assigning value to variable that is less than current offset';
INSERT into t1(name) values('Record_10');
INSERT into t1(name) values('Record_11');
INSERT into t1(name) values('Record_12');

Actual Output:
SELECT * from t1;
id	name
5	Record_1
15	Record_2
24	Record_3
34	Record_4
36	Record_5
51	Record_6
54	Record_7
69	Record_8
 |80      Record_9|
 |95  	 Record_10|
 |110	 Record_11|
 |125	 Record_12|
[18 Mar 2008 8:18] Salman Rawala
Updated version number
[19 Mar 2008 9:32] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior with test data. Please provide repeatable test case.
[19 Apr 2008 23:01] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".