MySQL Bugs: #53847: Renaming of view/routine generates drop statement only

Bug #53847	Renaming of view/routine generates drop statement only
Submitted:	20 May 2010 10:36	Modified:	26 May 2010 13:02
Reporter:	Sergei Tkachenko	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.21	OS:	Any
Assigned to:	Alexander Musienko	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When renaming views or routines using live editors, generated alter script contains only drop statements.

How to repeat:
Create view (or routine). Use live editor to change its name property and apply made changes. Wizard shows alter script it's going to apply to database. The generated script contains "drop" statement and misses "create" statement to recreate the object with new name.

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

In the SQL Editor, when renaming views or routines using the live editor, the generated ALTER script contained only drop statements, CREATE statements being omitted.