MySQL Bugs: #30165: MySQL should support an atomic CREATE OR REPLACE PROCEDURE

Bug #30165	MySQL should support an atomic CREATE OR REPLACE PROCEDURE
Submitted:	31 Jul 2007 23:37	Modified:	7 Dec 2009 18:44
Reporter:	Trent Lloyd	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
MySQL does not currently provide an atomic way to replace the contents of a stored procedure.

You must first drop it, and then create it again.  This can cause problems where an SP may be temporarily unavailable to another thread and cause problems. 

How to repeat:
N/A

Suggested fix:
Having a way to alter stored procedures atomically would fix this and let us use sprocs from triggers safely with replication.

This may be possible by a CREATE OR REPLACE PROCEDURE, or ALTER PROCEDURE or similar.

Thank you for a reasonable feature request.

Marked as duplicate of Bug #9588