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:
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

[29 Dec 2004 18:48] Marko Mäkelä
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.