This section documents all changes and bug fixes applied to MySQL Workbench since the release of 6.0.7.
Functionality Added or Changed
A new MySQL Workbench preference (Preferences, SQL Editor) was added that sets the default comment type that is generated in the SQL Editor when clicking the "add comment" key combination. It can be either "--" (default) or "#". (Bug #16679373, Bug #68708)
When creating a table on a model diagram, an unhandled NULL reference exception was thrown when a second layer was drawn under some tables. (Bug #17561185, Bug #70518)
Restoring an incremental backup from a remote MySQL server would
emit an unexpected error that referred to the
The Forward Engineer - SQL Create Script
wizard would generate the
privilege at the table level, instead of the database level.
(Bug #17468314, Bug #70310)
On Microsoft Windows, after executing Search Table Data and viewing the results, right-clicking on a row and choosing Copy Query for Matches from the context menu would crash MySQL Workbench. (Bug #17506404, Bug #70411)
On Microsoft Windows 7, under some circumstances MySQL Workbench would not connect to a MySQL server on a RHEL 5 host. (Bug #17516617)
With Use most recent backup checked, an incremental backup made after another incremental backup would not be restored if the previous incremental backup failed. (Bug #17509626)
In the data result grid, selecting multiple fields and choosing Set Field(s) not Null from the context-menu would not alter the data. (Bug #17495179, Bug #70381)
When forward engineering an
script, checking the Omit Schema Qualifier
preference would correctly remove the schema name from the
CREATE statements, but it incorrectly left the schema name on
the GRANT statements.
Command sequence: File, Export, Forward engineer SQL CREATE script. (Bug #17516695, Bug #70438)
On Microsoft Windows, having an empty SQL file saved in the AppData path would cause MySQL Workbench to not start.
A workaround was to delete the empty SQL file before starting MySQL Workbench. (Bug #17512088, Bug #70262)
On Linux, the Action Output would not auto scroll to place the latest action (executed SQL statement) in view. (Bug #17512005, Bug #70421)
An empty SQL script file could not be saved from within MySQL Workbench, and attempting this action would generate an unexpected error. (Bug #17468833, Bug #70365)
Executing Forward Engineer the Model to the local DB would generate an unexpected error. (Bug #17496362)
Backup operations now use the SOCKET protocol on Linux to make connections, and on Windows it uses TCP (if networking is enabled), as otherwise PIPE is used. (Bug #17440001, Bug #70295)
MySQL Workbench now uses the
option when executing mysqlbackup.
(Bug #17439084, Bug #70293)
Clicking Alter Table on a table with multiple triggers would sometimes generate an error. Trigger handling was improved to avoid such errors. (Bug #17432083, Bug #70244)
On Linux, improvements were made to the check that tested if the
backup directory was writable. This check now uses the Linux
test command, instead of a temporary file
(Bug #17439061, Bug #70292)
When exporting a model with multiple routines as an SQL Script, under some circumstances a deliminator was missing after a routine in the generated SQL. (Bug #17448702, Bug #70313)
Scrolling down an SQL file and executing a statement (Control + Enter) would scroll the window back to the top. The cursor now remains, even when the window is resized. (Bug #17399972, Bug #15837541, Bug #70221, Bug #67465)
fetch_documentation.sh script was
removed from the MySQL Workbench source download, as it referred to
(and required) fetching documentation from internal URLs.
(Bug #17435353, Bug #70279)
An unhandled exception would be thrown if the
audit.log file was missing.
(Bug #17452099, Bug #70323)
Data Import/Export for self-contained data will now only select
*.sql files by default, and if an extension
is not defined during an export, the extension will be set to
(Bug #17449969, Bug #69069)
On Mac OS X, opening a new model and pressing the "Add EER Diagram" button from the toolbar would crash MySQL Workbench.
A workaround was to click "Add EER Diagram" from the navigation or context menus. (Bug #17437387, Bug #70284)
On Microsoft Windows, the mouse pointer inside a SQL Editor tab would rapidly change from pointer to cursor when the mouse was moved, thus creating a repeatedly flashing event. (Bug #17347406, Bug #70119)
Clicking Online Backup after deleting the
configured MySQL Enterprise Backup directory (such as
C:\MySQLBackupHome) would throw an
Validation was added, a profile status icon was added to the backup screen, and MySQL Workbench now redirects to the Settings page instead of emitting an error. (Bug #17375285)
Double-clicking on an Audit Log File row would generate an unexpected error. (Bug #17376494)
While migrating a Microsoft SQL Server database to MySQL, database names with periods would fail, and now the periods are replaced with underscores. For example, "foo.bar" will become "foo_bar". (Bug #17370098, Bug #70170)
After selecting a table in the Catalog tab of the Catalog Tree pane, choosing Insert new row from the Edit Table... context menu would emit an unexpected error. (Bug #17357020, Bug #70140)
After editing a trigger in the model tab, switching tabs (such as loading a connection or SQL editor tab) would cause the new trigger edits to disappear. (Bug #17348212, Bug #70122)
Open query tabs were not persistent (reopened) after reopening MySQL Workbench. (Bug #17341182, Bug #17456474, Bug #17314977, Bug #70107, Bug #70325, Bug #70035)
Viewing the Client Connection could generate an unhandled exception if a connection had a very large connection time. (Bug #17375435, Bug #70174)
On Mac OS X, clicking Get Timestamp Ranges after selecting the available current filename from the Audit Plugin would throw an unhandled exception. (Bug #17300059)
The EER Diagram did not support some Chinese characters. (Bug #17275879, Bug #69933)
!include in the MySQL configuration
file would cause MySQL Workbench to crash at startup.
Stored routine groups could not be updated via the group editor in the EER diagram.
A workaround is to use individual routine group editors for each routine, by dragging the routine objects into the members list of the routine group editor to group them. (Bug #17323855, Bug #70059)
I/O writes were reduced, which was especially a problem visible when closing MySQL Workbench with tables that had over 500 columns. (Bug #17283888, Bug #68276)
On Mac OS X, the full field names in the Performance tab of the Option Files navigator page would not be fully visible. (Bug #17323870, Bug #70057)
The Run, Script File sequence did not function. (Bug #17299680)
In the commercial edition of MySQL Workbench, the "MySQL Utilities" download button linked to the community version of MySQL utilities. It now links to the appropriate edition. (Bug #17316512, Bug #70049)
The Close Other Tabs context-menu option did not close Table Editor tabs. (Bug #17235359, Bug #69850)
parameters were duplicated in the Options
File (formerly the Server
Administration) tab. They were listed in both the
Buffer Pool and Memory"
Also, using MySQL Workbench to change these settings would generate a change that also altered whitespace in the MySQL configuration file. (Bug #16915510, Bug #69406)
Migrating a Microsoft Access database would crash at the Reverse Engineer Selected Schemata step. MySQL Workbench does not support the migration of Microsoft Access, so the migration wizard will now display an error (and halt operation) when attempting to migrate an unsupported database. (Bug #16529142, Bug #67584)
After adjusting the width of the Id or Time columns in the connection listing, the integer value was cut off without indication. The value is now shown, or an ellipses (...) is appended. (Bug #16464457, Bug #68593)
The Workbench Bug Reporter failed to log in to report a bug, even when using valid credentials. This bug reporting functionality was removed from MySQL Workbench. (Bug #16056820, Bug #14520752, Bug #67990, Bug #66343)
WM_WINDOW_ROLE property is now
properly set for all MySQL Workbench windows.
(Bug #14171771, Bug #65537)
The Check for Updates, Submit a Bug Report, and Discuss a Topic MySQL Workbench buttons are now underlined when the mouse cursor hovers over them. (Bug #11758492, Bug #50704)