MySQL Bugs: #66377: Workbench crashes when Routine-Group (Editor) is closed

Bug #66377	Workbench crashes when Routine-Group (Editor) is closed
Submitted:	14 Aug 2012 13:17	Modified:	21 Aug 2012 10:28
Reporter:	Christian Ungur	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S1 (Critical)
Version:	5.2.41, 5.2.42	OS:	MacOS (Snow Leopard)
Assigned to:		CPU Architecture:	Any

Description:
Workbench crashes once the Routine-Group-Editor is closed, when certain Routines were inserted @see "How to repeat".

Possibly this Issue is only related to my system!?
Please see the attachment for the OS X - error report

How to repeat:
1) Open a new Model
2) Create a new Routine-Group
3) Doubleclick on Routine-Group to Edit
4) Click Tab 
5) Insert subsequent  Routines
6) Closing the Routine-Editor leads to total Crash

-- --------------------------------------------------------------------------------
-- routines1 Group Routines
-- --------------------------------------------------------------------------------
DELIMITER $$

CREATE FUNCTION areakey_sequence_value( club_key INT ) RETURNS INT
DETERMINISTIC
READS SQL DATA
begin
    DECLARE max int;
    SELECT max(`AreaKey`) INTO max
    FROM `club_area_Areas`
    WHERE `club_area_Areas`.`ClubKey` = club_key;
    RETURN coalesce( max, 0 ) + 1;
end$$

CREATE FUNCTION coursekey_sequence_value( club_key INT, area_key INT ) RETURNS INT
DETERMINISTIC
READS SQL DATA
begin
    DECLARE max int;
    SELECT max(`CourseKey`) INTO max
    FROM `club_course_Courses`
    WHERE `club_course_Courses`.`ClubKey` = club_key
        AND `club_course_Courses`.`AreaKey` = area_key;
    RETURN coalesce( max, 0 ) + 1;
end$$

CREATE FUNCTION messagekey_sequence_value( device_key INT ) RETURNS INT
DETERMINISTIC
READS SQL DATA
begin
    DECLARE max int;
    SELECT max(`MessageKey`) INTO max
    FROM `device_Message`
    WHERE `device_Message`.`DeviceKey` = device_key;
    RETURN coalesce( max, 0 ) + 1;
end$$

CREATE FUNCTION sectorkey_sequence_value( club_key INT, area_key INT ) RETURNS INT
DETERMINISTIC
READS SQL DATA
begin
    DECLARE max int;

    SELECT max(`SectorKey`) INTO max
	FROM `club_sector_Sectors`
	WHERE `club_sector_Sectors`.`ClubKey` = club_key
		AND `club_sector_Sectors`.`AreaKey` = area_key;

    RETURN coalesce( max, 0 ) + 1;
end$$

Please try new version 5.2.42. Thanks.

I downloaded the new Version 5.2.42 (Rev. #9752). This Version seems to work better. Still some crashes but less buggy.

Sometimes I'm also getting with this Version this Issue.
Unfortunately I'm also getting comparable Issues with the Trigger-Editor.

Creating a Routine-Group in a new empty Model also crashes Workbench.

I tried to insert subsequent function into the empty routine group:

-- --------------------------------------------------------------------------------
-- Geometrie Group Routines
-- --------------------------------------------------------------------------------
DELIMITER $$

create function text_to_polygon( area text ) returns polygon
begin
    declare continue handler for sqlexception return null;
    return GeomFromText( CONCAT( 'Polygon(', area, ')' ) );
end$$

create function text_to_point( point varchar(45) ) returns point
begin
    declare continue handler for sqlexception return null;
    return GeomFromText( CONCAT( 'Point(', point, ')' ) );
end$$

I can not repeat this with 5.2.42 on Mac OS X 10.5.6.

Like I said. I do not exclude that it is a local Issue of mine. Workbench is pretty unstable from time to time. I'll reinstall/update my OS and will give a feedback later.