[pkgsrc/trunk]: pkgsrc/databases Changes 5.5.36:

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/d5ce53c4ab5c
branches:  trunk
changeset: 629951:d5ce53c4ab5c
user:      adam <adam%pkgsrc.org@localhost>
date:      Sat Feb 01 11:16:03 2014 +0000

description:
Changes 5.5.36:

Functionality Added or Changed

CMake now supports a -DTMPDIR=dir_name option to specify the default tmpdir value. If unspecified, the value defaults to P_tmpdir in <stdio.h>. Thanks to Honza Horak for the patch.

Bugs Fixed

InnoDB: Table renaming errors would appear in the LATEST FOREIGN KEY ERROR section of the SHOW ENGINE INNODB STATUS output.

Partitioning: Queries using the index_merge optimization (see Index Merge Optimization) could return invalid results when run against tables that were partitioned by HASH.

Partitioning: When no partition had returned a row since the last HA_ERR_KEY_NOT_FOUND error, the use of uninitialized memory in the priority queue used for returning rows in sorted order could lead 
to a crash of the server.

Replication: mysqlbinlog --verbose failed when it encountered a corrupt row event in the binary log. Such a row event could also cause the slave to fail.

Replication: When log_warnings is greater than 1, the master prints binary log dump thread information—containing the slave server ID, binary log file name, and binary log position—in mysqld.1.err. A 
slave server ID greater than 2 billion was printed with a negative value in such cases.

Replication: Invalid event offsets in the binary log were not always handled correctly, which could lead to replication failure.

The cache used for the Index Merge access method was freed only after successful retrieval of all rows. Interruption or failure of the operation led to a file descriptor leak.

For utf8 and utf8mb4 strings, handler functions unnecessarily called a Unicode conversion function.

Use of a nonmulti-byte algorithm for skipping leading spaces in multi-byte strings could cause a server exit.

For the utf8_bin collation, ORDER BY LOWER(col_name) could produce incorrect ordering.

On Windows, the --local-service server option did not work, and was not displayed in the --help message.

The prototype of the Performance Schema instrumentation API mysql_cond_timedwait() call was fixed to be drop-in compatible with pthread_cond_timedwait(). This fix affects only implementers of 
third-party plugins.

For the path specified with the --basedir option, mysql_plugin attempted to unlink the path rather than free the memory in which the path was stored.

COUNT(DISTINCT) sometimes produced an incorrect result when the last read row contained a NULL value.

Some scripts displayed out-of-date information regarding where to report bugs.

Updating a FEDERATED table with UPDATE... JOIN caused a server exit when the local table contained a single row and that row could be joined to a row in the FEDERATED table.

mysql_install_db referred to the obsolete mysqlbug script for reporting problems. It now refers to http://bugs.mysql.com/ instead.

diffstat:

 databases/mysql55-client/Makefile.common |   4 +-
 databases/mysql55-client/distinfo        |   8 ++--
 databases/mysql55-server/PLIST           |  47 +++++++++++++++++--------------
 3 files changed, 31 insertions(+), 28 deletions(-)

diffs (200 lines):

diff -r 4cbe2e5a42c6 -r d5ce53c4ab5c databases/mysql55-client/Makefile.common
--- a/databases/mysql55-client/Makefile.common  Sat Feb 01 11:14:06 2014 +0000
+++ b/databases/mysql55-client/Makefile.common  Sat Feb 01 11:16:03 2014 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.33 2013/12/03 15:40:19 adam Exp $
+# $NetBSD: Makefile.common,v 1.34 2014/02/01 11:16:03 adam Exp $
 #
 # used by databases/mysql55-client/Makefile
 # used by databases/mysql55-server/Makefile
 
-DISTNAME=      mysql-5.5.35
+DISTNAME=      mysql-5.5.36
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.5/}
 
diff -r 4cbe2e5a42c6 -r d5ce53c4ab5c databases/mysql55-client/distinfo
--- a/databases/mysql55-client/distinfo Sat Feb 01 11:14:06 2014 +0000
+++ b/databases/mysql55-client/distinfo Sat Feb 01 11:16:03 2014 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.29 2013/12/15 18:45:18 asau Exp $
+$NetBSD: distinfo,v 1.30 2014/02/01 11:16:03 adam Exp $
 
