This section documents all changes and bug fixes applied since the release of MySQL Workbench 5.2.26.
Several changes were made to the Synchronize Model With Database wizard:
The wizard shows all schemata in a model, regardless of whether they exist in the live database.
The wizard shows a list of schemata that exist in the model but are missing from the live server, with a note recommending the use of the Forward Engineering wizard.
The wizard does not auto-select schemata names that are in the model but not in the live database.
Attempts to restore a backup of selected tables resulted in this error:
File "C:\Program Files\MySQL\MySQL Workbench 5.2 CE\modules\wb_admin_export.py", line 841, in start logmsg = "Restoring %s (%s)" % (schema, table) NameError: global name 'schema' is not defined
Forward engineering a model to a live database caused MySQL Workbench to crash. (Bug #56009)
The Dump tab did not display the target folder before the dump was performed. (Bug #55945)
MySQL Workbench crashed in the foreign key editor. The Microsoft Visual C++ Runtime Library runtime error generated prior to the crash was:
R6025 - pure virtual function call
If the sidebar was placed on the right hand side, using the option in Workbench Preferences, this Unexpected Error was generated when Add Diagram was double-clicked:
SplitterDistance value is invalid (-52)
In the SQL Editor, executing statements designed for MySQL Server 5.5 generated syntax or syntax highlighting errors. (Bug #55867, Bug #55891)
After dropping a schema from the list in the Object Browser, the schema that was dropped remained, but with the name of the schema that followed it. Refreshing the list of available schemata produced an unhandled exception:
An unhandled exception has occurred: Invalid node index
Selecting "Dump views" for a backup produced this error:
Unhandled exception: global name 'views_by_schema' is not defined
It was necessary to restart the Administrator to enable the dump facility again. (Bug #55833)
In the SQL Editor, right-clicking a routine name in the Object Browser caused MySQL Workbench to exit unexpectedly. (Bug #55822)
MySQL Workbench crashed when using the Partitioning tab of the Table Editor. (Bug #55761)
If a table was copied in the EER Diagram view, and then the model was synchronized with the live database, the synchronize functionality did not recognize the copied table as a new table and overwrote the original table. (Bug #55566)
MySQL Workbench crashed when using the Export recordset to an external file command button on the result pane of the SQL Editor. (Bug #55554)
Renaming a column with a foreign key resulted in an invalid script being generated on forward engineering or synchronization with a live database. (Bug #55502)
The second attempt to save a read-only model file produced this error:
Couldn't backup existing file name-of-the-file.mwb: No such file or directory
When a table was being edited in the Table Editor, and its name was changed, the name change was not reflected on the Table Editor's table tab. (Bug #55338)
It was not possible to add the
LOCK TABLESprivilege when assigning a new role in the Model Overview because that privilege was missing from the available options. (Bug #55186)
The schema collation was not saved after being changed in the Table Editor. (Bug #55152)
When an attempt was made to synchronize a model with a live database, no schemata were listed as available in the Synchronize Model with Database wizard. This happened when the name of the schema in the model and the schema on the live server differed only in lettercase. (Bug #55147)
When using MySQL Workbench to report a bug, it was not possible to attach a file using thebutton because the button had no effect. (Bug #55112)
Dumping tables or schemata without the
LOCK TABLEprivilege produced this error:
mysqldump: Got error: 1044: Access denied for user 'wwroot'@'%' to database db' when doing LOCK TABLES
Selecting Validate All option reported no errors. Selecting from the menu and selecting Run Validations also reported no errors. However, executing the SQL script resulted in this error:from the Model menu and then selecting the
ERROR: Error 1005: Can't create table 'xxx' (errno:150)
Selecting theoperation from the submenu of the menu produced this error message:
Type mismatch: expected object of type db.Schema, but got workbench.physical.Model
When using the Edit Table Data wizard (launched from Home screen), if a database with a single table was connected to, after selecting the table, the button remained grayed out. (Bug #54942)
At startup, these warnings were generated in the Workbench Scripting Shell:
Starting Workbench...Registered 147 GRT classes. WARNING: Could not load wb.mysql.validation.grt.dylib: Invalid module /Applications/MySQLWorkbench.app/Contents/PlugIns/wb.mysql.validation.grt.dylib WARNING: Could not load wb.validation.grt.dylib: Invalid module /Applications/MySQLWorkbench.app/Contents/PlugIns/wb.validation.grt.dylib
When an attempt was made to synchronize a modified exported script with the current model, using, , , the model was not updated. (Bug #54501)
When the Alter Table dialog for an
InnoDBtable was displayed in an SQL Editor session, the Foreign Key Options Index showed INVALID when a foreign key in the Foreign Keys tab was clicked. (Bug #54471)
MySQL Workbench caused Windows XP to reboot if launched from, , , .
If a MySQL Workbench model file (
.mwb) was opened directly, an error dialog titled Microsoft Visual C++ Runtime Library was displayed with the message:
R6034 An application has made an attempt to load the C runtime library incorrectly. Please contact the application's support team for more information.
The dialog's only option was. After clicking , two more instances of the same dialog were displayed. After clicking for all three, MySQL Workbench opened with the model file displayed.
On Windows 7 x64, the same runtime error (R6034) occurred. (Bug #52949)
Opening an SQL Editor connection for a remote server produced this error:
OverviewBE::get_node:invalid node 0.0.0.