Bug #81334 | MySQL Workbench Program Closes When Trying to View Stored Procedures | ||
---|---|---|---|
Submitted: | 6 May 2016 3:28 | Modified: | 20 Apr 2018 16:08 |
Reporter: | Michal Michalski | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench | Severity: | S2 (Serious) |
Version: | 6.3.6 | OS: | Windows (Microsoft Windows 7 Professional Service Pack 1) |
Assigned to: | CPU Architecture: | Any | |
Tags: | WBBugReporter |
[6 May 2016 3:28]
Michal Michalski
[6 May 2016 15:31]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat using the stored procedures created by the sakila script. Please provide the sql commands to create the stored procedure which presents the behavior you are reported.
[10 May 2016 13:12]
MySQL Verification Team
[Managed to Native Transition] > mforms.wr.dll!MformsTree.OnMouseDown(System.Windows.Forms.MouseEventArgs args) Unknown System.Windows.Forms.dll!System.Windows.Forms.Control.WmMouseDown(ref System.Windows.Forms.Message m, System.Windows.Forms.MouseButtons button, int clicks) Unknown System.Windows.Forms.dll!System.Windows.Forms.Control.WndProc(ref System.Windows.Forms.Message m) Unknown System.Windows.Forms.dll!System.Windows.Forms.NativeWindow.Callback(System.IntPtr hWnd, int msg, System.IntPtr wparam, System.IntPtr lparam) Unknown [Native to Managed Transition] [Managed to Native Transition] System.Windows.Forms.dll!System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(System.IntPtr dwComponentID, int reason, int pvLoopData) Unknown System.Windows.Forms.dll!System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(int reason, System.Windows.Forms.ApplicationContext context) Unknown System.Windows.Forms.dll!System.Windows.Forms.Application.ThreadContext.RunMessageLoop(int reason, System.Windows.Forms.ApplicationContext context) Unknown MySQLWorkbench.exe!MySQL.GUI.Workbench.Program.Main(string[] Args) Unknown
[10 May 2016 16:11]
Michal Michalski
What does all that mean? Can you help me access my Stored Procedures?
[16 May 2016 0:43]
Michal Michalski
CAN SOMEONE PLEASE RESPOND? I CURRENTLY HAVE NO WAY TO ACCESS MY STORED PROCEDURES ON THE DB SERVER.
[16 May 2016 10:15]
MySQL Verification Team
If you have mysql client in your path then you can access/view stored procedure as(in the example below - creating a stored procedure named p1, and later to check procedure code): [root@cluster-repo ~]# mysql -uroot -p test Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.12 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> DELIMITER // mysql> CREATE PROCEDURE p1 () -> BEGIN -> DECLARE fanta INT DEFAULT 55; -> DROP TABLE t2; -> LOOP -> INSERT INTO t3 VALUES (fanta); -> END LOOP; -> END// Query OK, 0 rows affected (0.01 sec) mysql> DELIMITER ; mysql> -- view stored prcedure mysql> SHOW CREATE PROCEDURE p1\G *************************** 1. row *************************** Procedure: p1 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`() BEGIN DECLARE fanta INT DEFAULT 55; DROP TABLE t2; LOOP INSERT INTO t3 VALUES (fanta); END LOOP; END character_set_client: utf8 collation_connection: utf8_general_ci Database Collation: latin1_swedish_ci 1 row in set (0.00 sec) mysql> Also, see http://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html Thanks, Umesh
[20 Apr 2018 16:08]
Miguel Tadeu Mota
Posted by developer: Closed due to no response for more information. Please reopen this bug if needed. Thanks
[22 May 2018 15:31]
Christine Cole
Posted by developer: Fixed as of the upcoming MySQL Workbench 8.0.12 release, and here's the changelog entry: When Alter Stored Procedure was selected from the context menu, MySQL Workbench stopped working. Thank you for the bug report.