Bug #39889 Query browser freezes - when creating stored procedure (lost procedure)

• Submitted: 6 Oct 2008 16:57
• Modified: 14 Nov 2008 6:15
• Reporter: Mark Fin
• Status: No Feedback
• Category: MySQL Query Browser
• Severity: S4 (Feature request)
• OS: Any
• CPU Architecture: Any
• Tags: freezes, Mysql Query Browser, stored procedure

[6 Oct 2008 16:57] Mark Fin

Description:
When creating a stored procedure with the MySQL Query Browser, the procedure is first dropped, then will try to create the new procedure - but if there are any errors when trying to create the new procedure, it will display a huge pop-up error message, and on occasion (with Linux) the Query Browser freezes.

So it's only managed to drop the procedure and hasn't been able to create a new one due to the Query Browser freezing. And you've lost your work (which is quite annoying).

How to repeat:
As above.

Suggested fix:
Have the user execute the drop/create procedure in this order:

1. Create a variable that holds the users stored procedure.
2. Syntax parse the variable.
3. Drop old procedure.
4. Then create new procedure from variable.

[14 Oct 2008 6:15] Valeriy Kravchuk

Thank you for a problem report. What exact version of Query Browser do you use? Can you provide a repeatable test case to demonstrate the problem?

[15 Nov 2008 0: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".