summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <serg@serg.mysql.com>2001-05-15 20:55:40 +0200
committerunknown <serg@serg.mysql.com>2001-05-15 20:55:40 +0200
commit83e3058c3e6ebd1ec2ffa03854eaf1388bb4c484 (patch)
tree21f17a4416a7c26597c585fb17a174dfc40da50e /mysql-test
parentfe983ca7b3eed46e8cda130ad24d86f2609afdfb (diff)
parent5e52875b8fbce141f7a544da69ecf8c6c23ed6db (diff)
downloadmariadb-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.test20
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;