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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.062 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.