summaryrefslogtreecommitdiff
path: root/mysql-test/r/repair.result
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/r/repair.result
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/r/repair.result')
-rw-r--r--mysql-test/r/repair.result17
1 files changed, 16 insertions, 1 deletions
diff --git a/mysql-test/r/repair.result b/mysql-test/r/repair.result
index 79bc6d55c55..ed4722d40fb 100644
--- a/mysql-test/r/repair.result
+++ b/mysql-test/r/repair.result
@@ -114,7 +114,7 @@ test.t1 repair status OK
SET myisam_repair_threads=@@global.myisam_repair_threads;
SET myisam_sort_buffer_size=@@global.myisam_sort_buffer_size;
DROP TABLE t1;
-End of 4.1 tests
+# End of 4.1 tests
# Test with a saved table from 4.1
SHOW TABLE STATUS LIKE 't1';
Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
@@ -150,6 +150,7 @@ SELECT * FROM t1;
id
1
DROP TABLE t1;
+# End of 5.0 tests
DROP TABLE IF EXISTS tt1;
CREATE TEMPORARY TABLE tt1 (c1 INT);
REPAIR TABLE tt1 USE_FRM;
@@ -214,3 +215,17 @@ Table Op Msg_type Msg_text
test.v1 repair status OK
drop view v1;
drop table t1;
+# End of 5.5 tests
+CREATE TABLE t1 (i INT) ENGINE=MyISAM;
+INSERT t1 VALUES (1);
+LOCK TABLE t1 WRITE;
+REPAIR TABLE t1;
+Table Op Msg_type Msg_text
+test.t1 repair status OK
+SELECT * FROM INFORMATION_SCHEMA.TABLES;
+SELECT * FROM t1;
+i
+1
+UNLOCK TABLES;
+DROP TABLE t1;
+# End of 10.0 tests