-SHA1 (mysql-5.5.35.tar.gz) = ede7015b698bef5ede4c59a7a9d428b2a679ac77
-RMD160 (mysql-5.5.35.tar.gz) = 5bdd8fdeaaefe3c60bc5fc16daf6e19c8b8ca7a4
-Size (mysql-5.5.35.tar.gz) = 21707804 bytes
+SHA1 (mysql-5.5.36.tar.gz) = 581d49e1a38d5536c8268350e2f91ed9d461909d
+RMD160 (mysql-5.5.36.tar.gz) = 7651338751545a30652836d9c7bb0d3102592180
+Size (mysql-5.5.36.tar.gz) = 21723910 bytes
 SHA1 (patch-BUILD_compile-pentium-gcov) = a1ac666efa953a98455a726e5db359c903d699b6
 SHA1 (patch-CMakeLists.txt) = 0c4263762d2d9fafd84b25038cae57a87fed339d
 SHA1 (patch-client_completion_hash.cc) = e27fd7072a8206380f0a932b1a31d2843c985cbf
diff -r 4cbe2e5a42c6 -r d5ce53c4ab5c databases/mysql55-server/PLIST
--- a/databases/mysql55-server/PLIST    Sat Feb 01 11:14:06 2014 +0000
+++ b/databases/mysql55-server/PLIST    Sat Feb 01 11:16:03 2014 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.25 2013/12/03 15:40:19 adam Exp $
+@comment $NetBSD: PLIST,v 1.26 2014/02/01 11:16:03 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -2906,8 +2906,8 @@
 share/mysql/test/suite/innodb/r/innodb-autoinc-optimize.result
 share/mysql/test/suite/innodb/r/innodb-autoinc.result
 share/mysql/test/suite/innodb/r/innodb-blob.result
+share/mysql/test/suite/innodb/r/innodb-change-buffer-recovery.result
 share/mysql/test/suite/innodb/r/innodb-consistent.result
-share/mysql/test/suite/innodb/r/innodb-create-options.result
 share/mysql/test/suite/innodb/r/innodb-index.result
 share/mysql/test/suite/innodb/r/innodb-index_ucs2.result
 share/mysql/test/suite/innodb/r/innodb-lock.result
@@ -2917,7 +2917,6 @@
 share/mysql/test/suite/innodb/r/innodb-truncate.result
 share/mysql/test/suite/innodb/r/innodb-ucs2.result
 share/mysql/test/suite/innodb/r/innodb-use-sys-malloc.result
-share/mysql/test/suite/innodb/r/innodb-zip.result
 share/mysql/test/suite/innodb/r/innodb.result
 share/mysql/test/suite/innodb/r/innodb_autoinc_lock_mode_zero.result
 share/mysql/test/suite/innodb/r/innodb_bug11754376.result
@@ -2937,8 +2936,6 @@
 share/mysql/test/suite/innodb/r/innodb_bug34053.result
 share/mysql/test/suite/innodb/r/innodb_bug34300.result
 share/mysql/test/suite/innodb/r/innodb_bug35220.result
-share/mysql/test/suite/innodb/r/innodb_bug36169.result
-share/mysql/test/suite/innodb/r/innodb_bug36172.result
 share/mysql/test/suite/innodb/r/innodb_bug38231.result
 share/mysql/test/suite/innodb/r/innodb_bug39438.result
 share/mysql/test/suite/innodb/r/innodb_bug40360.result
@@ -2963,16 +2960,13 @@
 share/mysql/test/suite/innodb/r/innodb_bug51920.result
 share/mysql/test/suite/innodb/r/innodb_bug52199.result
 share/mysql/test/suite/innodb/r/innodb_bug52663.result
-share/mysql/test/suite/innodb/r/innodb_bug52745.result
 share/mysql/test/suite/innodb/r/innodb_bug53046.result
 share/mysql/test/suite/innodb/r/innodb_bug53290.result
-share/mysql/test/suite/innodb/r/innodb_bug53591.result
 share/mysql/test/suite/innodb/r/innodb_bug53592.result
 share/mysql/test/suite/innodb/r/innodb_bug53674.result
 share/mysql/test/suite/innodb/r/innodb_bug53756.result
 share/mysql/test/suite/innodb/r/innodb_bug54044.result
 share/mysql/test/suite/innodb/r/innodb_bug56143.result
-share/mysql/test/suite/innodb/r/innodb_bug56680.result
 share/mysql/test/suite/innodb/r/innodb_bug56716.result
 share/mysql/test/suite/innodb/r/innodb_bug56947.result
 share/mysql/test/suite/innodb/r/innodb_bug57252.result
