Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2019-02-05 21:06:06
Message id: 20190205200606.CE311FB16@cvs.NetBSD.org

Log Message:
mysql56-{client,server}: updated to 5.6.43

Changes in MySQL 5.6.43:

Functionality Added or Changed

Microsoft Windows: The access control granted to clients on the named pipe \ 
created by the MySQL server now is set to the minimum necessary for successful \ 
communication on Windows. Newer MySQL client software can open named pipe \ 
connections without any additional configuration. If older client software \ 
cannot be upgraded immediately, the new named_pipe_full_access_group server \ 
system variable can be used to give a Windows group the necessary permissions to \ 
open a named pipe connection. Membership in the full-access group should be \ 
restricted and temporary.

Bugs Fixed

Replication: A patch to correct the handling of quotes for identifiers in \ 
ROLLBACK TO SAVEPOINT statements in the binary log was not correctly applied to \ 
subsequent MySQL versions.

Replication: In some circumstances, the CHANGE MASTER TO statement could not be \ 
used on a replication slave if the master info log had been changed from a table \ 
(master_info_repository=TABLE) into a file (master_info_repository=FILE).

Replication: The value returned by a SHOW SLAVE STATUS statement for the total \ 
combined size of all existing relay log files (Relay_Log_Space) could become \ 
much larger than the actual disk space used by the relay log files. The I/O \ 
thread did not lock the variable while it updated the value, so the SQL thread \ 
could automatically delete a relay log file and write a reduced value before the \ 
I/O thread finished updating the value. The I/O thread then wrote its original \ 
size calculation, ignoring the SQL thread's update and so adding back the space \ 
for the deleted file. The Relay_Log_Space value is now locked during updates to \ 
prevent concurrent updates and ensure an accurate calculation.

Replication: If the relay log index file was temporarily locked for viewing by a \ 
backup process for a replication slave, and MySQL Server also attempted to \ 
access the file at that time for rename or delete operations, the backup \ 
completed with warnings, but MySQL Server experienced an unexpected halt. MySQL \ 
Server now retries the file access operation a number of times in case this or a \ 
similar scenario is the explanation and the file becomes available again before \ 
long.

The server permitted creation of databases with the same name as redo log files, \ 
which could result in unexpected server behavior. Such names are no longer \ 
permitted as database names.

When a subquery contained a UNION, the count of the number of subquery columns \ 
was calculated incorrectly.

Comparing log file names as strings using the memcmp() function resulted in \ 
uninitialized memory read errors. The comparison now uses the strncmp() \ 
function. Thanks to Zsolt Parragi and Laurynas Biveinis for their contributions.

The transformation of IN subquery predicates into semijoins was not handled \ 
correctly for a very large number of tables.

Executing a prepared statement to do a multiple-row insert with large number of \ 
placeholders consumed excessive memory and could execute slowly.

The parser accepted invalid SET statement syntax in trigger definitions that \ 
could result in a server exit.

MyISAM index corruption could occur for bulk-insert and table-repair operations \ 
that involve the repair-by-sorting algorithm and many (more than 450 million) \ 
rows.

A query employing a dynamic range and an index merge could use more memory than \ 
expected.

Files:
RevisionActionfile
1.29modifypkgsrc/databases/mysql56-client/Makefile
1.47modifypkgsrc/databases/mysql56-client/Makefile.common
1.5modifypkgsrc/databases/mysql56-client/buildlink3.mk
1.50modifypkgsrc/databases/mysql56-client/distinfo
1.13modifypkgsrc/databases/mysql56-client/options.mk
1.36modifypkgsrc/databases/mysql56-server/Makefile
1.33modifypkgsrc/databases/mysql56-server/PLIST