MySQL Forums
Forum List  »  Announcements

MySQL Workbench 6.1.4 GA has been released
Posted by: Karen Langford
Date: March 31, 2014 06:13AM

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. 

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Workbench 6.1.4 GA has been released
4495
March 31, 2014 06:13AM


Sorry, you can't reply to this topic. It has been closed.

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.