@@ -2985,11 +2979,9 @@
 share/mysql/test/suite/innodb/r/innodb_bug60049.result
 share/mysql/test/suite/innodb/r/innodb_bug60196.result
 share/mysql/test/suite/innodb/r/innodb_bug60229.result
-share/mysql/test/suite/innodb/r/innodb_cmp_drop_table.result
 share/mysql/test/suite/innodb/r/innodb_corrupt_bit.result
 share/mysql/test/suite/innodb/r/innodb_file_format.result
 share/mysql/test/suite/innodb/r/innodb_gis.result
-share/mysql/test/suite/innodb/r/innodb_index_large_prefix.result
 share/mysql/test/suite/innodb/r/innodb_information_schema.result
 share/mysql/test/suite/innodb/r/innodb_information_schema_buffer.result
 share/mysql/test/suite/innodb/r/innodb_lock_wait_timeout_1.result
@@ -2998,7 +2990,6 @@
 share/mysql/test/suite/innodb/r/innodb_mysql.result
 share/mysql/test/suite/innodb/r/innodb_mysql_rbk.result
 share/mysql/test/suite/innodb/r/innodb_notembedded.result
-share/mysql/test/suite/innodb/r/innodb_prefix_index_liftedlimit.result
 share/mysql/test/suite/innodb/r/innodb_prefix_index_restart_server.result
 share/mysql/test/suite/innodb/r/innodb_replace.result
 share/mysql/test/suite/innodb/r/innodb_timeout_rollback.result
@@ -3014,9 +3005,10 @@
 share/mysql/test/suite/innodb/t/innodb-autoinc-optimize.test
 share/mysql/test/suite/innodb/t/innodb-autoinc.test
 share/mysql/test/suite/innodb/t/innodb-blob.test
+share/mysql/test/suite/innodb/t/innodb-change-buffer-recovery-master.opt
+share/mysql/test/suite/innodb/t/innodb-change-buffer-recovery.test
 share/mysql/test/suite/innodb/t/innodb-consistent-master.opt
 share/mysql/test/suite/innodb/t/innodb-consistent.test
-share/mysql/test/suite/innodb/t/innodb-create-options.test
 share/mysql/test/suite/innodb/t/innodb-index.test
 share/mysql/test/suite/innodb/t/innodb-index_ucs2.test
 share/mysql/test/suite/innodb/t/innodb-lock.test
@@ -3029,7 +3021,6 @@
 share/mysql/test/suite/innodb/t/innodb-ucs2.test
 share/mysql/test/suite/innodb/t/innodb-use-sys-malloc-master.opt
 share/mysql/test/suite/innodb/t/innodb-use-sys-malloc.test
-share/mysql/test/suite/innodb/t/innodb-zip.test
 share/mysql/test/suite/innodb/t/innodb.test
 share/mysql/test/suite/innodb/t/innodb_autoinc_lock_mode_zero-master.opt
 share/mysql/test/suite/innodb/t/innodb_autoinc_lock_mode_zero.test
@@ -3054,8 +3045,6 @@
 share/mysql/test/suite/innodb/t/innodb_bug34053.test
 share/mysql/test/suite/innodb/t/innodb_bug34300.test
 share/mysql/test/suite/innodb/t/innodb_bug35220.test
-share/mysql/test/suite/innodb/t/innodb_bug36169.test
-share/mysql/test/suite/innodb/t/innodb_bug36172.test
 share/mysql/test/suite/innodb/t/innodb_bug38231.test
 share/mysql/test/suite/innodb/t/innodb_bug39438-master.opt
 share/mysql/test/suite/innodb/t/innodb_bug39438.test
@@ -3083,10 +3072,8 @@
 share/mysql/test/suite/innodb/t/innodb_bug51920.test
 share/mysql/test/suite/innodb/t/innodb_bug52199.test
 share/mysql/test/suite/innodb/t/innodb_bug52663.test
-share/mysql/test/suite/innodb/t/innodb_bug52745.test
 share/mysql/test/suite/innodb/t/innodb_bug53046.test
 share/mysql/test/suite/innodb/t/innodb_bug53290.test
-share/mysql/test/suite/innodb/t/innodb_bug53591.test
 share/mysql/test/suite/innodb/t/innodb_bug53592.test
 share/mysql/test/suite/innodb/t/innodb_bug53674-master.opt
 share/mysql/test/suite/innodb/t/innodb_bug53674.test
