Bug #94152 ALTER TABLE .. UPGRADE PARTITIONING syntax is no longer supported

• Submitted: 31 Jan 2019 9:49
• Modified: 7 Mar 2019 16:22
• Reporter: Tsubasa Tanaka (OCA)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 8.0.14
• OS: CentOS (7.4)
• CPU Architecture: x86

[31 Jan 2019 9:49] Tsubasa Tanaka

Description:
MySQL 8.0.14 coundn't parse "ALTER TABLE .. UPGRADE PARTITIONING" .
But 8.0 document still describes "UPGRADE PARTITIONING" .

https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html

How to repeat:
- Run mysqld 8.0.14 using docker

$ docker run -d -e MYSQL_ALLOW_EMPTY_PASSWORD=1 -e MYSQL_ROOT_PASSWORD="" -e MYSQL_ROOT_HOST="%" mysql/mysql-server:8.0

- Create sample table

mysql> CREATE DATABASE d1;
Query OK, 1 row affected (0.03 sec)
mysql> CREATE TABLE d1.t1 (num int primary key) PARTITION BY HASH(num) PARTITIONS 10;
Query OK, 0 rows affected (0.10 sec)

- Execute ALTER SQL
mysql> ALTER TABLE d1.t1 UPGRADE PARTITIONING;
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 'UPGRADE PARTITIONING' at line 1

Suggested fix:
Fix the doc and add a release-note about removing "ALTER TABLE .. UPGRADE PARTITIONING"

[31 Jan 2019 9:55] MySQL Verification Team

Hello Tanaka-San,

Thank you for the report and feedback.

regards,
Umesh

[7 Mar 2019 16:22] 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 mysqldoc rev 61157, mysql-relnotes rev 17303.

Closed.