MySQL Bugs: #32295: Redefining View in Administrator GUI Mac Leopard Crashes

Bug #32295	Redefining View in Administrator GUI Mac Leopard Crashes
Submitted:	12 Nov 2007 20:49	Modified:	19 May 2009 12:59
Reporter:	Craig Armstead	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	MacOS (Leopard, Tiger)
Assigned to:		CPU Architecture:	Any
Tags:	Redefining View in Administrator GUI Mac Leopard Crashes

Description:
Trying to redefine an incorrect view definition due to table field name changes causes the GUI to crash.
The SQL statement produced can be pasted directly into phpMyAdmin with no errors.

CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`cra`@`%` SQL SECURITY DEFINER VIEW `v_costctr_txt` AS select `client_costcntr`.`cost` AS `costcenter`,`client_costcntr`.`desc` AS `description` from `client_costcntr`

Any changes to editing view definitions cause the GUI to crash if you try to execute the change!
Viewing the SQL is fine. 

How to repeat:
Change the field names of a table where a view already exists.  Then edit the view to correct the field name mappings. 

Suggested fix:
Don't crash, execute command !

Thank you for the report.

Verified as described on Tiger.

Crashes on simply clicking "create view" for me -- mac os x 10.5.2

Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/