diff options
| author | unknown <serg@serg.mysql.com> | 2002-08-31 20:42:41 +0000 |
|---|---|---|
| committer | unknown <serg@serg.mysql.com> | 2002-08-31 20:42:41 +0000 |
| commit | 3f363c7d4d04e9fda8fdf7b0ac99c369045e687c (patch) | |
| tree | a02394af922b23a01c59b08ddac8cd6c519d08c3 /mysql-test/t/myisam.test | |
| parent | 85da4cfd71303d1022b334d243017fc5e8dd091b (diff) | |
| download | mariadb-git-3f363c7d4d04e9fda8fdf7b0ac99c369045e687c.tar.gz | |
LOCK+change+OPTIMIZE MyISAM bug
myisam/mi_delete_all.c:
reverting the wrong bugfix
mysql-test/r/delete.result:
moving the test case to where it belongs
mysql-test/t/delete.test:
moving the test case to where it belongs
Diffstat (limited to 'mysql-test/t/myisam.test')
| -rw-r--r-- | mysql-test/t/myisam.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index c607cb4d63e..dec53e92036 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -93,3 +93,14 @@ INSERT INTO t1 (post_text) VALUES ('ceci est un test'),('ceci est un test'),('ce REPAIR TABLE t1; CHECK TABLE t1; drop table t1; + +# +# Test of OPTIMIZE of locked and modified tables +# +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1), (2), (3); +LOCK TABLES t1 WRITE; +INSERT INTO t1 VALUES (1), (2), (3); +OPTIMIZE TABLE t1; +DROP TABLE t1; + |