← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/large_tests/t/alter_table.test

  • Committer: devananda
  • Date: 2009-06-30 14:27:54 UTC
  • mfrom: (1030.2.4 trunk)
  • mto: (1093.1.7 captain)
  • mto: This revision was merged to the branch mainline in revision 1095.
  • Revision ID: devananda.vdv@gmail.com-20090630142754-vm9w374yxkf1pikc
merge from lp

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/large_tests/t/alter_table.test
1
1
# The test for bug#27029 requires about 8 hours and 20 minutes on my
2
2
# fastest machine.  This test requires at least 60 GB of disk space.
3
 
--source include/big_test.inc
4
3
 
5
4
#
6
5
# Bug#27029 alter table ... enable keys crashes mysqld on large table
9
8
drop table if exists t1;
10
9
--enable_warnings
11
10
 
12
 
create table `t1` (`c1` tinyint unsigned not null, key `c1` (`c1`)) 
13
 
engine=myisam default charset=utf8;
 
11
create table t1 (`c1` int not null, key `c1` (`c1`));
14
12
alter table `t1` disable keys;
15
13
insert into t1 values (1),(2),(3),(4);
16
14
insert into t1 select * from t1;