pbxt memory table: status is not visible

Bug #719610 reported by shinguz
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
PBXT
New
Undecided
Unassigned

Bug Description

When a PBXT table is converted into a memory table this is not visible with any database means:

ALTER TABLE test STORAGE MEMORY;
Query OK, 131072 rows affected (2.03 sec)
Records: 131072 Duplicates: 0 Warnings: 0

SHOW TABLE STATUS
+------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
| Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment |
+------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
| test | PBXT | 10 | Dynamic | 131072 | 88 | 11535360 | 16777215 | 1609728 | 0 | 131073 | NULL | NULL | NULL | latin1_swedish_ci | NULL | | |
+------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+

SHOW CREATE TABLE TEST\G
*************************** 1. row ***************************
       Table: test
Create Table: CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` varchar(64) DEFAULT NULL,
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=PBXT DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

Neither show create table nor show table status reports this situation. the only possibility is currently to look on the file system.

With NDB we have similar situation. There it is reported as follows with show create table.

CREATE TABLE t1 (
    c1 INT STORAGE DISK,
    c2 INT STORAGE MEMORY
)

Thus I would like to have it:

a) in the show table status output in the create option column and/or
b) in the show create table output:
CREATE TABLE `test` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data` varchar(64) DEFAULT NULL,
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=PBXT DEFAULT CHARSET=latin1 STORAGE MEMORY

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.