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