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

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;

Hi,

Thank you for your bug report.

I fully agree with your conclusions.

Verified as reported.

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.

For an interesting bit of history, please see BUG#39315.

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.

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.