CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Mar 31 10:32:13 UTC 2014

Modified Files:
        pkgsrc/databases/mysql56-client: Makefile.common distinfo
        pkgsrc/databases/mysql56-server: PLIST

Log Message:
Changes 5.6.17:

Functionality Added or Changed

Incompatible Change: The AES_ENCRYPT() and AES_DECRYPT() functions now permit 
control of the block encryption mode and take an optional initialization vector 
argument:

The new block_encryption_mode system variable controls the mode for block-based 
encryption algorithms. Its default value is aes-128-ecb, which signifies 
encryption using a key length of 128 bits and ECB mode.

An optional init_vector argument provides an initialization vector for 
encryption modes that require it:

AES_ENCRYPT(str,key_str[,init_vector])
AES_DECRYPT(crypt_str,key_str[,init_vector])
A random string of bytes to use for the initialization vector can be produced 
by calling the new RANDOM_BYTES() function.

For more information, see Encryption and Compression Functions.

These changes make statements that use AES_ENCRYPT() or AES_DECRYPT() unsafe 
for statement-based replication and they cannot be stored in the query cache. 
Queries that use RANDOM_BYTES() are unsafe for statement-based replication and 
cannot be stored in the query cache.

Incompatible Change: The ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE, and 
NO_ZERO_IN_DATE SQL modes now are deprecated and setting the sql_mode value to 
include any of them generates a warning. In MySQL 5.7, these modes do nothing. 
Instead, their effects are included in the effects of strict SQL mode 
(STRICT_ALL_TABLES or STRICT_TRANS_TABLES). The motivation for the change in 
MySQL 5.7 is to reduce the number of SQL modes with an effect dependent on 
strict mode and make them part of strict mode itself.

To make advance preparation for an upgrade to MySQL 5.7, see SQL Mode Changes 
in MySQL 5.7. That discussion provides guidelines to assess whether your 
applications will be affected by the SQL mode changes in MySQL 5.7.

InnoDB: MySQL now supports rebuilding regular and partitioned InnoDB tables 
using online DDL (ALGORITHM=INPLACE) for the following operations:

OPTIMIZE TABLE

ALTER TABLE ... FORCE

ALTER TABLE ... ENGINE=INNODB (when run on an InnoDB table)

Online DDL support reduces table rebuild time and permits concurrent DML, which 
helps reduce user application downtime. For additional information, see 
Overview of Online DDL.

On Solaris, mysql_config --libs now includes -R/path/to/library so that 
libraries can be found at runtime.

mysql_install_db provides a more informative diagnostic message when required 
Perl modules are missing.

The IGNORE clause for ALTER TABLE is now deprecated and will be removed in a 
future version of MySQL. ALTER IGNORE TABLE causes problems for replication, 
prevents online ALTER TABLE for unique index creation, and causes problems with 
foreign keys (rows removed in the parent table).

Bugs Fixed


To generate a diff of this commit:
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/mysql56-client/Makefile.common \
    pkgsrc/databases/mysql56-client/distinfo
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/mysql56-server/PLIST

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.