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.
