| Bug #77102 | 5.7 Introduces CREATE TABLESPACE with different syntax than 5.1-5.6 | ||
|---|---|---|---|
| Submitted: | 20 May 2015 11:53 | Modified: | 21 May 2015 13:06 |
| Reporter: | Andrii Nikitin | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
| Version: | 5.7 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[21 May 2015 13:06]
Paul DuBois
The difference in the 5.6 and 5.7 manuals is by design. 5.7 has no NDB releases yet, Until then, the 5.7 manual does not document NDB syntax. Note this paragraph: https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html " CREATE TABLESPACE is supported with InnoDB as of MySQL 5.7.6. In earlier releases, CREATE TABLESPACE supports NDB, which is the MySQL Cluster storage engine. CREATE TABLESPACE will support NDB in MySQL 5.7 when MySQL Cluster is branched from the MyQL 5.7 code base. The latest version of MySQL Cluster is based on MySQL 5.6. " The "missing" clauses will be added when they apply to some 5.7 release.
Description: Syntax is slightly different in 5.7 : 5.1 - 5.6: CREATE TABLESPACE tablespace_name ADD DATAFILE 'file_name' USE LOGFILE GROUP logfile_group [EXTENT_SIZE [=] extent_size] [INITIAL_SIZE [=] initial_size] [AUTOEXTEND_SIZE [=] autoextend_size] [MAX_SIZE [=] max_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] comment_text] ENGINE [=] engine_name 5.7: CREATE TABLESPACE tablespace_name ADD DATAFILE 'file_name' [FILE_BLOCK_SIZE = value] [ENGINE [=] engine_name] How to repeat: https://dev.mysql.com/doc/refman/5.6/en/create-tablespace.html https://dev.mysql.com/doc/refman/5.7/en/create-tablespace.html Suggested fix: Not sure what it will affect and proper fix - but this looks like a major problem for future NDB integration