repair.test 697 Bytes
Newer Older
1 2 3 4
#
# Test of repair table
#

5
--disable_warnings
6
drop table if exists t1;
7 8
--enable_warnings

9 10
create table t1 SELECT 1,"table 1";
repair table t1 use_frm;
11
alter table t1 ENGINE=HEAP;
12 13
repair table t1 use_frm;
drop table t1;
serg@serg.mylan's avatar
serg@serg.mylan committed
14

15 16 17 18 19 20 21 22 23 24 25 26
#
# disabled keys during repair
#
create table t1(id int PRIMARY KEY, st varchar(10), KEY st_key(st));
insert into t1 values(1, "One");
alter table t1 disable keys;
show keys from t1;
repair table t1 extended;
show keys from t1;
drop table t1;


serg@serg.mylan's avatar
serg@serg.mylan committed
27 28 29
# non-existent table
repair table t1 use_frm;

30
create table t1 engine=myisam SELECT 1,"table 1";
31
flush tables;
serg@serg.mylan's avatar
serg@serg.mylan committed
32 33 34 35
system echo 1 > $MYSQL_TEST_DIR/var/master-data/test/t1.MYI ;
repair table t1;
repair table t1 use_frm;
drop table t1;