Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Won't Fix
-
5.1.67, 5.2.14, 5.3.12, 5.5(EOL), 10.0(EOL)
-
OpenSuSE 13.1 64-bit
Description
Indexes missing cardinality after importing data from the dump. Specifically cardinality is not populated after indexes enabled after being disabled. Simple query to demonstrate the problem:
DROP TABLE IF EXISTS `bad_table`; |
CREATE TABLE `bad_table` ( |
`id1` INT(10) UNSIGNED NOT NULL, |
`id2` INT(10) UNSIGNED NOT NULL, |
INDEX `idx1` (`id1`, `id2`) |
)
|
ENGINE=MyISAM;
|
 |
/*!40000 ALTER TABLE `jobListDevices` DISABLE KEYS */; |
INSERT INTO `bad_table` VALUES |
(1,1),
|
(1,2),
|
(1,3),
|
(1,4),
|
(2,1),
|
(2,2),
|
(2,3),
|
(2,4),
|
(3,1),
|
(3,2),
|
(3,3),
|
(3,4)
|
;
|
/*!40000 ALTER TABLE `jobListDevices` ENABLE KEYS */; |
show index from `bad_table`; |
analyze table `bad_table`; |
show index from `bad_table`; |