Bug #29517 SHOW CREATE TABLE for falcon does not show tablespace clause.
Submitted: 3 Jul 2007 13:35 Modified: 21 Oct 2007 23:41
Reporter: Robin Schumacher Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: Christopher Powers CPU Architecture:Any

[3 Jul 2007 13:35] Robin Schumacher
Description:
SHOW CREATE TABLE for falcon does not show tablespace clause

How to repeat:
Create falcon table in tablespace and then issue SHOW CREATE TABLE
[3 Jul 2007 15:04] Miguel Solorzano
Thank you for the bug report.

c:\dev\6.0>bin\mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 6.0.1-alpha-nt Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database gimf;
Query OK, 1 row affected (0.00 sec)

mysql> use gimf
Database changed
mysql> create tablespace gimfdata1
    -> add datafile 'gimf1.fts'
    -> engine=falcon;
Query OK, 0 rows affected (0.13 sec)

mysql> create table tb1 (id serial, col1 char(20))
    -> tablespace gimfdata1 engine=falcon;
Query OK, 0 rows affected (0.16 sec)

mysql> insert into tb1 values (NULL,'test');
Query OK, 1 row affected (0.00 sec)

mysql> show create table tb1\G
*************************** 1. row ***************************
       Table: tb1
Create Table: CREATE TABLE `tb1` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `col1` char(20) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=Falcon DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql>
[21 Oct 2007 23:41] Christopher Powers
Unable to recreate in latest codebase (public and team repositories). Output from SHOW CREATE TABLE now includes TABLESPACE clause.
[22 Oct 2007 11:07] Hakan Küçükyılmaz
[13:07] root@test>show create table tb1\G
*************************** 1. row ***************************
       Table: tb1
Create Table: CREATE TABLE `tb1` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `col1` char(20) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) /*!50100 TABLESPACE gimfdata1 */ ENGINE=Falcon DEFAULT CHARSET=latin1
1 row in set (0.00 sec)