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