MySQL Bugs: #90125: MySQL Workbench reverts stored procedure changes if they cannot be applied

Bug #90125	MySQL Workbench reverts stored procedure changes if they cannot be applied
Submitted:	19 Mar 2018 12:36	Modified:	20 Mar 2018 7:47
Reporter:	Jonathan Shyman	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	6.3.10	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
When executing a long-running query in one query tab and attempting to modify an existing stored procedure in another, MySQL workbench will reject the stored procedure update/apply with a std::exception error and then will revert any changes made in the stored procedure.

While the blocking is understandable, though older (< 6.1.7) versions of Workbench did not behave this way, the reversion of changes is inconvenient and a significant time waster.

How to repeat:
1. Connect to a database and open a query tab
2. Run a long running query
3. Modify an existing stored procedure in the same database connection. It will open in a new tab.
4. Hit apply to apply the changes.
5. Get the std::exception error
6. Notice any changes made to the stored procedure were reverted

Suggested fix:
Behavior up to step 5 is expected.

Step 6 shouldn't happen

Hello Jonathan,

Thank you for the report.
This is observed even with WB 6.3.10 on Win7.
Stored procedure changes are reverted as soon as we click "back" or "finish" or even close the pop up dialog box's "x".

Thanks,
Umesh

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.