MySQL Bugs: #79129: alter body of trigger, event, function, procedure (create or replace)

Bug #79129	alter body of trigger, event, function, procedure (create or replace)
Submitted:	4 Nov 2015 22:19	Modified:	15 Nov 2015 22:05
Reporter:	Seweryn Ozog	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	alter-body-trigger-event-function-procedure

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Now the only possibility of change body of trigger (but also function, procedure and event ) is drop and next recreate ... it should be possible alter body of trigger / create or replace trigger (but also function, procedure and event).

How to repeat:
not possible / not applicable

Suggested fix:
not possible / not applicable

A long needed feature so application writes / SP executions always work as expected without misses or any need for manual table locking.

All the other major relational databases already have this feature for many years...