|
1578.3.1
by Stewart Smith
Make innobase auto_increment behaviour be the same as MyISAM on UPDATE. We also fix up auto_increment.result as the previous result was incorrect (we now match the mysql myisam test result). Also add a basic test (from the bug report) for the correct functionality |
1 |
create table t1 (a int not null auto_increment primary key, val int);
|
2 |
insert into t1 (val) values (1);
|
|
3 |
update t1 set a=2 where a=1;
|
|
4 |
insert into t1 (val) values (1);
|
|
5 |
drop table t1;
|