Bug #10039 MEMORY engine is reported as HEAP

Submitted: 20 Apr 2005 17:29 Modified: 25 Apr 2005 16:26
Reporter: Stefan Hinz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.4-beta-Max-log OS:Linux (SuSE Linux 9.3)
Assigned to: Guilhem Bichot CPU Architecture:Any

[20 Apr 2005 17:29] Stefan Hinz
Description:
Setting the storage_engine var to MEMORY succeeds, but what's reported isn't MEMORY, but still HEAP.

How to repeat:
mysql> SELECT VERSION();
+--------------------+
| VERSION()          |
+--------------------+
| 5.0.4-beta-Max-log |
+--------------------+
1 row in set (0.00 sec)

mysql> SELECT @@global.storage_engine, @@local.storage_engine;
+-------------------------+--------------------------+
| @@global.storage_engine | @@session.storage_engine |
+-------------------------+--------------------------+
| MyISAM                  | MyISAM                   |
+-------------------------+--------------------------+
1 row in set (0.00 sec)

mysql> SET GLOBAL storage_engine = MEMORY;
Query OK, 0 rows affected (0.01 sec)

mysql> SET LOCAL storage_engine = MEMORY;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @@global.storage_engine, @@local.storage_engine;
+-------------------------+--------------------------+
| @@global.storage_engine | @@session.storage_engine |
+-------------------------+--------------------------+
| HEAP                    | HEAP                     |
+-------------------------+--------------------------+
1 row in set (0.00 sec)

Suggested fix:
Make it report MEMORY.
[22 Apr 2005 22:07] Guilhem Bichot
Fixed in 5.0.5
ChangeSet@1.1879, 2005-04-23 00:05:05+02:00, gbichot@quadita2.mysql.com
[25 Apr 2005 16:26] Paul DuBois
Noted in 5.0.5 changelog.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.