Bug #35370 Abnormal behavior on assigning negative value to auto_increment_offset
Submitted: 18 Mar 2008 6:46 Modified: 26 Mar 2008 7:09
Reporter: Salman Rawala Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.22 OS:Windows
Assigned to: CPU Architecture:Any
Tags: auto_increment_offset

[18 Mar 2008 6:46] Salman Rawala
Description:
When we assign negative value to variable auto_increment_offset, index column increases randomly.

How to repeat:
SET @@auto_increment_offset = -10;
SELECT @@auto_increment_offset = -10;
@@auto_increment_offset = -10
0
INSERT into t1(name) values('Record_17');
INSERT into t1(name) values('Record_18');
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
134	Record_13
140	Record_14
150	Record_15
160	Record_16
170	Record_17
180	Record_18
189	Record_17
199	Record_18
[19 Mar 2008 8:21] Sveta Smirnova
Thank you for the report.

I can not repeat described behavior. Please provide compelete test case including CREATE TABLE t1 statement and SELECT @@auto_increment_increment;
[26 Mar 2008 7:09] Salman Rawala
Verified on 5.1.23 and this problem is irreproducible on this version