[MDEV-4532] TokuDB: Behavior of auto_increment_offset + auto_increment_increment differs from MySQL spec - Jira

XML

Word

Printable

According to MySQL manual (http://dev.mysql.com/doc/refman/5.5/en/replication-options-master.html#sysvar_auto_increment_increment), if the combination of values is valid, the auto-increment sequence should start from auto_increment_offset. With TokuDB, it starts from auto_increment_offset+auto_increment_increment – in other words, the first value is omitted.

SET auto_increment_offset = 200;

SET auto_increment_increment = 300;

CREATE TABLE t1 (a int AUTO_INCREMENT, b char(8), primary key(a)) ENGINE=TokuDB;

INSERT INTO t1 VALUES (NULL,'a'),(NULL,'b'),(NULL,'c');

SELECT LAST_INSERT_ID();

LAST_INSERT_ID()

SELECT a,b FROM t1;

a	b

500	a

800	b

1100	c

Test case:

install soname 'ha_tokudb.so';

SET auto_increment_offset = 200;

SET auto_increment_increment = 300;

CREATE TABLE t1 (a int AUTO_INCREMENT, b char(8), primary key(a)) ENGINE=TokuDB;

INSERT INTO t1 VALUES (NULL,'a'),(NULL,'b'),(NULL,'c');

SELECT LAST_INSERT_ID();

SELECT a,b FROM t1;

bzr version-info

revision-id: holyfoot@askmonty.org-20130514121908-d6tp4zsdkim0q4dg

revno: 3768

branch-nick: 5.5-hf-tokudb

relates to

MDEV-4507 Include TokuDB storage engine

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.