Bug #46089 .frm file uses 2 bytes to store key flags, KEY structure uses 4.
Submitted: 9 Jul 2009 15:09 Modified: 13 Jul 2009 8:49
Reporter: Zardosht Kasheff (OCA) Email Updates:
Status: Verified Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.30, 5.0, 5.4 OS:Any
Assigned to: CPU Architecture:Any

[9 Jul 2009 15:09] Zardosht Kasheff
Filing this bug because #40358 was resolved as "not a bug". The KEY structure uses a uint to store flags. The .frm file uses 2 bytes. As a result, one cannot add possible key flags, because all 16 positions of the .frm file are used up. Also, HA_KEY_HA_PART_KEY_SEG is not passed into the storage engine.

How to repeat:

Suggested fix:
The .frm file should store 4 bytes for key flags
[13 Jul 2009 8:49] Sveta Smirnova
Thank you for the report.

Verified as described.

See http://lists.mysql.com/internals/34859 for details.