diff options
| author | unknown <svoj@may.pils.ru> | 2006-08-14 17:05:02 +0500 |
|---|---|---|
| committer | unknown <svoj@may.pils.ru> | 2006-08-14 17:05:02 +0500 |
| commit | f6d7985a5b4a5c7d94cb04ba003dfa411cf0d3f2 (patch) | |
| tree | bf03933cdadf7c01941372b18ee76844aa412cff /mysql-test/r/repair.result | |
| parent | a2a5f2b53622af0933de757660428ba61737cb98 (diff) | |
| download | mariadb-git-f6d7985a5b4a5c7d94cb04ba003dfa411cf0d3f2.tar.gz | |
BUG#18874 - Setting myisam_repair_threads > 1, index cardinality always 1
Fixed by moving update_key_parts() down to be after write_index().
myisam/sort.c:
write_index() collects index statistic which is further used in
update_key_parts(). Thus update_key_parts() must be called after
write_index().
mysql-test/r/repair.result:
Test case for bug#18874.
mysql-test/t/repair.test:
Test case for bug#18874.
Diffstat (limited to 'mysql-test/r/repair.result')
| -rw-r--r-- | mysql-test/r/repair.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/repair.result b/mysql-test/r/repair.result index dbca5c39a6c..e0849452399 100644 --- a/mysql-test/r/repair.result +++ b/mysql-test/r/repair.result @@ -37,3 +37,14 @@ Table Op Msg_type Msg_text test.t1 repair warning Number of rows changed from 0 to 1 test.t1 repair status OK drop table t1; +CREATE TABLE t1(a INT, KEY(a)); +INSERT INTO t1 VALUES(1),(2),(3),(4),(5); +SET myisam_repair_threads=2; +REPAIR TABLE t1; +Table Op Msg_type Msg_text +test.t1 repair status OK +SHOW INDEX FROM t1; +Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment +t1 1 a 1 a A 5 NULL NULL YES BTREE +SET myisam_repair_threads=@@global.myisam_repair_threads; +DROP TABLE t1; |