MySQL Bugs: #7578: Insert buffering of prefix indexes works incorrectly with new InnoDB format

Bug #7578	Insert buffering of prefix indexes works incorrectly with new InnoDB format
Submitted:	29 Dec 2004 18:48	Modified:	29 Dec 2004 22:47
Reporter:	Marko Mäkelä	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S1 (Critical)
Version:	5.0.3-bk	OS:	Any (all)
Assigned to:	Marko Mäkelä	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When a secondary index containing a prefix index column is updated through the InnoDB insert buffer, it may become corrupted.

How to repeat:
Run the speedc test long enough, so that secondary indexes will be updated from the insert buffer. Either an ut_ad() assertion will fail, or the secondary index will become corrupted.

Suggested fix:
The data are written to the insert buffer correctly. The dictionary information for the new InnoDB format (dummy_index) is constructed improperly.