diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-06-01 12:32:53 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-06-01 12:32:53 +0300 |
| commit | 2ef52d46a4f5b0c34bee26b0f70d672b6ee9325e (patch) | |
| tree | 5524062586f42802c3aab500a005cf3dc593b2a1 /mysql-test/t/alter_table.test | |
| parent | dbdcae8bef9092979a84ff490bb2eb791b5366fc (diff) | |
| download | mariadb-git-2ef52d46a4f5b0c34bee26b0f70d672b6ee9325e.tar.gz | |
Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED. Bug #478
mysql-test/r/alter_table.result:
new results
mysql-test/r/lowercase_table.result:
new results
mysql-test/t/alter_table.test:
Test of ALTER TABLE DISABLE KEYS + INSERT DELAYED
mysql-test/t/lowercase_table.test:
Added test of alias name comparison
sql/mysql_priv.h:
Made closed_cached_table local
sql/sql_table.cc:
Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 9 |
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; |