This section documents all changes and bug fixes applied since the release of MySQL Workbench 5.0.26.
There was a problem where relationships that were hidden could then not be selected to bring up their relationship editor. Relationships can now be selected as objects in the Layer window. Once selected, the relationship's
visibleproperty can be set to
Truein the Properties window, thus making the relationship visible again. (Bug #40167)
When a stored routine was edited, the edit cursor jumped back to the start of the page unless typing was constant. (Bug #40426)
When using the “S” was missing from “VALUES” and the data was not included. This resulted in SQL code such as:menu item the generated SQL code was incorrect. The
INSERT INTO `table1` (`table1_id`, `descr`) VALUE ();
If a trigger was renamed, and the design then synched with a database instance, the generated SQL created a trigger with the new name and then dropped the trigger with the old name. This resulted in this error:
Error 1235: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
Theaction (right-click menu on table) did not use Windows-compatible line endings. (Bug #39476)
When a column had a data type
BOOLEANand it was exported using , the exported type was
BOOLEAN. (Bug #39257)
Workbench application performance was poor, with slow loading times and excessive memory usage. (Bug #38439)
When a DBDesigner model with 333 tables was imported into Workbench the RAM usage went up to approximately 1GB. Workbench then crashed with this exception:
Error creating cairo context: out of memory