Subject: CVS commit: pkgsrc/databases
From: Adam Ciarcinski
Date: 2013-10-01 12:26:39
Message id: 20131001102639.D4FC796@cvs.netbsd.org

Log Message:
Changes 5.6.14:
* MySQL 5.7 changed audit log file output to a new format that has better \ 
compatibility with Oracle Audit Vault. This format has been backported to MySQL \ 
5.6 and it is possible to select either the old or new format using the new \ 
audit_log_format system variable, which has permitted values of OLD and NEW \ 
(default OLD). For details about each format, see The Audit Log File.
* Important Change; Replication: START SLAVE UNTIL SQL_AFTER_GTIDS did not cause \ 
the slave to stop until the next GTID event was received following execution of \ 
the transaction having the indicated GTID, which could cause issues in the case \ 
when the next GTID event is delayed, or does not exist. Now the slave stops \ 
after completing the transaction with that GTID.
* InnoDB; Partitioning: Following any query on the INFORMATION_SCHEMA.PARTITIONS \ 
table, InnoDB index statistics as shown in the output of statements such as \ 
SELECT * FROM INFORMATION_SCHEMA.STATISTICS were read from the last partition, \ 
instead of from the partition containing the greatest number of rows.
* InnoDB: When logging the delete-marking of a record during online ALTER \ 
TABLE...ADD PRIMARY KEY, InnoDB writes the transaction ID to the log as it was \ 
before the deletion or delete-marking of the record. When doing this, InnoDB \ 
would overwrite the DB_TRX_ID field in the original table, which could result in \ 
locking issues.
* InnoDB: The row_sel_sec_rec_is_for_clust_rec function would incorrectly \ 
prepare to compare a NULL column prefix in a secondary index with a non-NULL \ 
column in a clustered index.
* InnoDB: An incorrect purge would occur when rolling back an update to a \ 
delete-marked record.
* InnoDB: An assertion would be raised in fil_node_open_file due to a missing \ 
.ibd file. Instead of asserting, InnoDB should return false and the caller of \ 
fil_node_open_file should handle the return message.
* InnoDB: The assertion ut_ad(oldest_lsn <= cur_lsn) in file buf0flu.cc would \ 
fail because the current max LSN would be retrieved from the buffer pool before \ 
the oldest LSN.
* InnoDB: InnoDB memcached add and set operations would perform more slowly than \ 
SQL INSERT operations.
* InnoDB: The InnoDB memcached plugin could be initialized to insert into an \ 
InnoDB table with an INTEGER primary key.
More...

Files:
RevisionActionfile
1.8modifypkgsrc/databases/mysql56-client/Makefile
1.10modifypkgsrc/databases/mysql56-client/Makefile.common
1.10modifypkgsrc/databases/mysql56-client/distinfo
1.2modifypkgsrc/databases/mysql56-client/patches/patch-sql_transaction.cc
1.5modifypkgsrc/databases/mysql56-server/PLIST