MySQL Community Server 5.6.40 has been released

Dear MySQL users,

MySQL Server 5.6.40, a new version of the popular Open Source
Database Management System, has been released. MySQL 5.6.40 is
recommended for use on production systems.

For an overview of what's new in MySQL 5.6, please see

  http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html

     Starting with 5.6.11, Microsoft Windows packages for MySQL 5.6
     are available both as a "full" installer and as a "web" installer.
     The full installer is significantly larger and comes bundled with
     the latest software releases available. This bundle makes it easy
     to download and configure a full server and development suite.

     The web installer doesn't come bundled with any actual products
     and instead relies on download-on-demand to fetch only the
     products you choose to install. This makes the initial download
     much smaller but increases install time as the individual products
     will need to be downloaded.

For information on installing MySQL 5.6.40 on new servers or upgrading
to MySQL 5.6.40 from previous MySQL releases, please see

  http://dev.mysql.com/doc/refman/5.6/en/installing.html

MySQL Server is available in source and binary form for a number of
platforms from our download pages at

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

Not all mirror sites may be up to date at this point in time, so if you
can't find this version on some mirror, please try again later or choose
another download site.

We welcome and appreciate your feedback, bug reports, bug fixes,
patches, etc:

  https://wikis.oracle.com/display/mysql/Contributing

The following link lists the changes in the MySQL 5.6 since
the release of MySQL 5.6.39. It may also be viewed
online at

  http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-40.html

Enjoy!


Changes in MySQL 5.6.40 (2018-04-19, General Availability)


Functionality Added or Changed


     * If the server PID file is configured to be created in a
       world-writable location, the server now issues a warning
       suggesting use of a more secure location. (Bug #26585560)

Bugs Fixed


     * NDB Cluster: MySQL NDB Cluster encountered race
       conditions compiling lex_hash.h. (Bug #24931655, Bug
       #83477, Bug #27470071, Bug #89482)

     * InnoDB: A REPLACE operation on a temporary table raised
       an assertion. (Bug #27225649)

     * InnoDB: A tablespace import operation on a server with a
       default row format of REDUNDANT raised an assertion
       failure. (Bug #26960215)

     * InnoDB: Evaluation of a subquery in a resolving function
       raised an assertion. (Bug #26909960)

     * InnoDB: An online DDL operation that rebuilds the table
       raised an assertion when the last insert log record to be
       applied was split across two pages. (Bug #26696448, Bug
       #87532)

     * InnoDB: A RENAME TABLE operation that renamed the schema
       failed to rename full-text search common auxiliary tables
       that were left behind when the full-text search index was
       removed previously, resulting in a assertion failure when
       attempting to drop the old schema. (Bug #26334149)

     * Replication: A number of changes were made to the binary
       log decoding procedure to improve handling of invalid or
       corrupted binary log entries. (Bug #24365972)

     * An invalid input polygon for spatial functions could lead
       to undefined server behavior. Now the server returns
       NULL. (Bug #27230859, Bug #88801)

     * Adding a unique index to an InnoDB table on which
       multiple locks were held could raise an assertion. (Bug
       #27216817)

     * For some statements, the FILE privilege was not properly
       checked. (Bug #27160888)

     * ST_Touches() could fail due to a missing null pointer
       check. (Bug #27081349)

     * A multiple-insert statement on a table containing a
       FULLTEXT key and a FTS_DOC_ID column caused a server
       error. (Bug #27041445, Bug #88267)
       References: This issue is a regression of: Bug #22679185.

     * An ALTER TABLE operation attempted to set the
       AUTO_INCREMENT value for table in a discarded tablespace.
       (Bug #26935001)

     * Dropping an index from a system table could cause a
       server exit. (Bug #26881798)

     * A server exit could result from simultaneous attempts by
       multiple threads to register and deregister metadata
       Performance Schema objects. (Bug #26502135)

     * The thread pool plugin logged too much information for
       failed connections. (Bug #26368725, Bug #86863)

     * For debug builds, using KILL to terminate a stored
       routine could raise an assertion. Thanks to Laurynas
       Biveinis for the patch. (Bug #26040870, Bug #86260)

     * MySQL client programs could exit unexpectedly if
       malformed client/server protocol packets were received.
       (Bug #25471090)

     * Incorrect handling by the CONNECTION_CONTROL plugin of an
       internal hash led to spurious messages in the error log
       and eventual server exit. (Bug #25052009)

     * Building MySQL using parallel compilation sometimes
       failed with an attempt to compile sql_yacc.yy before
       lex_token.h had been created. (Bug #21680733, Bug
       #27470071, Bug #89482)

     * On Windows, sql_yacc.cc and sql_yacc.h were generated
       twice during the build process. This can lead to
       compilation failure if parallel processes are permitted.
       (Bug #19060850, Bug #27470071, Bug #89482)

     * The audit_log plugin did not log placeholder values for
       prepared statements. (Bug #16617026)

     * NULLIF() with a TIMESTAMP argument could produce
       truncated output. (Bug #12616286, Bug #61378)

     * MAX() for DATE values smaller than year 100 produced
       incorrect results. (Bug #12546797, Bug #61100)

     * Compilation could fail due to a missing dependency on
       lex_token.h for sql_yacc.cc.o. (Bug #76235, Bug
       #20678411, Bug #27470071, Bug #89482)

As always, a big THANK YOU for using MySQL!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql