Bug #74358 user defined tablespaces not in i_s.tablespaces

• Submitted: 13 Oct 2014 14:10
• Modified: 12 May 2015 5:14
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: InnoDB storage engine
• Severity: S4 (Feature request)
• Version: 5.7.5-labs-preview
• OS: Any
• CPU Architecture: Any
• Tags: innodb, Tablespace

[13 Oct 2014 14:10] Daniël van Eeden

Description:
If I create a InnoDB tablespace it is not listed in information_schema.tablespaces only in information_schema.innodb_sys_tablespaces.

How to repeat:
create tablespace foo add datafile 'foo.ibd';
create table foo1 (id int) tablespace=foo;
create table foo2 (id int) tablespace=foo;
select * from information_schema.innodb_sys_tablespaces where name='foo';
select * from information_scheam.tablespaces;

[13 Oct 2014 14:11] Daniël van Eeden

mysql> create tablespace foo add datafile 'foo.ibd';
Query OK, 0 rows affected (0.00 sec)

mysql> create table foo1 (id int) tablespace=foo;
Query OK, 0 rows affected (0.00 sec)

mysql> create table foo2 (id int) tablespace=foo;
Query OK, 0 rows affected (0.01 sec)

mysql> select * from information_schema.innodb_sys_tablespaces where name='foo';
+-------+------+------+-------------+------------+-----------+---------------+-----------+----------------+------------+
| SPACE | NAME | FLAG | FILE_FORMAT | ROW_FORMAT | PAGE_SIZE | ZIP_PAGE_SIZE | FILE_SIZE | ALLOCATED_SIZE | SPACE_TYPE |
+-------+------+------+-------------+------------+-----------+---------------+-----------+----------------+------------+
|    24 | foo  | 2048 | Any         | Any        |     16384 |             0 |    114688 |         122880 | General    |
+-------+------+------+-------------+------------+-----------+---------------+-----------+----------------+------------+
1 row in set (0.00 sec)

mysql> select * from information_schema.tablespaces;
Empty set (0.00 sec)

[12 May 2015 5:14] Erlend Dahl

Thank you for the feature request.