Bug #55822 Unexpected Error alert on right-click of routine name in Object Browser
Submitted: 7 Aug 2010 20:45 Modified: 3 Sep 2010 15:54
Reporter: Dave Nechodom Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S2 (Serious)
Version:5.2.26 CE OS:Windows (XPsp3 + Win7Ent)
Assigned to: Alfredo Kojima CPU Architecture:Any
Tags: alert, Object Browser, right-click

[7 Aug 2010 20:45] Dave Nechodom
Description:
It's not known this issue is database version specific. The version under test is 5.0.24a_ce, running on multiple 8x Xeon/64 3.0GHz hosts w/ 16Gb RAM, 500Gb SATA HD, with Workbench running on XP and Windows 7 boxes. Import/export of database files performed using WB5.2.26 via SSH. Alert appears when right-clicking in the Object Browser on an existing routine name in a database schema with no tables. Several files are attached.

How to repeat:
Control:
Import file 'mysql_5.0.24a_schema_test_with_table.sql'
    Schema is named 'test1'
Open new instance of SQL Editor
Open 'test1' in Object Browser
Open 'Routines' section
Right-click routine 'sp_test_add'
Observe correct popup context menu, see 'mysql_wb5.2.26_20100807_popupmenu.jpg'

Test 1:
Using SQL Editor, 'test1' schema from Control step,
Drop table 'tb_test' by right-click in Object Browser
Open 'Routines' section
Right-click routine 'sp_test_add'
Observe Unexpected Error alert, see 'mysql_wb5.2.26_20100807_alert.jpg'

Test 2:
Import file 'mysql_5.0.24a_schema_test_no_table.sql'
    Schema is named 'test2'
Open new instance of SQL Editor
Open 'test2' in Object Browser
Open 'Routines' section
Right-click routine 'sp_test_add'
Observe Unexpected Error alert, see 'mysql_wb5.2.26_20100807_alert.jpg'

Suggested fix:
Offer accurate explanation for error alert.
[7 Aug 2010 20:46] Dave Nechodom
test1 schema

Attachment: mysql_5.0.24a_schema_test_no_table.sql (application/octet-stream, text), 2.42 KiB.

[7 Aug 2010 20:46] Dave Nechodom
test2 schema

Attachment: mysql_5.0.24a_schema_test_with_table.sql (application/octet-stream, text), 3.02 KiB.

[7 Aug 2010 20:46] Dave Nechodom
alert screenshot

Attachment: mysql_wb5.2.26_20100807_alert.jpg (image/jpeg, text), 129.85 KiB.

[7 Aug 2010 20:47] Dave Nechodom
expected screenshot

Attachment: mysql_wb5.2.26_20100807_popupmenu.jpg (image/jpeg, text), 45.35 KiB.

[7 Aug 2010 20:48] Dave Nechodom
Please consider modifying the Report Bug file uploader to accept multiple files.
[8 Aug 2010 5:31] MySQL Verification Team
Thank you for the bug report.
[25 Aug 2010 18:37] Alfredo Kojima
Marked bug #55922 and bug #56265 as duplicates
[25 Aug 2010 19:17] Alfredo Kojima
fixed
[26 Aug 2010 16:24] Johannes Taxacher
fix confirmed in repository
[3 Sep 2010 15:54] Tony Bedford
An entry has been added to the 5.2.27 changelog:

In the SQL Editor, right-clicking on a routine name in the Object Browser caused MySQL Workbench to exit unexpectedly.