Bug #62643 Crash when refresh left menu
Submitted: 6 Oct 2011 14:34 Modified: 6 Nov 2011 14:47
Reporter: D.T. Chang Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.34CE Revision 7780 OS:Windows (win 2003)
Assigned to: CPU Architecture:Any

[6 Oct 2011 14:34] D.T. Chang
Description:
After alter table or view via adding extra columns, then click right button on left tree menu, and then click 'refresh all'. SQL editor may crash after doing 'refresh'. 

How to repeat:
1. create a table, for example: 
   delimiter $$

CREATE TABLE `student_reg_track` (
  `reg_seq` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `track_seq` int(10) unsigned NOT NULL,
  `student_seq` int(10) unsigned NOT NULL,
   PRIMARY KEY (`reg_seq`),
  UNIQUE KEY `reg_inx` (`track_seq`,`student_seq`)
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8$$

2. create a view on it, for example:

delimiter $$

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `track_student` AS select `student_reg_track`.`reg_seq` AS `reg_seq`,`student_reg_track`.`track_seq` AS `track_seq`,`student_reg_track`.`student_seq` AS `student_seq` from `student_reg_track`$$

3. alter table  student_reg_track by adding extra column:

 `is_enabled` char(1) NOT NULL DEFAULT 'Y'

4. right click on left tree menu and then select 'refresh all'
5. SQL editor may crash after step4.
[6 Oct 2011 14:47] Valeriy Kravchuk
Please, check if the same problem still happens with a newer version, 5.2.35.
[7 Nov 2011 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".