Bug #23752 server crash on UPDATE if underlying table is differently defined
Submitted: 29 Oct 2006 15:08 Modified: 6 Feb 2007 12:07
Reporter: Sergey Vojtovich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Merge storage engine Severity:S3 (Non-critical)
Version:4.1\5.0\5.1BK OS:Linux (Suse 10.0 32-bit)
Assigned to: Sergey Vojtovich CPU Architecture:Any

[29 Oct 2006 15:08] Sergey Vojtovich 
Description:
Server crash on SELECT if underlying table is differently defined.

How to repeat:
CREATE TABLE tm1(a TEXT, b INT) ENGINE=MERGE UNION=(t1) INSERT_METHOD=LAST;
CREATE TABLE t1(a INT, b TEXT);
INSERT INTO t1 VALUES(0xffffffff, '');
UPDATE tm1 SET a='a', b=1;
DROP TABLE tm1, t1;
[29 Oct 2006 15:24] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[6 Feb 2007 12:07] Sergey Vojtovich 
This bug is fixed in 4.1.23, 5.0.36, 5.1.15. No changelog entry needed,
since it will be documented as WL#3567. The following related bugs are also
fixed by the WL task: bug#457, bug#23750, bug#23751, bug#23752, bug#23753.