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.
--
Mailing list: https://launchpad.net/~linux-traipu
Post to : linux-traipu@lists.launchpad.net
Unsubscribe : https://launchpad.net/~linux-traipu
More help : https://help.launchpad.net/ListHelp
