Web lists-archives.com

MySQL Workbench 8.0.16 has been released





Dear MySQL users,

The MySQL developer tools team announces 8.0.16 as our general available (GA) for
MySQL Workbench 8.0.

For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html <https://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html>

For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152

The release is now available in source and binary form for a number of
platforms from our download pages at:

http://dev.mysql.com/downloads/tools/workbench/

Enjoy!


Changes in MySQL Workbench 8.0.16 (2019-04-25, General
Availability)


     * Functionality Added or Changed

     * Bugs Fixed

Functionality Added or Changed


     * The script editor now highlights matching pairs of
       parentheses when one of the pair is selected. (Bug
       #27473434, Bug #73167)

     * Microsoft Visual Studio support was upgraded from Visual
       Studio 15 to Visual Studio 17.

     * Previously, the output from running schema validation
       plugins on a MySQL model was distributed to different
       areas of MySQL Workbench, making portions of the
       information easy to miss. The same functionality now is
       shown in a single location and reorganized to provide
       informational, warning, and error messages by category. A
       new Validate tab also provides a simple way to reselect
       and rerun validation tests from the output area in the
       right side panel (see Schema Validation Plugins
(http://dev.mysql.com/doc/workbench/en/wb-validation-plugins.html)).

Bugs Fixed


     * MySQL Workbench stopped working when an existing table
       with an expression in a column of type BINARY was
       selected for editing. (Bug #29449200)

     * MySQL Enterprise Firewall could not be installed from the
       Enterprise Edition of MySQL Workbench. (Bug #29359957,
       Bug #94335)

     * An incorrect-integer-value error resulted when the Table
       Data Import Wizard attempted to import CSV data to a
       valid database table. (Bug #29348922)

     * MySQL 5.7 tables exported to MySQL 8.0.14 or 8.0.15
       produced the following error: Unknown table
       'COLUMN_STATISTICS' in information_schema.
       (Bug#29344344, Bug #94294)

     * A successful connection made with SSH tunneling from a
       Linux host produced an ongoing loop of errors if an
       attempt was made to close the connection. (Bug #29342871,
       Bug #94212)

     * The LATERAL keyword now conforms with the SQL editor
       convention to highlight and indent the words considered
       keywords by MySQL. (Bug #29251184, Bug #94012)

     * An exception was raised when a valid path to the MySQL
       Enterprise Backup 8.0.14 or 8.0.15 executable was
       provided in the prerequisite settings. To back up MySQL
       8.0.14 or 8.0.15 data, upgrade to MySQL Workbench 8.0.16
       or use MySQL Enterprise Backup 8.0.14 or 8.0.15 directly
       (see Introduction to MySQL Enterprise Backup
(http://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/intro.html)).
       (Bug #29246551)

     * An error in the generated mysql_rdbms_info.xml file
       caused MySQL Workbench to stop working. (Bug #29237703,
       Bug #93987)

     * The size of the Table Data Import Wizard window changed
       unexpectedly between steps, causing the navigation
       buttons to vanish from visible range unless the window
       was expanded to include them. (Bug #29200662, Bug #93869)

     * With the GNOME desktop theme set to Adwaita (default) or
       Adwaita-dark, text selected within the SQL editor was
       invisible. (Bug #29184506, Bug #93847)

     * The Command-V keyboard shortcut on macOS returned an
       error indicating that a paste-row operation was
       attempted, rather than the single-value paste used to
       edit a field within the result grid following a
       successful query. (Bug #29137004, Bug #93710)

     * Executing a function or stored procedure caused an
       unexpected program shutdown on Linux hosts.
       (Bug#29134435)

     * The SQL beautifier feature produced no change when it was
       executed within the Triggers tab of the table editor.
       (Bug #29133592)

     * The table inspector did not start properly and produced
       an error on macOS when it was selected from the context
       menu of a valid table within the Schema tab.
       (Bug#29128333)

     * An exception was generated when the results of a query
       was toggled between visual explain and tubular explain
       formats within the Execution Plan tab. (Bug #29121364)

     * A user account that was deleted properly from Users and
       Privileges remained visible until the Administration tab
       closed and reopened. (Bug #29061678)

     * New tables added to the canvas of an EER diagram
       displayed the table name bar only, without columns, when
       the table tool (Place a New Table) from the vertical
       toolbar was used to add each table. (Bug #29056873)

     * Records imported from an external file, such as a CSV
       file, generated an exception when the operation was
       attempted from a macOS host. (Bug #29048933)

     * Each step shown in the MySQL Workbench Migration Wizard
       was masked and unreadable while the individual operation
       executed. This fix modifies the contrast between the text
       of the current step and the box used to highlight it.
       (Bug #29048871)

     * On Windows 10, the scroll wheel (or mouse wheel) did not
       respond when used to scroll in any on-screen area with a
       scroll bar. (Bug #29035906, Bug #93541)

     * Some keyboard shortcuts, such as Command-C, did not work
       within the SQL and model editors on macOS 10.14 hosts.
       (Bug #29034285, Bug #93186)

     * Rather than generating a warning or error when it
       detected an unknown SSH option in the ~/.ssh/config file,
       MySQL Workbench became unresponsive. (Bug #29016708,
       Bug#92972)

     * The column-statistics option (Advanced Options) was
       selected by default in the Administration - Data Export
       tab, which prevented the successful export of databases
       from the 5.6 and 5.7 servers. (Bug #28918423, Bug #92928)

     * The SQL editor and the Alter Table operation both
       reported errors on indexes with valid functional key
       parts and on expressions that were used as default
       values. (Bug #28832740, Bug #92908, Bug #28831069,
       Bug#92900)

     * The actions selected from the history-palette context
       menu did not produce any results. (Bug #28721233)

     * The code auto-completion feature in the query editor did
       not provide the expected behavior. (Bug #28443700,
       Bug#91859)

     * The Close Other Tabs action closed all tabs in the SQL
       editor when it was selected from the context menu of the
       New table - table tab. (Bug #28257404)

     * MySQL Workbench stopped working on Linux hosts after a
       long period of use that included adding new tables to an
       existing model. (Bug #28257141)

     * With a set of objects selected to import from the dump
       project folder, only the first object of the set was
       shown in the Schema Objects list, instead of all selected
       objects. In addition, the first object was repeated
       multiple times in the list. (Bug #28222744)

     * MySQL Workbench was unable to start a session to the
       server on MacOS hosts until a successful login was
       performed at the command line first. (Bug #28165625)

     * Some keyboard shortcuts were unsuccessful when used
       properly. (Bug #28108104, Bug #91090)

     * A valid query using an appropriate server version for
       window functions displayed a syntax error at the opening
       parenthesis of the first OVER clause in the query editor.
       (Bug #27922827, Bug #90620)

     * The template that was generated for a table of a model
       did not include type values within the Datatype column.
       (Bug #27025456)

     * Items listed within the Schemas tab were not visible when
       selected on Linux. (Bug #26579157, Bug #87321)

     * The test-connection action in older versions caused MySQL
       Workbench to stop working when it was used to test
       standard TCP/IP over SSH connections during the initial
       setup. (Bug #21144432)

     * A warning was generated during attempts to migrate source
       tables from Microsoft SQL Server with a valid ODBC driver
       if a column name included unrecognized characters. The
       reverse engineering operation reported that an impacted
       table had no column attributes, and the migration stopped
       with errors later in the process. (Bug #18109616,
       Bug#71336)

     * The operation to check for MySQL Workbench updates (from
       Help) returned an error when used behind a proxy server
       with authentication. (Bug #13864621, Bug #64308)


On Behalf of Oracle/MySQL Release Engineering Team,
Balasubramanian Kandasamy