diff options
Diffstat (limited to 'mysql-test/t/alter_table.test')
-rw-r--r-- | mysql-test/t/alter_table.test | 22 |
1 files changed, 13 insertions, 9 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index abeca8a32ba..da98240c2cf 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -57,13 +57,17 @@ CREATE TABLE t1 ( PRIMARY KEY (id) ) TYPE=MyISAM; -ALTER TABLE -t1 -ORDER BY -t1.id, -t1.status, -t1.type_id, -t1.user_id, -t1.body; +ALTER TABLE t1 ORDER BY t1.id, t1.status, t1.type_id, t1.user_id, t1.body; +DROP TABLE t1; -drop table t1; +# +# The following combination found a hang-bug in MyISAM +# + +CREATE TABLE t1 (AnamneseId int(10) unsigned NOT NULL auto_increment,B BLOB,PRIMARY KEY (AnamneseId)) type=myisam; +insert into t1 values (null,"hello"); +LOCK TABLES t1 WRITE; +ALTER TABLE t1 ADD Column new_col int not null; +UNLOCK TABLES; +OPTIMIZE TABLE t1; +DROP TABLE t1; |