MySQL Bugs: #13532: checksum table in innodb returns incorrect value

Bug #13532	checksum table in innodb returns incorrect value
Submitted:	27 Sep 2005 18:01	Modified:	27 Sep 2005 18:40
Reporter:	Sergei Golubchik	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:		OS:
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
checksum table for tables with identical contents returns the same value for myisam/heap but different for innodb.

How to repeat:
see innodb.result

This is probably a duplicate of Bug #8552.

Of course, to be robust, CHECKSUM TABLE in MYSQL should be implemented in a way that it would NOT look at the unused bits in the record buffer. It should only look at actual contents of the columns. I guess this bug is a result of looking into unused bits.