From 9418a8805716ef10ed7e39f2e56c44a9ade55bb4 Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 31 Aug 2002 23:18:08 +0000 Subject: LOCK+modify+OPTIMIZE bugfix --- mysql-test/r/myisam.result | 2 ++ mysql-test/t/myisam.test | 11 +++++++++++ 2 files changed, 13 insertions(+) (limited to 'mysql-test') diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index a8f97c57d33..f57b99cf9fd 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -36,3 +36,5 @@ table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 4 +Table Op Msg_type Msg_text +test.t1 optimize status OK diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test index eb1d9a01020..45d26993795 100644 --- a/mysql-test/t/myisam.test +++ b/mysql-test/t/myisam.test @@ -64,3 +64,14 @@ explain select a,b from t1 order by b; explain select a,b from t1; explain select a,b,c from 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; + -- cgit v1.2.1