This section documents all changes and bug fixes applied since the release of MySQL Workbench 5.2.2.
In the Inserts tab of the Table Editor, if a value was entered with quoting then any characters in the string requiring escaping were not escaped. However, if the same string was entered without quoting then the string would be escaped correctly by MySQL Workbench.
For 5.0 and 5.1 this is expected behavior. If a value is entered without leading and trailing quotation marks, the Inserts Editor adds quoting and escapes characters that require it. However, if quoted text is entered, the Inserts Editor carries out no further checks because it assumes a correctly escaped and quoted sequence has been entered.
5.2 features a new Inserts Editor. In this case the user enters the string without quoting or escaping and the Inserts Editor takes care of all quoting and escaping as required. (Bug #38906)
In the Forward Engineer SQL CREATE script wizard, in the dialog asking for confirmation to overwrite an existing file, clicking the button led to the wizard proceeding to the next step, while clicking the button led to cancellation of the action. The functionality of the buttons appeared to be reversed. (Bug #47257)
When adding inserts with a
NULLvalue in a column, MySQL Workbench incorrectly added single quotation marks to the NULL value.Note
Note, when entering a
NULLvalue right-click the button next to the value and select Set selection to NULL, otherwise
NULLwill be interpreted as a string literal.
MySQL Workbench crashed on launch on OS X 10.6.0. (Bug #46953)
If the Default Storage Engine was selected as
MyISAMin the Model Options dialog, when a new table was created in the EER Diagram it was found to have a storage engine type of
InnoDB. (Bug #46752)
When a model containing invalid/broken foreign key definitions was loaded into MySQL Workbench, the errors were detected and repaired.
However, when the model was saved and reloaded it contained changed data types. All
INTEGERcolumns were changed to
INTEGER(11). Further, some
BOOLEANcolumns were changed to
BOOLEAN(1). (Bug #46467)
If the Table Editor had been invoked then the Text Boxes in the, dialog became vertically misaligned. This only happened for MySQL Workbench running on OS X. (Bug #46255)
When a connection was selected in the DB Connection Editor it appeared to flicker a number of times before MySQL Workbench crashed. (Bug #46065)
When a database with Stored Procedures was reverse-engineered into MySQL Workbench the Stored Procedures were not displayed in the Routine Editor, and so could not be edited. (Bug #45704)
When running MySQL Workbench on OS X, if a table was added to the model diagram and deleted the application crashed. This happened for a new diagram from a schema imported from a live database. (Bug #45692)
During Forward Engineering, clicking thebutton generated code that contained an extra newline per line. (Bug #45579)
Attempts to rebuild the MySQL Workbench source RPM failed. The RPM appeared to contain an unmodified template
mysql-workbench.spec.ininstead of the correct spec file with variable placeholders replaced by actual values.
When using the following command to rebuild the RPM:
shell> rpmbuild -ba --clean SPECS/mysql-workbench.spec.in
This error was generated:
error: File /usr/src/packages/SOURCES/mysql-workbench-oss-@VERSION@.tar.gz: No such file or directory
Further, the spec file in the package had the incorrect suffix “.spec.in” instead of “.spec”. (Bug #45515)
On OS X, it was not possible to resize a Text Object on the EER Diagram canvas. (Bug #45472)
References: See also: Bug #39887.
It was not possible to assign columns to indexes because the Column check boxes did not respond to mouse events. (Bug #45260)
MySQL Workbench generated a segmentation fault when clicking either the NN or AI check boxes on the Columns tab of the Table Editor. (Bug #45075)
In the Columns tab of the Table Editor, if the column was of type
ENUMand was given a default value, when an attempt was made to forward engineer the schema it would not validate. (Bug #44368)
In the Physical Schemata pane if more schema were added than could fit within the pane, these schema could not be viewed because there was no ability to scroll the pane. Further, double-clicking the schema in the Catalog pane did not locate the schema in the Physical Schemata pane.
MySQL Workbench was changed so that a small down arrow button was added to the right side of the Physical Schemata tab bar. This provides a list to select a specific schema tab. (Bug #39735)
When, was selected from the main menu, it was not possible to copy MySQL Workbench version information to the clipboard. (Bug #39610)
When a diagram was exported as PNG it used the height and width of the model as displayed in the EER Diagram. This resulted in the exported picture being too small or too large, rather than being scaled to a consistent size. (Bug #36226)