summaryrefslogtreecommitdiff
path: root/mysql-test/t/myisam_optimize.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2018-01-23 11:24:53 +0100
committerSergei Golubchik <serg@mariadb.org>2018-01-25 14:03:24 +0100
commita0702dbcda0c4495345d6dda6738cc77d823e325 (patch)
tree506d955acc8922c3d62d1ca5d2bca26ef1453e1a /mysql-test/t/myisam_optimize.test
parent1c10b256b301124aa861239bec7e7b97a3d98d98 (diff)
downloadmariadb-git-a0702dbcda0c4495345d6dda6738cc77d823e325.tar.gz
MDEV-11539 test_if_reopen: Assertion `strcmp(share->unique_file_name,filename) || share->last_version' failed upon select from I_S
remove HA_EXTRA_PREPARE_FOR_RENAME - neither OPTIMIZE nor REPAIR need it (was introduced in b58e79566c5 when replacing remove_table_from_cache() with wait_while_table_is_used() even though remove_table_from_cache() did not have it).
Diffstat (limited to 'mysql-test/t/myisam_optimize.test')
-rw-r--r--mysql-test/t/myisam_optimize.test17
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/myisam_optimize.test b/mysql-test/t/myisam_optimize.test
index 5f0b8fc7666..5e133aea853 100644
--- a/mysql-test/t/myisam_optimize.test
+++ b/mysql-test/t/myisam_optimize.test
@@ -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