Dear MySQL users, The MySQL developer tools team announces 6.1.4 as our GA release for MySQL Workbench 6.1. MySQL Workbench 6.1 is an upcoming major update for the official MySQL graphical development tool. Introducing over 30 new features, this version has many significant enhancements focusing on real-time performance assessment and analysis from the SQL statement level to server internals and file IO. You can see this from additions to the SQL Editor as well as new dashboard visualization and reporting that take advantage of MySQL Server 5.6 and 5.7 Performance Schema, and enhancements to the MySQL Explain Plans. Additionally Workbench 6.1 is leveraging work from various teammates in MySQL Engineering by introducing a schema called "SYS" that provides simplified views on Performance Schema, Information Schema, and other areas. Special thanks to the server optimizer team, server runtime team, and Mark Leith. For Oracle DBAs MySQL SYS is similar to the V$ catalog views, and MSSQL folks its like DMVs (Dynamic Management Views). MySQL Workbench 6.1 includes: * Improved drag and drop support in the Home screen and SQL Editor * Visual Explain 2. The Visual Explain feature was revamped and is now easier to read and interpret. You can also get the traditional tabular explain output from within the same interface. * Performance Dashboard. A graphical representation of some key statistics from the server status, gives you a bird's eye view of the status of key server subsystems. * For advanced users, Performance Schema Instrumentation. A GUI for configuring the Performance Schema in detail, for advanced users. * Performance Schema based reporting. Gives insight into the operation of the server through many high-level reports. * New query result view. Get more information about queries you execute, such as information about the fields in your result set and key performance statistics from your query (timing, index usage, number of rows scanned, joins etc). * Form Editor for resultsets. In addition to the result grid, you can now edit records row by row in a form style editor. * Table Inspector. Similar to the Schema Inspector, view detailed information from tables. A streamlined interface for creating indexes is also included. * Support for the Windows accessibility API and Windows high contrast color schemes. A new high contrast theme has been introduced. * And more. More than 60 enhancement requests and bugs reported by users have also been addressed, providing performance, usability and stability improvements across the board. For the full list of bugs fixed in this revision, visit http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-1.html For discussion, join the MySQL Workbench Forums: http://forums.mysql.com/index.php?151 Download MySQL Workbench 6.1.4 GA now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 19, Fedora 20, Ubuntu 12.04 and Ubuntu 13.10 or sources, from: http://dev.mysql.com/downloads/tools/workbench/ In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products. Quick links: - http://mysqlworkbench.org/ - Download: http://dev.mysql.com/downloads/tools/workbench/ - Bugs: http://bugs.mysql.com - Forums: http://forums.mysql.com/index.php?151 Enjoy! Changes in MySQL Workbench 6.1.4 (2014-03-31) Functionality Added or Changed * The Beautify query feature was changed. It now only affects the current statement, unless there is an explicit selection. Before, it would reformat all statements in the window by default. (Bug #18237189, Bug #71544) * The default schema is now expanded automatically when a connection is opened, or when the default schema changes. (Bug #18237247, Bug #70522) * A specific connection string can now be passed to the --query command-line option at startup, in the form of "--query user@host:port". If this connection string does not already exist, then it will be created. (Bug #17353691, Bug #70134) * MySQL Workbench now checks if the lower_case_table_name variable is correctly set on Microsoft Windows and Mac OS X systems. If not, then MySQL Workbench will display a dialog after connect, and emit a warning message when performing synchronization or reverse engineering actions. (Bug #14802853) * New Report a Bug functionality now opens a browser with the MySQL bug page pre-populated with MySQL Workbench data. This also allows MySQL Workbench to be fully manipulated while submitting the bug report. (Bug #14079590, Bug #65258) Bugs Fixed * The local private key file for an SSH connection when executing Remote Connection in MySQL Workbench through SSH could not be saved to a folder with accented characters. (Bug #18328846, Bug #71800) * FOUND_ROWS() (after a SQL_CALC_FOUND_ROWS statement) returned 1 (true) instead of the number of found rows. (Bug #18342953, Bug #71920) * On Mac OS X, using key shortcuts to record marker positions #3 and #4 on the modeling canvas did not function, as these shortcuts (Command + Shift + 3 and Command + Shift + 4) are predefined to execute screenshot features. (Bug #18268043) * Exported JSON string delimiters used double quotes instead of single quotes, and the exported JSON file extension changed from .js to .json. (Bug #18314718, Bug #71846) * Some user interface (UI) elements explicitly set a background color but not a font color, and vice-versa. (Bug #18305958, Bug #71828) * The Shift + Control + Arrow Key (left or right) now moves the cursor word-by-word in the SQL code editor, to go along with the character-by-character Shift + Arrow Key functionality. (Bug #18267537) * A Show schema name diagram preference was added. If enabled, it shows the schema name in the table heading of an EER Diagram. (Bug #18268014, Bug #71592) * On Mac OS X, pressing Shift would interfere with the Option + Arrow word-by-word selector operation, and would instead change it to a character-by-character operation. (Bug #18237104, Bug #64358) * When migrating from Microsoft SQL Server, nVarchar(n) columns would always migrate to a MySQL VARCHAR(n) column that was twice the size. (Bug #18195599, Bug #71608) * While executing the Migration Wizard, successfully entered credentials during a Test Connection remained in cache until the migration tab was closed, despite the Save password in keychain option not being enabled. The connection is now closed after executing Test Connection. (Bug #18195389) * On Linux, Help-View Reported bugs link (to view current MySQL Workbench bugs) was broken. Its path included "WB%2520bugs" instead of "WB%20bugs". (Bug #18231109, Bug #71668) * After copying and pasting tables within the Alter Table panel, clicking Apply would return "No changes detected" instead of detecting the changes. Copied and pasted entries (from the clipboard) are now detected and saved. (Bug #18205924, Bug #71632) * The Check for updates operation failed to function for the commercial edition. (Bug #18225980, Bug #16879533, Bug #69346) * MySQL Workbench will now see the NO ACTION and RESTRICT referential action options as two different options. (Bug #18237503, Bug #71499) * On Linux, a scheduled and executed MEB Online Backup would not output the error log to stderr. Also, the saved log file was always named $BACKUP_NAME.log, by using the literal '$BACKUP_NAME' instead of parsing it as a variable. (Bug #18243667, Bug #71674) * The values "true" and "false" are now converted to "1" and "0" if the column is a BOOLEAN or TINYINT. Also, synchronizing a BOOLEAN against a TINYINT no longer generates any differences, when before it might generate SQL that "changed" TINYINT columns to TINYINT. (Bug #18124474, Bug #71458) * When migrating from Microsoft SQL Server, mapping a VARCHAR column to TEXT would still attempt to migrate it to VARCHAR, which could yield an error if the VARCHAR exceeded the maximum size. It now properly maps to TEXT. (Bug #18167872, Bug #71036) * When migrating from Microsoft SQL Server, column names greater than 64 characters were automatically renamed with the object migration component. The schema creation created the new table structure as expected, but later the bulk migration bulk data transfer attempted to import data to the original column names. (Bug #18168027, Bug #71532) * The Store connection for future usage option in the Database Migration wizard did not store the defined MySQL connections. (Bug #18124149) * Saved connections would sometimes not function (connect) properly unless the password was saved to the local vault. (Bug #18154787) * When migrating from Microsoft SQL Server, DECIMAL(n, n) columns did not properly migrate to BIGINT(n). (Bug #18105487, Bug #71379) * When migrating from Microsoft SQL Server, Varchar(MAX) is now imported as LONGTEXT, instead of the erroneous VARCHAR(-1). (Bug #18105486, Bug #71253) * Altering a table's comment would immediately move the cursor position to the end of the comment. A workaround was to copy-n-paste a comment into this window. (Bug #17945616, Bug #70970) * On Linux, using a GTK theme with light font colors would cause the schema listing to be difficult to read. (Bug #17958777, Bug #71141) * MySQL Workbench failed to reverse engineer tables containing TIME(n) and DATETIME(n) (fractional timestamp) columns. (Bug #17559837, Bug #70515) * Executing Execute Now for a defined backup job would finish successfully, but would also report an error. (Bug #17408250) * When multiple versions of MySQL Enterprise Backup were installed, the MySQL Backup Command Path would include both paths. Now, the first discovered path is used, and a warning about having multiple MySQL Enterprise Backup installations is logged. (Bug #17367584) * The MySQL keywords were sometimes blank (missing) in the SQL Additions panel. (Bug #17346343, Bug #70116) * The Migration Wizard Overview text was updated to reflect better grammar. (Bug #17283213) * When too many tabs are present in MySQL Workbench, a double arrow now appears in the right top corner. When clicked, a list of the hidden tabs will appear. (Bug #16757127, Bug #69091) * The MySQL Workbench Scripting Shell did not allow tabs or spaces for indentation in interactive Python scripts. A workaround was to instead create and execute script files. (Bug #14520728, Bug #66451) * Sometimes the Report Bug window would remain open, even after pressing Cancel. (Bug #14495624, Bug #66084) * The panel dimensions for an EER diagram are now preserved. This left panel stores the descriptions, properties, and history tabs. (Bug #13972049, Bug #64661) * The Synchronize Model routine would only notice changes to some triggers, while ignoring changes to others. It would not update these triggers even if forced by using the Update Source button. (Bug #11766750, Bug #59934) * MySQL Workbench would allow a table group to be renamed using a reserved MySQL keyword. (Bug #11763690, Bug #56431) On behalf of the MySQL Workbench and the MySQL/ORACLE RE Team.
|MySQL Workbench 6.1.4 GA has been released||1349||Karen Langford||03/31/2014 06:13AM|
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.