Bug #75935 InnoDB: Add TABLESPACE support for native partitioning

• Submitted: 17 Feb 2015 16:29
• Modified: 23 Mar 2015 14:48
• Reporter: Kevin Lewis
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.7.7
• OS: Any
• CPU Architecture: Any

[17 Feb 2015 16:29] Kevin Lewis

Description:
Version 5.7.6 saw the addition of two new features:
  wl#6035: InnoDB Native Partitioning
  wl#6205: InnoDB Support for general shared tablespaces

The two were merged together, but not integrated.  Specifically, each partition and sub-partition should be able to be assigned its own tablespace.

How to repeat:
See this section in mysql-test/suite/innodb/t/create_tablespace.test:

--echo #
--echo # Put all partitions of a table into a general tablespace.
--echo # Show that individual partitions  and subpartitions ignore the
--echo # tablespace command.
--echo #

Suggested fix:
Allow each partition to be assignedits own tablespace.

[23 Mar 2015 14:48] Daniel Price

Posted by developer:
 
Fixed as of the upcoming 5.7.8, 5.8.0 releases, and here's the changelog entry:

General tablespaces now support partitioned "InnoDB" tables, and
individual partitions and subpartitions can now be assigned to a general
tablespace. "SHOW CREATE TABLE" output was revised to include quotes
around the tablespace identifier. 

Thank you for the bug report.