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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/14c5705eff06
branches:  trunk
changeset: 639911:14c5705eff06
user:      adam <adam%pkgsrc.org@localhost>
date:      Wed Oct 01 09:17:18 2014 +0000

description:
Changes 5.5.40:
InnoDB: An ALTER TABLE ... ADD FOREIGN KEY operation could cause a serious error.
InnoDB: With a transaction isolation level less than or equal to READ COMMITTED, gap locks were not taken when scanning a unique secondary index to check for duplicates. As a result, duplicate check 
logic failed allowing duplicate key values in the unique secondary index.
InnoDB: During recovery, a segmentation fault would occur when marking a table as corrupt.
yaSSL client code did not validate the encryption size or session ID length, which could cause the client to exit.
MySQL installation from RPM packages could fail if Postfix had been installed using yum.
yaSSL could fail preauthorization if the client supplied inaccurate buffer lengths.
Competition between threads could lead to timeout failure trying to rotate the audit log file.
On Linux (OEL6), if Sun DTrace was installed, the MySQL build failed.
LPAD() and RPAD() could cause a server exit if the pad string argument was not well formed.
The optimizer could create a zero-length column for a temporary table, causing a server exit.

diffstat:

 databases/mysql55-client/Makefile.common                  |   4 +-
 databases/mysql55-client/distinfo                         |   9 ++---
 databases/mysql55-client/patches/patch-cmake_dtrace.cmake |  21 ---------------
 databases/mysql55-server/PLIST                            |   8 +++++-
 4 files changed, 13 insertions(+), 29 deletions(-)

diffs (121 lines):

diff -r 9b18225fe84c -r 14c5705eff06 databases/mysql55-client/Makefile.common
--- a/databases/mysql55-client/Makefile.common  Wed Oct 01 09:04:32 2014 +0000
+++ b/databases/mysql55-client/Makefile.common  Wed Oct 01 09:17:18 2014 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.39 2014/08/10 14:27:40 adam Exp $
+# $NetBSD: Makefile.common,v 1.40 2014/10/01 09:17:18 adam Exp $
 #
 # used by databases/mysql55-client/Makefile
 # used by databases/mysql55-server/Makefile
 
-DISTNAME=      mysql-5.5.39
+DISTNAME=      mysql-5.5.40
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.5/}
 
diff -r 9b18225fe84c -r 14c5705eff06 databases/mysql55-client/distinfo
--- a/databases/mysql55-client/distinfo Wed Oct 01 09:04:32 2014 +0000
+++ b/databases/mysql55-client/distinfo Wed Oct 01 09:17:18 2014 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.35 2014/08/10 14:27:40 adam Exp $
+$NetBSD: distinfo,v 1.36 2014/10/01 09:17:18 adam Exp $
 
-SHA1 (mysql-5.5.39.tar.gz) = 718c8a29fb28a2cd9387d9030370415a662aac58
-RMD160 (mysql-5.5.39.tar.gz) = e0f076ad74dffa9b5c416958eab08246771a4ed4
-Size (mysql-5.5.39.tar.gz) = 21713567 bytes
+SHA1 (mysql-5.5.40.tar.gz) = b93a1b14ab2de390014e99b4293e7835da133196
+RMD160 (mysql-5.5.40.tar.gz) = a0b6b9a390ba8a3abc889155d756656b28b98f70
+Size (mysql-5.5.40.tar.gz) = 21727672 bytes
 SHA1 (patch-BUILD_compile-pentium-gcov) = a1ac666efa953a98455a726e5db359c903d699b6
 SHA1 (patch-CMakeLists.txt) = 632e036cd9578d0636328c2259a8529c36f2d14a
 SHA1 (patch-client_completion_hash.cc) = e27fd7072a8206380f0a932b1a31d2843c985cbf
@@ -10,7 +10,6 @@
 SHA1 (patch-client_mysqlbinlog.cc) = e38abe026c10a07808ccd24b596cf13c5079e206
 SHA1 (patch-client_mysqlshow.c) = a12b06241eee91d1ec11e3b7e4f3125aa6c79905
 SHA1 (patch-client_sql_string.cc) = 1547b8d3889af2831c89b97aecdbe8158711a600
-SHA1 (patch-cmake_dtrace.cmake) = 5ae3284589a17a8375b8a546136965fa337f3767
 SHA1 (patch-cmake_libutils.cmake) = 5d75a1762e3db6724bec2d75b45d40b17a5e9d09
 SHA1 (patch-cmake_plugin.cmake) = 2b702af6bf8f251886cea12cf7477abae7659230
 SHA1 (patch-cmake_readline.cmake) = aed279d6740e70d7e0e7565a6d9f0f214c866c8d
