pbxt memory table: status is not visible
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
*******
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