Bug #23750 server crash on SELECT if underlying table is differently defined

• Submitted: 29 Oct 2006 15:04
• Modified: 6 Feb 2007 12:06
• Reporter: Sergey Vojtovich
• Status: Closed
• 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:04] 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);
CREATE TABLE t1(a INT, b TEXT);
INSERT INTO t1 VALUES(0xffffffff, '');
SELECT * FROM tm1;
DROP TABLE tm1, t1;

[29 Oct 2006 15:15] MySQL Verification Team

Thank you for the bug report. Verified as described.

[6 Feb 2007 12:06] 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.