Bug #45639 INSERT on MERGE table results in a crash

• Submitted: 21 Jun 2009 14:31
• Modified: 21 Jun 2009 14:44
• Reporter: Jeremy Gardiner
• Status: Can't repeat
• Category: MySQL Server: Merge storage engine
• Severity: S3 (Non-critical)
• Version: 5.0.22
• OS: Windows
• CPU Architecture: Any

[21 Jun 2009 14:31] Jeremy Gardiner

Description:
mysql  Ver 14.12 Distrib 5.0.22, for Win32 (ia32)

CREATE TEMPORARY TABLE u3 (e9 INT) TYPE MRG_MYISAM INSERT_METHOD LAST;

INSERT u3 SET e9=42;

<crash>

Note UNION was omitted from CREATE, should this be compulsory?

Get same result if TEMPORARY is omitted.

How to repeat:
See above.

Suggested fix:
Unknown.

[21 Jun 2009 14:44] MySQL Verification Team

I can repeat it on 5.0.21, but not on recent versions.  So, please upgrade to latest 5.0 version from http://dev.mysql.com/downloads/mysql/5.0.html

mysql> select version();
+-----------------------------+
| version()                   |
+-----------------------------+
| 5.0.79-enterprise-gpl-debug |
+-----------------------------+
1 row in set (0.00 sec)

mysql> CREATE TEMPORARY TABLE u3 (e9 INT) TYPE MRG_MYISAM INSERT_METHOD LAST;
Query OK, 0 rows affected, 1 warning (0.02 sec)

mysql>
mysql> INSERT u3 SET e9=42;
ERROR 1036 (HY000): Table 'u3' is read only
mysql>