Debian Codegraph @

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

raw
1 # Warning: The current test has problematic properties at runtime
2 # - non debug build ~ 3h
3 # - debug build ~ 8h
4 # - space consumption in minimum 60 GB on disk
5 #
6 # Therefore we skip in case '--big-test' is not assigned.
7 --source include/big_test.inc
8 # Hence we skip on debug builds.
9 --source include/have_nodebug.inc
10 # Start server with MyISAM
11 --source include/force_myisam_default.inc
12 # Skip the test if MyISAM is not available
13 --source include/have_myisam.inc
14
15 #
16 # Bug#27029 alter table ... enable keys crashes mysqld on large table
17 #
18 --disable_warnings
19 drop table if exists t1;
20 --enable_warnings
21
22 create table `t1` (`c1` tinyint unsigned not null, key `c1` (`c1`))
23 engine=myisam default charset=utf8;
24 alter table `t1` disable keys;
25 insert into t1 values (1),(2),(3),(4);
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;
46 insert into t1 select * from t1;
47 insert into t1 select * from t1;
48 insert into t1 select * from t1;
49 insert into t1 select * from t1;
50 insert into t1 select * from t1;
51 insert into t1 select * from t1;
52 insert into t1 select * from t1;
53 insert into t1 select * from t1;
54 insert into t1 select * from t1;
55 insert into t1 select * from t1 limit 2147483647; #Insert 4294967295 rows.
56 alter table t1 enable keys;
57 drop table t1;