linux-traipu team mailing list archive

[Stewart Smith <stewart@xxxxxxxxxxxxxxxx>]

All development of XtraDB has moved under the Percona Server project -
https://launchpad.net/percona-server - If this bug can be reproduced
against current Percona Server, please file this bug against percona-
server (you can simply do so by using the "Also affects project" link
above).

Thanks,
Stewart Smith
Director of Server Development
Percona.

** Changed in: percona-xtradb
       Status: New => Invalid

-- 
You received this bug notification because you are a member of UBUNTU -
AL, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/314570

Title:
  update is not changing internal auto increment value

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Fix Released
Status in Drizzle cherry series:
  Fix Released
Status in Maria:
  New
Status in MySQL Server:
  Unknown
Status in Percona XtraDB Storage Engine for MySQL:
  Invalid

Bug description:
  create table t1 (a int not null auto_increment primary key, val int);
  insert into t1 (val) values (1);
  update t1 set a=2 where a=1;
  insert into t1 (val) values (1);

  leads to:

  drizzletest: At line 307: query 'insert into t1 (val) values (1)'
  failed: 1062: Duplicate entry '2' for key 'PRIMARY'

  For InnDB this fails, for MyISAM, it passes as MyISAM updates the auto
  increment value.