@@ -3094,7 +3081,6 @@
 share/mysql/test/suite/innodb/t/innodb_bug53756.test
 share/mysql/test/suite/innodb/t/innodb_bug54044.test
 share/mysql/test/suite/innodb/t/innodb_bug56143.test
-share/mysql/test/suite/innodb/t/innodb_bug56680.test
 share/mysql/test/suite/innodb/t/innodb_bug56716.test
 share/mysql/test/suite/innodb/t/innodb_bug56947.test
 share/mysql/test/suite/innodb/t/innodb_bug57252.test
@@ -3110,13 +3096,10 @@
 share/mysql/test/suite/innodb/t/innodb_bug60196.test
 share/mysql/test/suite/innodb/t/innodb_bug60229-master.opt
 share/mysql/test/suite/innodb/t/innodb_bug60229.test
-share/mysql/test/suite/innodb/t/innodb_cmp_drop_table-master.opt
-share/mysql/test/suite/innodb/t/innodb_cmp_drop_table.test
 share/mysql/test/suite/innodb/t/innodb_corrupt_bit.test
 share/mysql/test/suite/innodb/t/innodb_file_format-master.opt
 share/mysql/test/suite/innodb/t/innodb_file_format.test
 share/mysql/test/suite/innodb/t/innodb_gis.test
-share/mysql/test/suite/innodb/t/innodb_index_large_prefix.test
 share/mysql/test/suite/innodb/t/innodb_information_schema.test
 share/mysql/test/suite/innodb/t/innodb_information_schema_buffer.test
 share/mysql/test/suite/innodb/t/innodb_lock_wait_timeout_1-master.opt
@@ -3129,12 +3112,32 @@
 share/mysql/test/suite/innodb/t/innodb_mysql_rbk-master.opt
 share/mysql/test/suite/innodb/t/innodb_mysql_rbk.test
 share/mysql/test/suite/innodb/t/innodb_notembedded.test
-share/mysql/test/suite/innodb/t/innodb_prefix_index_liftedlimit.test
 share/mysql/test/suite/innodb/t/innodb_prefix_index_restart_server.test
 share/mysql/test/suite/innodb/t/innodb_replace.test
 share/mysql/test/suite/innodb/t/innodb_timeout_rollback-master.opt
 share/mysql/test/suite/innodb/t/innodb_timeout_rollback.test
 share/mysql/test/suite/innodb/t/innodb_trx_weight.test
+share/mysql/test/suite/innodb_zip/r/innodb-create-options.result
+share/mysql/test/suite/innodb_zip/r/innodb-zip.result
+share/mysql/test/suite/innodb_zip/r/innodb_bug36169.result
+share/mysql/test/suite/innodb_zip/r/innodb_bug36172.result
+share/mysql/test/suite/innodb_zip/r/innodb_bug52745.result
+share/mysql/test/suite/innodb_zip/r/innodb_bug53591.result
+share/mysql/test/suite/innodb_zip/r/innodb_bug56680.result
+share/mysql/test/suite/innodb_zip/r/innodb_cmp_drop_table.result
+share/mysql/test/suite/innodb_zip/r/innodb_index_large_prefix.result
+share/mysql/test/suite/innodb_zip/r/innodb_prefix_index_liftedlimit.result
+share/mysql/test/suite/innodb_zip/t/innodb-create-options.test
+share/mysql/test/suite/innodb_zip/t/innodb-zip.test
+share/mysql/test/suite/innodb_zip/t/innodb_bug36169.test
+share/mysql/test/suite/innodb_zip/t/innodb_bug36172.test
+share/mysql/test/suite/innodb_zip/t/innodb_bug52745.test
+share/mysql/test/suite/innodb_zip/t/innodb_bug53591.test
+share/mysql/test/suite/innodb_zip/t/innodb_bug56680.test
+share/mysql/test/suite/innodb_zip/t/innodb_cmp_drop_table-master.opt
+share/mysql/test/suite/innodb_zip/t/innodb_cmp_drop_table.test
+share/mysql/test/suite/innodb_zip/t/innodb_index_large_prefix.test
+share/mysql/test/suite/innodb_zip/t/innodb_prefix_index_liftedlimit.test
 share/mysql/test/suite/jp/include/trim_sjis.inc
 share/mysql/test/suite/jp/r/jp_alter_sjis.result
 share/mysql/test/suite/jp/r/jp_alter_ucs2.result