2
# Test of REPLACE with MyISAM and MEMORY
6
drop table if exists t1;
10
# Test when using replace on a key that has used up it's whole range
13
create table t1 (a int not null auto_increment primary key, b char(20) default "default_value");
14
insert into t1 values (126,"first"),(63, "middle"),(1,"last");
16
insert into t1 values (1,"error");
18
#replace into t1 values (1,"error");
19
replace into t1 values (126,"first updated");
20
replace into t1 values (63,default);
21
select * from t1 order by a;