diff -r 9b18225fe84c -r 14c5705eff06 databases/mysql55-client/patches/patch-cmake_dtrace.cmake
--- a/databases/mysql55-client/patches/patch-cmake_dtrace.cmake Wed Oct 01 09:04:32 2014 +0000
+++ /dev/null   Thu Jan 01 00:00:00 1970 +0000
@@ -1,21 +0,0 @@
-$NetBSD: patch-cmake_dtrace.cmake,v 1.1 2014/02/13 15:47:15 jperkin Exp $
-
-Build with newer DTrace.
-
---- cmake/dtrace.cmake.orig    2014-01-14 08:16:26.000000000 +0000
-+++ cmake/dtrace.cmake
-@@ -35,10 +35,11 @@ MACRO(CHECK_DTRACE)
-  MARK_AS_ADVANCED(DTRACE)
- 
-  # On FreeBSD, dtrace does not handle userland tracing yet
-- IF(DTRACE AND NOT CMAKE_SYSTEM_NAME MATCHES "FreeBSD"
--     AND NOT BUGGY_GCC_NO_DTRACE_MODULES)
--   SET(ENABLE_DTRACE ON CACHE BOOL "Enable dtrace")
-+ IF(ENABLE_DTRACE AND (CMAKE_SYSTEM_NAME MATCHES "FreeBSD"
-+    OR BUGGY_GCC_NO_DTRACE_MODULES OR NOT DTRACE))
-+  MESSAGE(FATAL_ERROR "dtrace is not supported on this system")
-  ENDIF()
-+
-  SET(HAVE_DTRACE ${ENABLE_DTRACE})
-  IF(CMAKE_SYSTEM_NAME MATCHES "SunOS")
-    IF(CMAKE_SIZEOF_VOID_P EQUAL 4)
diff -r 9b18225fe84c -r 14c5705eff06 databases/mysql55-server/PLIST
--- a/databases/mysql55-server/PLIST    Wed Oct 01 09:04:32 2014 +0000
+++ b/databases/mysql55-server/PLIST    Wed Oct 01 09:17:18 2014 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.30 2014/08/10 14:27:40 adam Exp $
+@comment $NetBSD: PLIST,v 1.31 2014/10/01 09:17:18 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -732,6 +732,7 @@
 share/mysql/test/r/ctype_collate.result
 share/mysql/test/r/ctype_cp1250_ch.result
 share/mysql/test/r/ctype_cp1251.result
+share/mysql/test/r/ctype_cp932.result
 share/mysql/test/r/ctype_cp932_binlog_row.result
 share/mysql/test/r/ctype_cp932_binlog_stm.result
 share/mysql/test/r/ctype_create.result
@@ -974,6 +975,7 @@
 share/mysql/test/r/lock_multi_bug38691.result
 share/mysql/test/r/lock_sync.result
 share/mysql/test/r/lock_tables_lost_commit.result
+share/mysql/test/r/log_errchk.result
 share/mysql/test/r/log_state.result
 share/mysql/test/r/log_state_bug33693.result
 share/mysql/test/r/log_tables-big.result
@@ -2903,6 +2905,7 @@
 share/mysql/test/suite/funcs_2/t/suite.opt
 share/mysql/test/suite/innodb/r/blob-update-debug.result
 share/mysql/test/suite/innodb/r/create-index.result
+share/mysql/test/suite/innodb/r/foreign-keys.result
 share/mysql/test/suite/innodb/r/innodb-analyze.result
 share/mysql/test/suite/innodb/r/innodb-autoinc-18274.result
 share/mysql/test/suite/innodb/r/innodb-autoinc-44030.result
@@ -3003,6 +3006,7 @@
 share/mysql/test/suite/innodb/t/blob-update-debug.test
 share/mysql/test/suite/innodb/t/create-index.test
 share/mysql/test/suite/innodb/t/disabled.def
+share/mysql/test/suite/innodb/t/foreign-keys.test
 share/mysql/test/suite/innodb/t/innodb-analyze.test
 share/mysql/test/suite/innodb/t/innodb-autoinc-18274.test
 share/mysql/test/suite/innodb/t/innodb-autoinc-44030-master.opt
@@ -5688,6 +5692,7 @@
 share/mysql/test/t/ctype_collate.test
 share/mysql/test/t/ctype_cp1250_ch.test
 share/mysql/test/t/ctype_cp1251.test
+share/mysql/test/t/ctype_cp932.test
 share/mysql/test/t/ctype_cp932_binlog_row.test
 share/mysql/test/t/ctype_cp932_binlog_stm.test
 share/mysql/test/t/ctype_create.test
@@ -5910,6 +5915,7 @@
 share/mysql/test/t/lock_sync.test
 share/mysql/test/t/lock_tables_lost_commit-master.opt
 share/mysql/test/t/lock_tables_lost_commit.test
+share/mysql/test/t/log_errchk.test
 share/mysql/test/t/log_state-master.opt
 share/mysql/test/t/log_state.test
 share/mysql/test/t/log_state_bug33693-master.opt