Bug #94131 The "TABLESPACE" syntax of "13.1.9 ALTER TABLE Syntax" has problem
Submitted: 30 Jan 2019 7:25 Modified: 11 Mar 2019 16:47
Reporter: JianJun Shi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:7.2+ OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[30 Jan 2019 7:25] JianJun Shi
Description:
"13.1.9 ALTER TABLE Syntax" chapter in the "MySQL 5.7 Reference Manual" and "MySQL 8.0 Reference Manual" was describe as following:

...
TABLESPACE tablespace_name [STORAGE {DISK|MEMORY|DEFAULT}]
...

Actually, when "TABLESPACE tablespace_name STORAGE " combine with "DEFAULT". We will get back an error message "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT' at line 1". 

How to repeat:
use test;
create tablespace ts1 add datafile 'ts1.ibd';

create table t1 (name char(10)) tablespace ts1 storage DISK;
create table t2 (name char(10)) tablespace ts1 storage MEMORY;
create table t3 (name char(10)) tablespace ts1 storage DEFAULT;
[30 Jan 2019 14:07] MySQL Verification Team
Hi,

Thank you for your bug report.

I fully agree with your conclusions.

Verified as reported.
[11 Mar 2019 13:23] Jon Stephens
I have further verified that the DEFAULT syntax, while once valid, is no longer accepted going back at least as far as NDB 7.3.
[11 Mar 2019 13:43] Jon Stephens
For an interesting bit of history, please see BUG#39315.
[11 Mar 2019 16:47] Jon Stephens
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.

Fixed in docs for NDB 7.2+/MySQL 5.5+, in mysqldoc rev 61197.

Closed.