Bug #46649 empty routine definitions in information_schema.routines
Submitted: 11 Aug 2009 12:28 Modified: 11 Sep 2009 13:37
Reporter: Artur S Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.17 OS:Any
Assigned to: CPU Architecture:Any
Tags: routine_definition

[11 Aug 2009 12:28] Artur S
When I select data from information_schema.ROUTINES some entries don't have routine_definion - it's empty. However, I can choose these procedures/functions from schemata browser and click 'Edit' - then the routine definition is visible and editable. 

Doesn't this information (routine definition) come from information_schema?

How to repeat:
I don't know how to repeat it. It might be that those routines that have empty definitions were restored from backup and the rest was created later...
[11 Aug 2009 13:37] Miguel Solorzano
Thank you for the bug report. I couldn't repeat too, please re-open if you have a repeatable test case steps. Thanks in advance.
[11 Sep 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".