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

[28 Jul 2009 14:20] Oli Sennhauser
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.