MySQL Bugs: #86292: Will the Data Dictionary allow for RENAME DATABASE?

Bug #86292	Will the Data Dictionary allow for RENAME DATABASE?
Submitted:	12 May 2017 4:59	Modified:	9 Feb 2018 6:51
Reporter:	Rick James	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:	8.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	data dictionary, DDL, rename database

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
5.1 added, then removed, RENAME DATABASE.  Perhaps 8.0's Data Dictionary provides a way to overcome the problem encountered?

(Revisiting https://bugs.mysql.com/bug.php?id=37074 )

How to repeat:
RENAME DATABASE a TO b;  -- syntax error

Suggested fix:
Rethink the implementation.

As described at http://dev.mysql.com/doc/refman/5.1/en/rename-database.html: "This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23."

Hello Rick,

Thank you for the feature request!

Thanks,
Umesh