diff options
author | unknown <serg@serg.mysql.com> | 2001-05-15 20:55:40 +0200 |
---|---|---|
committer | unknown <serg@serg.mysql.com> | 2001-05-15 20:55:40 +0200 |
commit | 83e3058c3e6ebd1ec2ffa03854eaf1388bb4c484 (patch) | |
tree | 21f17a4416a7c26597c585fb17a174dfc40da50e /mysql-test | |
parent | fe983ca7b3eed46e8cda130ad24d86f2609afdfb (diff) | |
parent | 5e52875b8fbce141f7a544da69ecf8c6c23ed6db (diff) | |
download | mariadb-git-83e3058c3e6ebd1ec2ffa03854eaf1388bb4c484.tar.gz |
Merge
Docs/manual.texi:
Auto merged
sql/lex.h:
Auto merged
sql/mysql_priv.h:
Auto merged
sql/sql_class.h:
Auto merged
sql/sql_parse.cc:
Auto merged
sql/sql_table.cc:
Auto merged
sql/sql_yacc.yy:
SCCS merged
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/t/alter_table.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index da98240c2cf..25cd0de6325 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -71,3 +71,23 @@ ALTER TABLE t1 ADD Column new_col int not null; UNLOCK TABLES; OPTIMIZE TABLE t1; DROP TABLE t1; +drop table if exists t1; + +# +# ALTER TABLE ... ENABLE/DISABLE KEYS + +create table t1 (n1 int not null, n2 int, n3 int, n4 float, + unique(n1), + key (n1, n2, n3, n4), + key (n2, n3, n4, n1), + key (n3, n4, n1, n2), + key (n4, n1, n2, n3) ); +alter table t1 disable keys; +let $1=10000; +while ($1) +{ + eval insert into t1 values($1,RAND()*1000,RAND()*1000,RAND()); + dec $1; +} +alter table t1 enable keys; +drop table t1; |