33
33
create temporary table t2 like t1;
35
35
insert into t2 select * from t1;
36
alter table t1 modify b blob not null, add c int not null, drop key a, add unique key (a,b(20),c), drop key b, add key (b(10));
36
alter table t1 modify b blob not null, add c int DEFAULT 42 not null, drop key a, add unique key (a,b(20),c), drop key b, add key (b(10));
37
37
# @TODO Should this be a MyISAM-specific test or not?
38
38
# Ignore "rows" in output -- inaccurate for InnoDB