Description:
If I create a MyISAM table with a tablespace,
the tablespace information is preserved.
If I create a Falcon table with a tablespace,
the tablespace information is preserved.
If I alter a Falcon table to a MyISAM table,
the tablespace information is destroyed.
Either CREATE is wrong or ALTER is wrong.
I'd prefer to say that ALTER is wrong.
How to repeat:
mysql> create tablespace ta add datafile 'ta' engine=falcon;
Query OK, 0 rows affected (0.01 sec)
mysql> create table t_1 (s1 int) tablespace ta engine=falcon;
Query OK, 0 rows affected (0.37 sec)
mysql> show create table t_1;
+-------+---------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+---------------------------------------------------------------------------------------------------------------------+
| t_1 | CREATE TABLE `t_1` (
`s1` int(11) DEFAULT NULL
) /*!50100 TABLESPACE `ta` */ ENGINE=Falcon DEFAULT CHARSET=latin1 |
+-------+---------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> create table t_2 (s1 int) tablespace ta engine=myisam;
Query OK, 0 rows affected (0.01 sec)
mysql> show create table t_2;
+-------+---------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+---------------------------------------------------------------------------------------------------------------------+
| t_2 | CREATE TABLE `t_2` (
`s1` int(11) DEFAULT NULL
) /*!50100 TABLESPACE `ta` */ ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+---------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> alter table t_1 engine=myisam;
Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> show create table t_1;
+-------+-----------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------------------------+
| t_1 | CREATE TABLE `t_1` (
`s1` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+-----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
