summaryrefslogtreecommitdiff
path: root/mysql-test/t/alter_table.test
diff options
context:
space:
mode:
authorunknown <Sinisa@sinisa.nasamreza.org>2003-04-03 21:17:53 +0300
committerunknown <Sinisa@sinisa.nasamreza.org>2003-04-03 21:17:53 +0300
commit00d9b06a7a6a659762e5fd4a6b8e32bbf3b639d0 (patch)
tree973b09020b3cc30702b03708b97fc1ca1fb1773c /mysql-test/t/alter_table.test
parent89bb3165501b09b2922d361905a4efb7b490d8b0 (diff)
downloadmariadb-git-00d9b06a7a6a659762e5fd4a6b8e32bbf3b639d0.tar.gz
test case for displaying and correct functioning of ALTER TABLE
ENABLE / DISABLE KEYS
Diffstat (limited to 'mysql-test/t/alter_table.test')
-rw-r--r--mysql-test/t/alter_table.test2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index 1c3987e2a31..d32c554aec8 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -86,6 +86,7 @@ create table t1 (n1 int not null, n2 int, n3 int, n4 float,
key (n3, n4, n1, n2),
key (n4, n1, n2, n3) );
alter table t1 disable keys;
+show keys from t1;
#let $1=10000;
let $1=10;
while ($1)
@@ -94,6 +95,7 @@ while ($1)
dec $1;
}
alter table t1 enable keys;
+show keys from t1;
drop table t1;
#