Bug #6659 SHOW CREATE TABLE outputs MEMORY as HEAP
Submitted: 16 Nov 2004 10:11 Modified: 20 Jan 2005 18:41
Reporter: Tobias Asplund Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.7 OS:Any (All)
Assigned to: Jim Winstead CPU Architecture:Any

[16 Nov 2004 10:11] Tobias Asplund
Description:
Since the name of HEAP is changing/has been changed to MEMORY it should also be the output of SHOW CREATE TABLE.

How to repeat:
mysql> CREATE TABLE t28 ( a INT ) ENGINE = MEMORY;
Query OK, 0 rows affected (0.02 sec)

mysql> SHOW CREATE TABLE t28 \G
*************************** 1. row ***************************
       Table: t28
Create Table: CREATE TABLE `t28` (
  `a` int(11) default NULL
) ENGINE=HEAP DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
[14 Jan 2005 2:15] Jim Winstead
New patch made, for 5.0 tree that also still reports HEAP when sql_mode & MYSQL323.
[15 Jan 2005 18:59] Jim Winstead
Fixed in 5.0 tree.
[20 Jan 2005 18:41] Paul Dubois
Mentioned in 5.0.3 change notes.