diff options
| author | unknown <hf@deer.(none)> | 2004-03-22 21:34:36 +0400 |
|---|---|---|
| committer | unknown <hf@deer.(none)> | 2004-03-22 21:34:36 +0400 |
| commit | a0d0da6f26050d3b710ee06e539e5d2d9a201841 (patch) | |
| tree | 30cfa5bc59ea5a6d511bc24ba8b8d4349d9c5d4a /mysql-test/r/repair_part1.result | |
| parent | afbf1bbaa40614b965752c9c8dd2ca28c4428cb0 (diff) | |
| download | mariadb-git-a0d0da6f26050d3b710ee06e539e5d2d9a201841.tar.gz | |
Fix for #3067 (REPAIR TABLE reenables disabled keys)
myisam/mi_check.c:
we only restore key_map if it's required
mysql-test/r/repair_part1.result:
appropriate test result
mysql-test/t/repair_part1.test:
test case
Diffstat (limited to 'mysql-test/r/repair_part1.result')
| -rw-r--r-- | mysql-test/r/repair_part1.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/repair_part1.result b/mysql-test/r/repair_part1.result index e0030327743..6dcec409ea6 100644 --- a/mysql-test/r/repair_part1.result +++ b/mysql-test/r/repair_part1.result @@ -9,6 +9,21 @@ repair table t1 use_frm; Table Op Msg_type Msg_text test.t1 repair error The storage engine for the table doesn't support repair drop table t1; +create table t1(id int PRIMARY KEY, st varchar(10), KEY st_key(st)); +insert into t1 values(1, "One"); +alter table t1 disable keys; +show keys from t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 id A 1 NULL NULL BTREE +t1 1 st_key 1 st A NULL NULL NULL YES BTREE disabled +repair table t1 extended; +Table Op Msg_type Msg_text +test.t1 repair status OK +show keys from t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 0 PRIMARY 1 id A 1 NULL NULL BTREE +t1 1 st_key 1 st A NULL NULL NULL YES BTREE disabled +drop table t1; repair table t1 use_frm; Table Op Msg_type Msg_text test.t1 repair error Table 'test.t1' doesn't exist |