Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4532

TokuDB: Behavior of auto_increment_offset + auto_increment_increment differs from MySQL spec

        Details

        • Type: Bug
        • Status: Open
        • Priority: Trivial
        • Resolution: Unresolved
        • Affects Version/s: 5.5.31
        • Fix Version/s: 5.5
        • Component/s: None
        • Labels:

          Description

          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()
500
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

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Task - A task that needs to be done. MDEV-4507 Include TokuDB storage engine

                • Blocker - Blocks development and/or testing work, production could not run.
                • Closed

                  Activity

                  Hide
                  Permalink
                  elenst Elena Stepanova added a comment -

                  Also reproducible on MariaDB-5.5.30-TokuDB-7.0.1

                  Show
                  elenst Elena Stepanova added a comment - Also reproducible on MariaDB-5.5.30-TokuDB-7.0.1

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      5 Start watching this issue

                      Dates

                      • Created:
                        Updated: