MySQL Bugs: #70016: Workbench crashes when right-clicking on a function

Bug #70016	Workbench crashes when right-clicking on a function
Submitted:	13 Aug 2013 15:38	Modified:	26 Sep 2013 20:58
Reporter:	Christian Bartels	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S2 (Serious)
Version:	6.0.6.11184	OS:	MacOS
Assigned to:		CPU Architecture:	Any

Description:
When opening a server connection through a SSH tunnel, Workbench connects to the server and lists all the databases present on the server. Selecting a database fetches all tables, views, stored procedures and functions. When right-clicking on a function, Workbench instantly crashes.

How to repeat:
See description

Would it be possible to dump the code for the routine you right clicked?

I couldn't repeat using the sakila database and right click on a its function, please provide the sql(s) command(s) to create the function which present this issue. Below my hardware:

hread started
/Applications/MySQLWorkbench.app/Contents/Resources/libraries/paramiko/client.py:95: UserWarning: Unknown ssh-rsa host key for 192.168.2.119: d6be96bcd41d4b09914c05a7c96ec7b0
  (key.get_name(), hostname, hexlify(key.get_fingerprint())))
MySQL Workbench Community (GPL) for Mac OS X version 6.0.6  revision 11184
Configuration Directory: /Users/miguel/Library/Application Support/MySQL/Workbench
Data Directory: /Applications/MySQLWorkbench.app/Contents/Resources
Cairo Version: 1.9.1
OS: OS X 10.8.x Mountain Lion
CPU: 4x Intel(R) Core(TM) i5-3210M CPU @ 2.50GHz, 16.0 GB RAM

According to the crashlog, it happens during parsing of the function definition. We need the code for the function to be able to repeat the crash. Or at least the part from CREATE until BEGIN, as long as an empty function body still produces the crash.

This is happening for me too.
I think it's happening on all my functions.  But here is one that I first discovered it on.

DELIMITER $$

DROP FUNCTION IF EXISTS `GetZone` $$
CREATE DEFINER=`root`@`%` FUNCTION `GetZone`(Zip integer, DropPt integer) RETURNS smallint(1)
    DETERMINISTIC
BEGIN
    declare myZone integer;
    set myZone = 1;
    return myZone;
END $$

DELIMITER ;

I can repeat with the provided function code.

Same problem here, MySQL Workbench 6.0.6 on Windows 7. Both right-clicking and left-clicking cause the Workbench to crash.

Happens even with the template new_function that the Workbench proposes when adding a new function (I needed only to add the 'deterministic' characteristic to make the function compile on mysql 5.6.13).

Fixed as of MySQL Workbench 6.0.7, and here's the changelog entry:

When right-clicking on a database's function via a server connection
through a SSH tunnel, MySQL Workbench would crash if the function definition
lacked a comment.

Thank you for the bug report.