diff options
| author | monty@donna.mysql.fi <> | 2001-04-01 13:45:48 +0300 |
|---|---|---|
| committer | monty@donna.mysql.fi <> | 2001-04-01 13:45:48 +0300 |
| commit | 65822120f5b553914de5d3c8983014ae896ee81a (patch) | |
| tree | b31bc7d8e38b04c6603c8f2240f10f86497e5003 /mysql-test/t/alter_table.test | |
| parent | a49a2e20012c5722e99e17cb3ef9c28a04389d96 (diff) | |
| download | mariadb-git-65822120f5b553914de5d3c8983014ae896ee81a.tar.gz | |
Fixed bug in ALTER TABLE
Removed _mi_rkey() function
New fork_big.pl multi-thread test
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; |