Bug #40119 auto-increment-increment and auto-increment-offset it does not function

• Submitted: 17 Oct 2008 18:29
• Modified: 17 Oct 2008 18:36
• Reporter: giovanni silva
• Status: Not a Bug
• Category: MySQL Server: Replication
• Severity: S2 (Serious)
• Version: 5.0.67
• OS: Any
• CPU Architecture: Any
• Tags: Auto-increment

[17 Oct 2008 18:29] giovanni silva

Description:
auto-increment-increment and auto-increment-offset it does not function with exists data.

With the configuration standard of mysql it makes: 
create database test_database;

CREATE TABLE `teste_replica`.`test_table` (
  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  PRIMARY KEY(`id`)
)
ENGINE = InnoDB;

INSERT INTO TESTE_REPLICA.test_table() VALUES();
INSERT INTO TESTE_REPLICA.test_table() VALUES();
INSERT INTO TESTE_REPLICA.test_table() VALUES();
INSERT INTO TESTE_REPLICA.test_table() VALUES();

SELECT * FROM TESTE_REPLICA.test_table;
1
2
3
4

CONFIGURE 
auto-increment-increment = 10 
auto-increment-offset = 100
IN MY.INI AND RESTART MYSQL

SELECT * FROM TESTE_REPLICA.test_table;
1
2
3
4
14
24
34
44

IT WOULD HAVE TO BE:
1
2
3
4
100
110
120
130

How to repeat:
IT SEES ABOVE.

[17 Oct 2008 18:36] Sveta Smirnova

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

According to http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html:

If the value of auto_increment_offset  is greater than that of auto_increment_increment, the value of auto_increment_offset is ignored.