MySQL Bugs: #46089: .frm file uses 2 bytes to store key flags, KEY structure uses 4.

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:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1.30, 5.0, 5.4	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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:
n/a

Suggested fix:
The .frm file should store 4 bytes for key flags

Thank you for the report.

Verified as described.

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