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
• Status: No Feedback
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• Version: 5.1.22
• OS: Windows
• CPU Architecture: Any
• Tags: auto_increment_offset

[18 Mar 2008 6:34] Salman Rawala

Description:
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".