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
• Status: Can't repeat
• 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] MySQL Verification Team

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)