diff options
Diffstat (limited to 'mysql-test/r/myisam_optimize.result')
| -rw-r--r-- | mysql-test/r/myisam_optimize.result | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/mysql-test/r/myisam_optimize.result b/mysql-test/r/myisam_optimize.result index 341c3e180b8..36faba5eaa9 100644 --- a/mysql-test/r/myisam_optimize.result +++ b/mysql-test/r/myisam_optimize.result @@ -11,7 +11,7 @@ select left(b,10), a from t1 order by a; left(b,10) a CCCCCCCCCC 3 CCCCCCCCCC 4 -set debug_sync='myisam_after_repair_by_sort wait_for go'; +set debug_sync='myisam_before_repair_by_sort wait_for go'; optimize table t1; select a, left(b,10) from t1 order by a; set debug_sync='now signal go'; @@ -22,3 +22,17 @@ a left(b,10) 4 CCCCCCCCCC drop table t1; set debug_sync='reset'; +# End of 5.5 tests +CREATE TABLE t1 (i INT) ENGINE=MyISAM; +INSERT t1 VALUES (1); +LOCK TABLE t1 WRITE; +OPTIMIZE TABLE t1; +Table Op Msg_type Msg_text +test.t1 optimize status OK +SELECT * FROM INFORMATION_SCHEMA.TABLES; +SELECT * FROM t1; +i +1 +UNLOCK TABLES; +DROP TABLE t1; +# End of 10.0 tests |