diff options
Diffstat (limited to 'mysql-test/t/myisam_optimize.test')
-rw-r--r-- | mysql-test/t/myisam_optimize.test | 21 |
1 files changed, 19 insertions, 2 deletions
diff --git a/mysql-test/t/myisam_optimize.test b/mysql-test/t/myisam_optimize.test index 3788534e2a5..5e133aea853 100644 --- a/mysql-test/t/myisam_optimize.test +++ b/mysql-test/t/myisam_optimize.test @@ -14,13 +14,13 @@ delete from t1 where a < 3; explain select a, left(b,10) from t1 order by a; select left(b,10), a from t1 order by a; -set debug_sync='myisam_after_repair_by_sort wait_for go'; +set debug_sync='myisam_before_repair_by_sort wait_for go'; send optimize table t1; connect (con1,localhost,root,,); let $wait_condition= select count(*) = 1 from information_schema.processlist - where state like "%myisam_after_repair_by_sort%"; + where state like "%myisam_before_repair_by_sort%"; --source include/wait_condition.inc send select a, left(b,10) from t1 order by a; @@ -46,3 +46,20 @@ connection default; drop table t1; set debug_sync='reset'; +--echo # End of 5.5 tests + +# +# MDEV-11539 test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon select from I_S +# +CREATE TABLE t1 (i INT) ENGINE=MyISAM; +INSERT t1 VALUES (1); +LOCK TABLE t1 WRITE; +OPTIMIZE TABLE t1; +--disable_result_log +SELECT * FROM INFORMATION_SCHEMA.TABLES; +--enable_result_log +SELECT * FROM t1; +UNLOCK TABLES; +DROP TABLE t1; + +--echo # End of 10.0 tests |