This section documents all changes and bug fixes that have been applied since the release of 5.2.3.
Functionality added or changed:
Some keyboard shortcuts have been changed.
On Microsoft Windows and Linux Ctrl+Y is now used for Redo. Mac OS X continues to use Cmd+Shift+Z as its default for Redo. For Synchronize Model, Ctrl+Alt+Y is used on Windows and Linux, and Cmd+Ctrl+Y is used on Mac OS X. (Bug#46285)
Bugs fixed:
When editing a stored routine or trigger in the Table Editor, the cursor would relocate to the top of the editing window if a key was not pressed for a few seconds.
On Windows this issue was fixed in 5.1.18. On Mac OS X this issue was fixed in 5.2.4. On Linux this issue was fixed in 5.2.7.
If a new empty EER diagram was created, then Model, Relationship Notation, Connect to Columns was selected, MySQL Workbench generated the following messages:
** Message: item_activated: 0x28d5cf0 -> 'plugin:wb.view.setRelationshipNotation:fromcolumn' ** Message: unhandled message 4: wb.view.setRelationshipNotation finished in 0.00s
These messages were not generated if the EER diagram contained at least one table. (Bug#47565)
When a model was synchronized, the following incorrect SQL was generated:
CREATE TABLE IF NOT EXISTS `synthescom`.`adx_clienti` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `citta` VARCHAR(100) NULL DEFAULT NULL , `provincia` VARCHAR(100) NULL DEFAULT NULL , PRIMARY KEY (`id`) ENGINE = MyISAM DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci;
Note that the closing parenthesis, which should have been located after the PRIMARY KEY statement, is missing. This resulted in the following error being generated:
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE = MyISAM DEFAULT CHARACTER SET = utf8 COLLATE = utf8_general_ci' at line 13
When a table was opened for editing in the Query Editor, the
DECIMAL
column values appeared in the result
set as integer values, disregarding precision and scale
settings. The fractional part of the number was discarded. It
was also not possible to add the fractional part of the number
during editing.
(Bug#47405)
In the EER Diagram, Layer names were not rendered. This only happened with OpenGL rendering (only on Microsoft Windows). (Bug#47385)
When the Query Database menu option was selected, the explorer on the right-hand side displayed Tables, Views and Routines, but when the Routines folder was expanded the routines contained in the model were missing. (Bug#47088)
Clicking the Test Connection button in DB Connection Editor wizard did not appear to have any effect. (Bug#47083)
In the Query Editor, when an attempt was made to expand a schema and select a table, the following exception was generated:
************** Exception Text ************** System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. at MySQL.Grt.TreeModel.expand_node(NodeId node) at MySQL.Grt.GrtTreeModel.TreeViewExpanding(Object sender, TreeViewAdvEventArgs e) at System.EventHandler`1.Invoke(Object sender, TEventArgs e) at Aga.Controls.Tree.TreeViewAdv.OnExpanding(TreeNodeAdv node) at Aga.Controls.Tree.TreeViewAdv.SetIsExpanded(TreeNodeAdv node, Boolean value) at Aga.Controls.Tree.TreeViewAdv.SetIsExpanded(ExpandArgs eargs) at Aga.Controls.Tree.TreeViewAdv.SetIsExpanded(TreeNodeAdv node, Boolean value, Boolean ignoreChildren) ...
On Mac OS X using cmd + backspace to delete a column in the table editor did not work. (Bug#46613)
MySQL Workbench EER Diagram view did not allow the creation of a foreign key constraint on a primary key. (Bug#39546)