Activity log for bug #314570

Date Who What changed Old value New value Message
2009-01-07 00:59:47 Aarti Pai bug added bug
2009-01-28 06:07:27 Jay Pipes drizzle: status New Confirmed
2009-01-28 06:07:27 Jay Pipes drizzle: importance Undecided Critical
2009-01-28 06:07:27 Jay Pipes drizzle: statusexplanation Setting to critical...different storage engines should not produce different behaviour in this respect.
2009-04-03 19:14:01 Lee Bieber drizzle: assignee mordred
2009-04-03 19:14:01 Lee Bieber drizzle: milestone aloha
2009-08-18 17:01:01 Lee Bieber drizzle: milestone aloha bell
2009-08-18 17:01:01 Lee Bieber drizzle: assignee Monty Taylor (mordred) Stewart Smith (stewart-flamingspork)
2010-01-26 23:59:05 Lee Bieber drizzle: milestone bell cherry
2010-03-29 04:15:00 Lee Bieber nominated for series drizzle/cherry
2010-03-29 04:15:00 Lee Bieber bug task added drizzle/cherry
2010-04-28 07:05:55 Stewart Smith drizzle/cherry: milestone 2010-04-26 2010-05-24
2010-05-21 19:15:34 Brian Aker drizzle: status Confirmed Fix Released
2010-05-21 19:15:47 Brian Aker drizzle: status Fix Released Confirmed
2010-05-21 19:56:11 Lee Bieber drizzle: milestone 2010-05-24
2010-05-25 15:03:25 Stewart Smith drizzle/cherry: milestone 2010-05-24 2010-06-07
2010-06-02 05:04:31 Stewart Smith bug watch added http://bugs.mysql.com/bug.php?id=54165
2010-06-02 05:04:31 Stewart Smith bug task added mysql-server
2010-06-02 05:09:03 Stewart Smith bug task added maria
2010-06-02 05:10:39 Stewart Smith description broken.auto_increment [ fail ] drizzletest: At line 307: query 'insert into t1 (val) values (1)' failed: 1062: Duplicate entry '2' for key 'PRIMARY' The result from queries just before the failure was: < snip > a b 2 2 3 1 4 3 drop table t1; create table t1 (rowid int not null auto_increment, val int not null,primary key (rowid), unique(val)); replace into t1 (val) values ('1'),('2'); replace into t1 (val) values ('1'),('2'); insert into t1 (val) values ('1'),('2'); ERROR 23000: Duplicate entry '1' for key 'val' select * from t1; rowid val 3 1 4 2 drop table t1; 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); 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.
2010-06-02 06:30:21 Stewart Smith attachment added drizzle patch (should be easy to apply to others) http://launchpadlibrarian.net/49541584/innodb_autoinc_update.patch
2010-06-02 06:53:15 Launchpad Janitor branch linked lp:~stewart-flamingspork/drizzle/bug314570
2010-06-02 07:05:57 Stewart Smith drizzle/cherry: status Confirmed Fix Committed
2010-06-02 07:06:02 Stewart Smith drizzle: status Confirmed Fix Committed
2010-06-02 10:32:06 Sergei Golubchik maria: importance Undecided Low
2010-06-04 01:35:39 Stewart Smith drizzle: status Fix Committed Fix Released
2010-06-04 01:35:42 Stewart Smith drizzle/cherry: status Fix Committed Fix Released
2010-08-08 05:38:24 Michael Widenius bug task added percona-xtradb
2011-06-07 00:58:29 Stewart Smith percona-xtradb: status New Invalid