Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2018-01-16 17:27:12
Message id: 20180116162713.16F04FBDE@cvs.NetBSD.org

Log Message:
mysql56: updated to 5.6.39

MySQL 5.6.39

Configuration Notes
* For RHEL, SLES, and Fedora RPMs, the default plugin directory for debug builds \ 
has been changed from /usr/lib64/mysql/plugin to /usr/lib64/mysql/plugin/debug.

Security Notes
* Incompatible Change: Passwords are now restricted to a maximum of 256 \ 
characters for the sha256_password authentication plugin, and for the PASSWORD() \ 
function when old_passwords=2. Also, the number of password hashing rounds is \ 
capped to limit CPU time used.
* The linked OpenSSL library for the MySQL Commercial Server has been updated to \ 
version 1.0.2n. Issues fixed in the new OpenSSL version are described at \ 
http://www.openssl.org/news/vulnerabilities.html.
* This change does not affect the Oracle-produced MySQL Community build of MySQL \ 
Server, which uses the yaSSL library instead.

Test Suite Notes
* Documentation for the MySQL Test Suite is now maintained in the MySQL source \ 
tree using Doxygen (see \ 
http://dev.mysql.com/doc/dev/mysql-server/latest/PAGE_MYSQL_TEST_RUN.html). The \ 
related Unix man pages that previously were produced from the old test suite \ 
manual are no longer updated and have gone out of date. Consequently, they are \ 
no longer included in MySQL distributions.

Bugs Fixed
* InnoDB: An ALTER TABLE operation caused the server to halt.
* InnoDB: A FLUSH TABLES operation failed to drop an aborted index. While \ 
removing the table from the cache, the clustered index was dropped prior to \ 
checking for the aborted index.
* InnoDB: Warnings that should only appear in a debug version of MySQL were \ 
printed to the error log when the length of the history list exceeded 2000000.
* InnoDB: Full-text search on indexed columns that use a binary collation did \ 
not return case sensitive matches.
* Partitioning: In certain cases when fetching heap records a partition ID could \ 
be set to zero.
* Replication: With semisynchronous replication in use, if RESET MASTER was \ 
issued while an active transaction was waiting for an acknowledgement from the \ 
slave, the count of waiting sessions in the Rpl_semi_sync_master_wait_sessions \ 
server status variable was incorrect after the wait was completed.
* Microsoft Windows: On Windows, with the myisam_use_mmap and flush system \ 
variables enabled, MyISAM did not always flush table files properly.
* Microsoft Windows: On Windows, resolution was improved of a timer used for \ 
query performance assessment.
* VALUES() was not handled correctly in some cases.
* The Performance Schema now stores rewritten rather than raw SQL statement text \ 
when available.
* Incorrect results or a server exit could result when SHA2() was passed a \ 
user-defined variable in some character sets.
* Creating a table with excessive index information could cause a server exit.
* REFERENCES privilege checking could use the incorrect database in some cases.
* Some statements could cause a buffer overflow in the digest code. Thanks to \ 
Laurynas Biveinis and Roel van de Paar for the patch.
* Incorrect results could occur on a table with a unique index when the \ 
optimizer chose a loose index scan even though the unique index had no index \ 
extensions.
* Executing a stored procedure containing a statement that created a table from \ 
the contents of certain SELECT statements could result in a memory leak.
* For geometry calculations, invalid input parameters could lead to an incorrect \ 
result buffer and cause an assertion to be raised or a server exit.
* Setting the MYSQL_GROUP_SUFFIX environment variable had no effect.
* A circular dependency problem involving sql/sql_builtin.cc was resolved.
* A prepared statement containing an ORDER BY list that referred to a parameter \ 
was not always handled correctly.

Files:
RevisionActionfile
1.44modifypkgsrc/databases/mysql56-client/Makefile.common
1.45modifypkgsrc/databases/mysql56-client/distinfo
1.31modifypkgsrc/databases/mysql56-server/PLIST