~drizzle-trunk/drizzle/development

remove redundant part from innodb.test, it's now in auto_increment_update.test, along with behaviour change to match MyISAM.

added added

removed removed

1149

drop table t1;

1150

1151

1152

# Test that update does not change internal auto-increment value

1153

1154

1155

create table t1 (a int not null auto_increment primary key, val int) engine=InnoDB;

1156

insert into t1 (val) values (1);

1157

update t1 set a=2 where a=1;

1158

# We should get the following error because InnoDB does not update the counter

1159

--error ER_DUP_ENTRY

1160

insert into t1 (val) values (1);

1161

select * from t1;

1162

drop table t1;

1163

1164

1152

# Bug #10465

1165

1153

1166

1154