MySQL Bugs: #34583: Crash in ALTER TABLE t1 CHANGE c4 c3 BLOB;

Bug #34583	Crash in ALTER TABLE t1 CHANGE c4 c3 BLOB;
Submitted:	15 Feb 2008 11:35	Modified:	28 Oct 18:10
Reporter:	Martin Skold
Status:	Closed
Category:	Server: Cluster	Severity:	S2 (Serious)
Version:	mysql-5.1-telco-6.2	OS:	Linux (debx86-b 2.6.8-3-686-smp)
Assigned to:	Frazer Clement	Target Version:	6.0
Triage:	Triaged: D1 (Critical)

Description:
ndb_team.rpl_ndb_dd_advance    [ fail ]

mysqltest: At line 157: query 'ALTER TABLE t1 CHANGE c4 c3 BLOB' failed: 2013: L
ost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
**** Show second set of ALTERs on SLAVE ****
SHOW CREATE TABLE t1;
Table   Create Table
t1      CREATE TABLE `t1` (
  `c1` int(11) NOT NULL,
  `c2` int(11) NOT NULL,
  `c3` int(11) NOT NULL,
  `c4` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `c5` double DEFAULT NULL,
  PRIMARY KEY (`c1`),
  UNIQUE KEY `t1_i2` (`c2`),
  KEY `t1_i` (`c2`,`c3`)
) /*!50100 TABLESPACE ts1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=lati
n1
**** Third and last set of alters for test1  ****
ALTER TABLE t1 CHANGE c1 c1 DOUBLE;
ALTER TABLE t1 CHANGE c2 c2 DECIMAL(10,2);
ALTER TABLE t1 DROP COLUMN c3;
ALTER TABLE t1 CHANGE c4 c4 TEXT CHARACTER SET utf8;
ALTER TABLE t1 CHANGE c4 c4 BLOB;
ALTER TABLE t1 CHANGE c4 c3 BLOB;

How to repeat:
uname -a
Linux debx86-b 2.6.8-3-686-smp #1 SMP Tue Dec 5 23:17:50 UTC 2006 i686 GNU/Linux
./mysql-test-run.pl --debug --mysqld=--binlog-format=mixed -suite=ndb_team

Suggested fix:
Handle transaction aborts properly in BLOB code.

Following appear to be duplicates : 
  Bug#45768
  Bug#41674
  Bug#34583

Duplicate of bug#45768

Duplicate according to developer comments; set status to match.

(See BUG#45768)

BUG#41674 and BUG#45768 are duplicates of this bug.

Set status = Documenting.

Documented bugfix in the NDB-6.2.19, 6.3.28, and 7.0.9 changelogs.

See BUG#45768 for changelog info.