Bug #80165 ALTER TABLE ... DROP opt_column field_ident opt_restrict

• Submitted: 27 Jan 2016 2:37
• Modified: 11 Jul 2017 11:11
• Reporter: William ZHANG
• Status: No Feedback
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.6, 5.7
• OS: Any
• CPU Architecture: Any

[27 Jan 2016 2:37] William ZHANG

Description:
As we can see from the SQL parser file located at https://github.com/mysql/mysql-server/blob/5.7/sql/sql_yacc.yy, ALTER TABLE ... DROP COLUMN can accept the RESTRICT and CASCADE keywords at line 8140,

DROP opt_column field_ident opt_restrict

But the document does not mention it,

http://dev.mysql.com/doc/refman/5.7/en/alter-table.html

How to repeat:
Read the parser file and the document.

Suggested fix:
Fix the document.

[27 Jan 2016 6:23] MySQL Verification Team

Hello William,

Thank you for the report.

Thanks,
Umesh