Bug #13152 bit fields and fields that follow become corrupted when dumped from NDB tables
Submitted: 13 Sep 2005 20:35 Modified: 23 Sep 2005 17:19
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0 OS:Linux (Linux)
Assigned to: Tomas Ulin CPU Architecture:Any

[13 Sep 2005 20:35] Jonathan Miller
Description:
Data can be come corrupt if NDB table contains bit field when dumping database and or alter table to an myisam table.

INSERT INTO `table` VALUES (5,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' ',' ',' ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

Column 23, 24 and 25 are bit colums. The rest are tinyint.

Original values:
INSERT INTO `table` VALUES (5,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,5,5,5,5,5,5,5,5,5,3,2,1);

How to repeat:
See private notes
[14 Sep 2005 9:41] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/29814
[14 Sep 2005 11:24] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/29824
[14 Sep 2005 14:34] Tomas Ulin
fixed in 5.0.13
[15 Sep 2005 18:20] Paul Dubois
Noted in 5.0.13 changelog.
[19 Sep 2005 12:04] Jonathan Miller
Test rpl_bit.test still fails using RBR in wl1012
[19 Sep 2005 12:58] Jonathan Miller
Changed it back since test is based off myisam
[19 Sep 2005 13:39] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/30046
[19 Sep 2005 13:53] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/30048
[20 Sep 2005 4:40] Tomas Ulin
last bugfix had an error, so it was not fixed in 5.0.13
now fixed in 5.0.14
[23 Sep 2005 17:19] Paul Dubois
I've moved the changelog entry from 5.0.13 to 5.0.14.