List:Announcements« Previous MessageNext Message »
From:karen langford Date:March 31 2014 12:06pm
Subject:MySQL Workbench 6.1.4 GA has been released
View as plain text  
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 
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

For discussion, join the MySQL Workbench Forums:

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,

In Windows, you can also use the integrated MySQL Installer to update
MySQL Workbench and other MySQL products.

Quick links:
- Download:
- Bugs:
- Forums:


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

      * 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

      * 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

      * 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

      * 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

      * 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 releasedkaren langford31 Mar