Debian Codegraph @

mysql-test/suite/large_tests/t/alter_table.test

raw
1 # The test for bug#27029 requires about 8 hours and 20 minutes on my
2 # fastest machine. This test requires at least 60 GB of disk space.
3 --source include/big_test.inc
4
5 #
6 # Bug#27029 alter table ... enable keys crashes mysqld on large table
7 #
8 --disable_warnings
9 drop table if exists t1;
10 --enable_warnings
11
12 create table `t1` (`c1` tinyint unsigned not null, key `c1` (`c1`))
13 engine=myisam default charset=utf8;
14 alter table `t1` disable keys;
15 insert into t1 values (1),(2),(3),(4);
16 insert into t1 select * from t1;
17 insert into t1 select * from t1;
18 insert into t1 select * from t1;
19 insert into t1 select * from t1;
20 insert into t1 select * from t1;
21 insert into t1 select * from t1;
22 insert into t1 select * from t1;
23 insert into t1 select * from t1;
24 insert into t1 select * from t1;
25 insert into t1 select * from t1;
26 insert into t1 select * from t1;
27 insert into t1 select * from t1;
28 insert into t1 select * from t1;
29 insert into t1 select * from t1;
30 insert into t1 select * from t1;
31 insert into t1 select * from t1;
32 insert into t1 select * from t1;
33 insert into t1 select * from t1;
34 insert into t1 select * from t1;
35 insert into t1 select * from t1;
36 insert into t1 select * from t1;
37 insert into t1 select * from t1;
38 insert into t1 select * from t1;
39 insert into t1 select * from t1;
40 insert into t1 select * from t1;
41 insert into t1 select * from t1;
42 insert into t1 select * from t1;
43 insert into t1 select * from t1;
44 insert into t1 select * from t1;
45 insert into t1 select * from t1 limit 2147483647; #Insert 4294967295 rows.
46 alter table t1 enable keys;
47 drop table t1;