MySQL Workbench Release Notes/Changes in MySQL Workbench 6.0/ Changes in MySQL Workbench 6.0.3 (2013-07-09)

Changes in MySQL Workbench 6.0.3 (2013-07-09)

This is the second public beta release of 6.0. It is meant for testing purposes, and should not be used in a production environment.

Functionality Added or Changed

  • On OS X 10.7 and above, full screen support was added. (Bug #16962994, Bug #69473)

  • Database models can now be synchronized with any schema overriding the schema name. For example, it is now possible to synchronize two databases that have different names. (Bug #11757723, Bug #49817)

Bugs Fixed

  • Migrating Microsoft SQL Server to MySQL could truncateVARCHARdata. (Bug #17025373, Bug #69596)

  • TheSELECT DROP table/schemacontext menu action would generate SQL in lowercase. SQL keywords are now written in uppercase. (Bug #17006621, Bug #69560)

  • The check box in the bottom left corner of theModel,Model Optionsdialog box was not labeled. The label is nowUse defaults from global settings. (Bug #17004380, Bug #69552)

  • ExecutingSynchronize Modelagainst two tables that were identical except for the order that the indexes were created, would cause MySQL Workbench to drop and immediately re-add the foreign keys. (Bug #16999452, Bug #69153, Bug #69181)

  • PressingControl+Fwould fail to open theFinddialog. (Bug #16996850, Bug #69540)

  • The ";" separator for passing in multiple values to thereplicate-wild-ignore-tableoption was not parsed correctly, and MySQL Workbench would throw an unhandled exception. (Bug #16996665, Bug #69520)

  • The Forward EngineeringGenerate INSERT statements for tablesoption did not function. (Bug #16992658, Bug #69532)

  • When executing anAdministrationtask, such asManage Security, an "Current Profile Has no WMI enabled" error would be reported for local connections.

    A workaround was to edit and save the connection, while making edits to the connection was not required. (Bug #16986040, Bug #59933)

  • Under certain circumstances, entering an incorrect password would be saved and "Incorrect password" would be reported without the ability to enter a new (and valid) password. (Bug #16979861, Bug #69497)

  • 在OS X上,当地的默认配置文件server instances were not discovered properly. Attempts to edit theOptions Filewould emit an error. (Bug #16977187, Bug #69475)

  • TheDBMS connection read time outuser preference was limited to 5 characters in length. (Bug #16967769, Bug #69395)

  • MySQL Workbench prompted for thesudopassword when it was not needed. (Bug #16967758, Bug #69481)

  • TheExport recordset to an external fileoption would not check for existing files with the same name, and would overwrite a file without providing a warning. A prompt is now generated that asks if you want to overwrite the existing file. (Bug #16959225, Bug #69467)

  • Attempting to changemy.cnfviaServer Administration,Option Filewould generate an error about an invalidsudopassword. (Bug #16941451)

  • Migrating a local MySQL server to a remote MySQL server would fail at the data copy step, when a stored connection using the default socket path was used. (Bug #16895726, Bug #69376)

  • On Microsoft Windows 8, a "Handle is not Initialized" exception would be generated after performing a "Find and Replace" in the routine tab that is located in the group routines section. (Bug #16892512, Bug #69354)

  • Adding a particularly long string (around 50 characters) to a table comment for a model diagram would cause MySQL Workbench to crash. (Bug #16703832, Bug #68984)

  • When executing anImport From Disk操作Data Import/Restoreto a connection with an SSL CA File specified in the connection's configuration, clickingStart Importwould generate an error and fail to function. (Bug #16601645, Bug #68428)

  • Creating a stored function or procedure would generate SQL with superfluous创建andUSEstatements. (Bug #16588163, Bug #68204)

  • ExecutingModel,DBDoc,Model Reportingcreated a memory link. Then after the report was generated, executingFile,Export,Export as PNGfailed and report that MySQL Workbench ran out of memory. (Bug #16562737, Bug #68755)

  • Changing a column's default value fromCURRENT_TIMESTAMPtoCURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMPwas not detected. (Bug #16546597, Bug #68341)

  • ClickingApplyafter only changing a backtick ("`") or space (" ") would not save the results, and instead MySQL Workbench would report "No changes detected." (Bug #16545503, Bug #68162)

  • Moving tables around while constructing a diagram could cause the table positions to become lost, and scatter. (Bug #16521951, Bug #68727)

  • When connected to a database inSQL Developmentmode after running a query (or using theEdit table datacontext menu option), left clicking the leftmost column in the result set pane did nothing. The row options are now enabled when clicking the left side column. (Bug #16469383, Bug #68633)

  • Opening theSQL editorwith a stored connection would not open the saved workspace if the stored connection was selected by default. (Bug #16433144, Bug #68499)

  • After creating a table against a MySQL server withlower_case_table_namesset to 1, theObject Browserwould display the new table name as the user entered it, instead of displaying how it was created with lower-case. The lowercase version is now displayed, and the user is notified of the conversion. (Bug #16390426, Bug #68210)

  • Importing a CSV file that defined line endings with "\r" instead of "\n" or "\r\n" would cause MySQL Workbench to crash. A warning message is now displayed that warns of the incorrect format. (Bug #16362189, Bug #68343)

  • The**.*object underModel,Schema Privileges,Privilegeswas missing an icon. (Bug #16285241)

  • The取代& Findfeature would insert the replacement text at the cursor location even if the matching text was not found. (Bug #16284625)

  • On Microsoft Windows, an "Index was out of range" exception was thrown after loading theOutputtab in the SQL editor. (Bug #16283047)

  • The text editor in the lower bottom half of the snippets tab (inside the scripting shell) would become unavailable (hidden) after dragging the splitter bar all the way down. (Bug #16277909)

  • After adding and deleting a relationship between tables, the deleted relationship was still reported in the yellow tooltip box.

    A workaround was to restart MySQL Workbench after saving the project. (Bug #14835355, Bug #67421)

  • An error was emitted while generating a catalog diff report, and differences in catalogs are now successfully reported. (Bug #14692908, Bug #66986)

  • The canvas height of the Model Overview container was not calculated properly. The amount of whitespace would increase as the number of objects increased. (Bug #14456267)

  • Database synchronization with a View would sometimes fail, and could remove the View. (Bug #14005482, Bug #65108)

  • Right-clicking on an existing diagram in the model editor would display a disabled Cut and Paste option. It was removed. (Bug #13470625)

  • A column name mapping editor was added to the synchronize wizard, as sometimes manually adjusting the column mapping is required. (Bug #13463420, Bug #63486)

  • An error dialog is now generated if an invalid column is chosen from the foreign key picker when creating the relationship. (Bug #11766525, Bug #59655)

  • Validation now checks for the required parenthesis with the "Union Tables" argument during model synchronization, and adds them if they are missing. (Bug #11766487, Bug #59601)

  • The default value for anENUMwas not quoted. (Bug #11761349, Bug #53835)

  • MySQL Workbench could exhibit an extended timeout when suffering from incorrect permissions. This extended timeout was fixed, and MySQL Workbench will now ask for the sudo password when needed. (Bug #11761240, Bug #53711)

  • When adding a table to form a N:M relationship in a large EER Diagram, the new N:M table was positioned far away from the tables. This third table is now added between the two other tables. (Bug #11754898, Bug #46582)

  • The name of aDiagramcan now be changed from the diagram tab viaModel,Diagram Properties and Size.... (Bug #11753099, Bug #44472)