MySQL Bugs: #46430: Stored Routine should release resources after each block and after finishing

Bug #46430	Stored Routine should release resources after each block and after finishing
Submitted:	28 Jul 2009 14:20	Modified:	28 Jul 2009 14:43
Reporter:	Oli Sennhauser	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S4 (Feature request)
Version:	5.x	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Stored Routine release resource

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
It looks like when in a Stored Routine (SP/SF) some resources are allocated (in a loop) they are not release appropriately as can be seen by the example of the customer.

Ideally this should be done after each block.

How to repeat:
See example in issue.

Suggested fix:
Release resources after end of Stored Program or after end of a block.