Version History of MySQL Workbench 5.2.41

Functionality Added or Changed

  • Added a new Data Import/Restore option to select the default schema to import to, and a button to create a new schema in case a dump is being imported from a single file. (Bug #13539030, Bug #63853)
  • A Global Privileges tab was added to the Server Administration interface. It allows adding and editing individual global user privileges. (Bug #11761628, Bug #54141)
  • A word wrapping option was added to the SQL Editor. (Bug #11765583, Bug #58566)
  • The Diagram object tooltip now displays the column comments. (Bug #11765060, Bug #57977)
  • Basic code completion functionality has been implemented. (Bug #11760500, Bug #13813099, Bug #52917, Bug #64525)
  • The model wizards now remember the last connection that was added. (Bug #56515, Bug #11763761)
  • MySQL Workbench added a migration wizard, which will migrate ODBC compliant databases to MySQL. (Bug #54731, Bug #11762168)

Bugs Fixed

  • On Microsoft Windows 64-bit, closing MySQL Workbench from within the SQL editor could cause a crash. (Bug #14307316)
  • A snippets file could not be created. (Bug #14278287, Bug #65734)
  • It is now possible to select a range of rows using the shift key. And on Mac OS X, the command key will now allow the selection of individual rows (Bug #14177386, Bug #65569)
  • Comments and collation controls are now disabled until a column in the column editor is selected. Before it was always available, so invalid entries would attempt to be created, which would result in an error. (Bug #14177412, Bug #65574)
  • An orphaned privileges tab would be shown in the table editor when switching tables. Now only the current privilege tab is displayed. (Bug #14102537, Bug #65182)
  • The Edit, Find, Find and Replace operation was slow. (Bug #14079480, Bug #65262)
  • MySQL Workbench would not load with Ubuntu 11.10. (Bug #14058886, Bug #63626)
  • Having a schema without a name in a model would cause MySQL Workbench to crash. (Bug #14017357, Bug #65119)
  • Using the '%' character within environment variables could cause MySQL Workbench to crash. (Bug #13989371, Bug #65056)
  • MySQL Workbench would fail to compile with automake 1.11.2 or greater, due to the pkglib_DATA reference. (Bug #13972001, Bug #63898)
  • The SQL Beautifier feature would remove DISTINCT from inner queries. (Bug #13970596, Bug #64932)
  • Creating and then synchronizing a table in a model with a DOUBLE typed column would generate invalid SQL, thus generating an "Invalid SQL syntax" error. (Bug #13970484, Bug #64990)
  • MySQL Workbench would crash while multiple model routines were opened. (Bug #13970497)
  • The SQL Beautifier would delete WITH ROLLUP if it was contained within a subquery. (Bug #13919924, Bug #64796)
  • The Replace All option would not function when the replacement string was empty. (Bug #13919875, Bug #64818)
  • Passing a grt.classes.db_query_EditableResultset object to getattr() could cause a crash. (Bug #13893388, Bug #64777)
  • On Linux and Mac OS X, it was not possible to select/copy multiple rows from within the result set grid. (Bug #13895191)
  • A new Copy Row (tab separated) option was added to the result set context menu within the SQL editor. A comma separated variant of this option already existed. (Bug #13884753, Bug #64724)
  • Certain conditions would cause privilege related problems and emit errors such as "Incorrect Value Entered" when creating a table in one tab, altering it in another, then going back to the original tab. (Bug #13877873, Bug #64591)
  • Internal log tables are now excluded while exporting a the MySQL database. The excluded tables aremysql.schema, mysql.apply_status, mysql.general_log, and mysql.slow_log. (Bug #13837725)
  • Using Paste Row after Copy Row Data within the SQL editor would insert rows with extra apostrophes. For example, 'hello' would become ''hello''. (Bug #13840070, Bug #64630)
  • Inputting invalid SQL would remain designated as such, even after the SQL was corrected. (Bug #13820997, Bug #64481)
  • Closing an SQL Editor tab that had a Find/Replace dialog box open, then subsequently closing theFind/Replace dialog box would crash MySQL Workbench. (Bug #13816167, Bug #64569)
  • Input elements are now correctly disabled until an editable row in the column editor is selected. Therefore, invalid values are no longer set in the model. (Bug #13812811, Bug #64550)
  • Changing the Default Collation of a schema after changing its name would reset the schema name to "new_schema". (Bug #13799456, Bug #64259)
  • The Edit table data SQL editor option would not properly display or save Unicode characters. (Bug #13790645, Bug #64447)
  • All editor tabs now prompt to save data when these tabs are closed. Before, only the main tabs (like the SQL Editor) would prompt for to save. (Bug #13788071, Bug #64462)
  • The Match Case search option did not function. (Bug #13790397)
  • On Mac OS X, the color dropdown in the object tool would not display the color properly. It instead showed the color code, and would not apply the color to the object. (Bug #13742905)
  • Opening the Scripting Shell window, followed by selecting then closing the snippet tab, would cause MySQL Workbench to crash. (Bug #13744364)
  • If Plugins, Utilities, Indent Selected Lines is used while a row is selected, then MySQL Workbench would delete the selected row. (Bug #13744346)
  • On Mac OS X, the Option key did not behave like a standard Mac OX application. For example, Option + Deletewould delete one character instead of one word. (Bug #13702376, Bug #64217)
  • Added version dependent keyword list support for syntax highlighting. Supports MySQL Server 5.0, 5.1, 5.5, and 5.6 (Bug #13699804)
  • On Mac OS X, and while working with mixed-case table names, a foreign key could not be assigned to link two InnoDB tables together. (Bug #13639162, Bug #64109)
  • Quickly executing the same query multiple times would cause MySQL Workbench to use an excessive amount of memory and CPU. (Bug #13642999, Bug #64077)
  • The Model, Model Options, Diagram, Hide Captions option could not be altered (disabled) and would remain checked (enabled). (Bug #13571857, Bug #63937)
  • MySQL Workbench would allow the creation of multiple foreign keys across multiple tables but with the same foreign key name. Synchronization would then emit a "Can't create table" error. (Bug #13548236, Bug #13500447, Bug #63642, Bug #62960)
  • The Object Browser now manages procedures and functions separately, when before they could not co-exist with the same name. They remain under the routines group but have separate icons and menu options. (Bug #13548213, Bug #13730415, Bug #63849)
  • After right-clicking on a value in the SQL editor and choosing Open Value in Viewer, selecting the text would insert extra new lines into the clipboard. (Bug #13538942, Bug #63753)
  • The Server Administration, Server logs, General Log Table option would not function, and only show aTry again button. (Bug #13530413)
  • While editing in the Edit Table tab, Control + A would also select diagram objects. (Bug #13519852, Bug #63758)
  • A "Removed corrupt column definition for Foreign key" error would sometimes be emitted while editing a table with foreign keys. (Bug #13519797, Bug #63772)
  • OpenGL determination at startup has been disabled, and instead this check is performed while creating diagrams. The system could fail at startup, so now MySQL Workbench avoids this startup trouble and can better fall back to software rendering if necessary.

MySQL Workbench would also silently fail to load if "Microsoft Visual C++ 2010 Redistributable Package" was not available. This is now checked and reported to the user. (Bug #13512714, Bug #61969)

  • The Open Value in Editor SQL editor option did not work with INT or NULL values. (Bug #13492493, Bug #62934)
  • Plugins, Utilities, Execute query would freeze MySQL Workbench if the query resulted in 1000 or more rows. (Bug #13470781)
  • The info and session tabs within the MySQL connection interface would not display any information. (Bug #13466537)
  • The Move to a group context option for database connections would cause saved connections below the target connection (that is being added to a group) to disappear. (Bug #13470318)
  • The Options tab within the SQL Editor would always display an empty AUTO_INCREMENT value for tables usingInnoDB. (Bug #13463458, Bug #63464)
  • After making changes to a model, then closing the window, clicking Cancel on the unsaved changes warning/dialogue would close MySQL Workbench. Now the model window remains open. (Bug #13463465, Bug #63460)
  • On Mac OS X, Command + A would not select all results from the result set. (Bug #13463374, Bug #63461)
  • After synchronizing a database, refreshing a model would not refresh the stored procedure information. (Bug #13418563, Bug #62879)
  • A query such as "SELECT * FROM SomeTable PROCEDURE analyse()" would only work if "limit rows" was disabled in the preferences. The MySQL Workbench query parsing has been extended to support this type of query. (Bug #13344686, Bug #62964)
  • The MySQL Workbench bug reporting form (MySQL Bugs: Report) did not allow pasting content into the form. (Bug #13344751, Bug #62928)
  • "MariaDB" has been change to "Aria" within MySQL Workbench. (Bug #13252479, Bug #62903)
  • Routine groups on the diagram was not updated after adding new routines to the group. (Bug #13029520, Bug #62496)
  • Right-clicking on Catalog tree within the Model, Diagram context would display an empty line. (Bug #13025389)
  • MySQL Workbench would crash after clicking EER links and options multiple times. (Bug #13024949)
  • Clicking between routines with different comments would not update the description editor with information from the selected object. (Bug #13025359)
  • The Connection Method option within the Edit Table Data window was partially hidden. (Bug #13025670)
  • Detection of a connection to the local machine based on the IP address has been removed. There is now a selection between localhost, remote host, and db host on the initial New Server Instance page. Selecting localhost will let the wizard know that it is local, as otherwise the full path is now required, which for example allows 127.0.0.1 to be used as a remote host to support port forwarding. (Bug #12890503, Bug #62119)
  • The sorting options within the Inserts Editor window did not function. (Bug #12884134)
  • The View, Home option did not function. (Bug #12879850)
  • User Defined Types (UDT) could not be deleted when they were not referenced elsewhere. (Bug #12671629, Bug #61530)
  • The MySQL Workbench window can now be resized to 1024x710. (Bug #12632406, Bug #60762)
  • A confirmation dialog was added that warns users about attempts to edit stub tables, and it describes why these will be ignored by both synchronization and forward engineering. The dialog includes an option to either keep editing it as stub object, or to clear the stub flag and make the table appear in generated SQL. (Bug #12616360, Bug #61309)
  • The synchronization wizard now allows the possibility to force synchronization of schemas that are thought to have been renamed. Otherwise, MySQL Workbench will recreate the schema from scratch. (Bug #12565644, Bug #61211)
  • The EER Diagram zoom feature would not function. (Bug #12346981, Bug #60807)
  • The Partitions tab within the Alter table context menu would not show all of the available partitions. (Bug #11933015, Bug #60235)
  • On Mac OS X, having a large number of databases (1,000+) could cause performance issues where MySQL Workbench would load in several minutes, as opposed to a few seconds. (Bug #11869432, Bug #60420)
  • MySQL Workbench would not allow a user to delete a saved server instance that contained an incorrect password. This incorrect password can now be deleted. (Bug #11765337, Bug #58295)
  • The Synchronize Model operation would use an excessive amount of memory. (Bug #11762726, Bug #55355)
  • MySQL Workbench would freeze while attempting to search and replace with a large number of strings, such as over 100,000. (Bug #11762890, Bug #55539)
  • A new Model: MySQL preference was added for Forward Engineering and Synchronization to configureSQL_MODE. (Bug #11761659, Bug #54173)
  • The Synchronization wizard has been changed to allow forcing synchronization of schemas that have the same name but an unexpected "last known name", which would cause a confusing scenario of the target database being recreated from scratch. (Bug #11756969, Bug #48962)
  • On Mac OS X, MySQL Workbench would crash when changing database engines if a database included a table with uppercase characters. (Bug #65376, Bug #14117038)
  • The Copy Column Names to Clipboard option could crash MySQL Workbench. (Bug #64881, Bug #13970600)
  • The zoom feature (in or out) could cause a fatal error. (Bug #65247, Bug #14136870)
  • On Microsoft Windows, MySQL Workbench would ignore the system's font setting, but now uses it when MySQL Workbench is initialized. (Bug #62105, Bug #12872840)
  • On Ubuntu 12.04, MySQL Workbench would not load. (Bug #64956, Bug #14180754)
  • MySQL Workbench would sometimes repeat a warning during a successful action that followed the action with the warning. (Bug #62454, Bug #13014873)
  • Deleting an EER diagram would cause MySQL Workbench to hang. (Bug #65174, Bug #14102990)
  • While editing an EER diagram, and click-dragging the mouse cursor, the cursor now remains in the same place it was originally clicked. (Bug #64487, Bug #13813199)
  • New or updated trigger content would disappear from the SQL Editor GUI, as it was required to reopen the table editor to see the changes. (Bug #65411, Bug #14137775)
  • If a view contains a row that is too long to be represented as a table column, it will now be substituted with an alias column in a placeholder table, similar to how mysqldump behaves. Before it could generate invalid SQL, and fail to synchronize the model. (Bug #63807, Bug #13538955)
  • Using File, Export, Forward Engineer SQL CREATE Script would remove delimiters statements if theOmit Schema Qualifier in Object Names option was selected. (Bug #63742, Bug #13520528)
  • MySQL Workbench now uses the MySQL Server limit for maximum comment lengths while using the forward engineering wizard. Before it would truncate comments to 60 characters, which was a MySQL Server limit before version 5.5.3.

From the MySQL Server 5.5.3 changelog: the maximum length of table comments was extended from 60 to 2048 characters. The maximum length of column comments was extended from 255 to 1024 characters. Index definitions now can include a comment of up to 1024 characters. (Bug #62207, Bug #12904170)

  • Adding a trigger with the Alter Table, Trigger interface now warns the user if the inputted trigger statement was invalid. Before, MySQL Workbench would output "No changes to object were detected." if the SQL was valid, but without a CREATE TRIGGER statement. (Bug #61712, Bug #12908810)
  • When altering a table with uppercase letters in the table name, MySQL Workbench would automatically convert the table name to lowercase. (Bug #64072, Bug #13639292)
  • MySQL Workbench now respects case-sensitivity when lower_case_table_names = 2. (Bug #60618, Bug #11926851)
  • Closing MySQL Workbench while editing SQL Scripts will now prompt the user to save the edits. (Bug #61037, Bug #62959, Bug #12546710, Bug #13344705)
  • Loading large files (over 100MB) using File, Open SQL Script... would fail to load the script, and throw an out of memory exception while halting operation.

Now, MySQL Workbench warns users if a file exceeding 100MB is attempted to be loaded, and no longer crashes when running out of memory but instead reports that the file was unable to be loaded. (Bug #55312, Bug #60780, Bug #61363, Bug #64186, Bug #11762687, Bug #12339717, Bug #12627645, Bug #13790375)

  • Synchronizing a model would drop, and then re-add, indexes and foreign keys if the order of these indexes and foreign keys were different. This could happen because MySQL Workbench would add UNIQUE indexes in the order added by the user, whereas the MySQL Server puts them first. (Bug #60230, Bug #11829807)