summaryrefslogtreecommitdiff
path: root/mysql-test/t/alter_table.test
diff options
context:
space:
mode:
authormonty@narttu.mysql.fi <>2003-06-01 12:32:53 +0300
committermonty@narttu.mysql.fi <>2003-06-01 12:32:53 +0300
commit02adbe659991af851a51c225059011a20d5cd47c (patch)
tree5524062586f42802c3aab500a005cf3dc593b2a1 /mysql-test/t/alter_table.test
parent889db1aa5ef099136ae0954ac35bb73ffe5b5226 (diff)
downloadmariadb-git-02adbe659991af851a51c225059011a20d5cd47c.tar.gz
Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED. Bug #478
Diffstat (limited to 'mysql-test/t/alter_table.test')
-rw-r--r--mysql-test/t/alter_table.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test
index 96f969c8776..a3ab62afc69 100644
--- a/mysql-test/t/alter_table.test
+++ b/mysql-test/t/alter_table.test
@@ -133,3 +133,12 @@ analyze table t1;
show keys from t1;
drop table t1;
+#
+# Test of ALTER TABLE DELAYED
+#
+
+CREATE TABLE t1 (i int(10), index(i) );
+ALTER TABLE t1 DISABLE KEYS;
+INSERT DELAYED INTO t1 VALUES(1),(2),(3);
+ALTER TABLE t1 ENABLE KEYS;
+drop table t1;