[MDEV-5548] Fast index creation doesn't update statistics Created: 2014-01-22  Updated: 2015-07-21  Resolved: 2015-07-21

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.33a
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Patryk Pomykalski Assignee: Jan Lindström (Inactive)
Resolution: Won't Fix Votes: 0
Labels: upstream


 Description   

Adding an index to innodb table using "fast index creation" doesn't properly update statistics for this index (every index part gets cardinality around 200 for table with > 1000 rows).

 Comments   
Comment by Elena Stepanova [ 2014-01-28 ]

Upstream bug http://bugs.mysql.com/bug.php?id=62516.
Reproducible on all MariaDB 5.x and on MySQL 5.5 (I disagree with the last comment by Laurynas Biveinis in the MySQL bug report, it seems reproducible just fine to me).
Not reproducible on MySQL 5.6.10 and MariaDB 10.0.7, apparently the WLs that Marko Mäkelä mentioned were merged all right into 10.0 tree.

Comment by Jan Lindström (Inactive) [ 2015-07-21 ]

In my opinion that change is too big for GA versions.

Generated at Thu Feb 08 07:05:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.