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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/103c83f4228b
branches:  trunk
changeset: 635271:103c83f4228b
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon Jun 02 07:17:31 2014 +0000

description:
Changes 5.5.38:

Bugs Fixed

InnoDB: For each insert, memset would be called three times to allocate memory for system fields. To reduce CPU usage, the three memset calls are now combined into a single call.

Replication: When used on a table employing a transactional storage engine, a failed TRUNCATE TABLE was still written to the binary log and thus replayed on the slave. This could lead to 
inconsistency when the master retained data that was removed on the slave.

Now in such cases TRUNCATE TABLE is logged only when it executes successfully.

Certain INFORMATION_SCHEMA queries could cause a server exit.

For indexes on prefixes or character string columns, index corruption could occur for assignment of binary data to the column due to improper character counting.

Solaris-specific scripts were included in and installed by non-Solaris packages.

EXPLAIN on a query with an EXISTS subquery containing a UNION could cause a server exit. Multiple executions of a prepared EXPLAIN on a UNION of subqueries could cause a server exit.

Executing a correlated subquery on an ARCHIVE table which has an AUTO_INCREMENT column caused the server to hang.

The client library could cause clients to exit due to incorrectly mapping the client error number to the corresponding message, if reallocation of packet buffer memory occurred.

Calling mysql_get_server_version() with an invalid connection handler argument caused the client to exit. Now it returns 0 and reports a CR_COMMANDS_OUT_OF_SYNC error.

On Windows, calling mysql_thread_init() call without mysql_init() caused the client to exit. windows. Now it returns a nonzero result because it is an error to call mysql_thread_init() before the 
client library is initialized with mysql_library_init().

CMake produced not-useful warnings about INTERFACE_LINK_LIBRARIES policy.

LOAD DATA LOCAL INFILE could use all CPU if import errors occurred when there were no line delimiters.

A statement of the following form broke row-based replication because it created a table having a field of data type BIGINT with a display width of 3000, which is beyond the maximum acceptable value 
of 255:

CREATE TABLE t1 AS SELECT REPEAT('A',1000) DIV 1 AS a;

diffstat:

 databases/mysql55-client/Makefile        |  3 +--
 databases/mysql55-client/Makefile.common |  4 ++--
 databases/mysql55-client/distinfo        |  8 ++++----
 databases/mysql55-server/PLIST           |  7 +++++--
 4 files changed, 12 insertions(+), 10 deletions(-)

diffs (92 lines):

diff -r 7d15208988ca -r 103c83f4228b databases/mysql55-client/Makefile
--- a/databases/mysql55-client/Makefile Mon Jun 02 06:56:16 2014 +0000
+++ b/databases/mysql55-client/Makefile Mon Jun 02 07:17:31 2014 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2014/05/29 23:35:25 wiz Exp $
+# $NetBSD: Makefile,v 1.18 2014/06/02 07:17:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/-client-/}
-PKGREVISION=   1
 SVR4_PKGNAME=  mysqc
 COMMENT=       MySQL 5, a free SQL database (client)
 
diff -r 7d15208988ca -r 103c83f4228b databases/mysql55-client/Makefile.common
--- a/databases/mysql55-client/Makefile.common  Mon Jun 02 06:56:16 2014 +0000
+++ b/databases/mysql55-client/Makefile.common  Mon Jun 02 07:17:31 2014 +0000
@@ -1,9 +1,9 @@
-# $NetBSD: Makefile.common,v 1.36 2014/04/14 00:02:49 rodent Exp $
+# $NetBSD: Makefile.common,v 1.37 2014/06/02 07:17:31 adam Exp $
 #
 # used by databases/mysql55-client/Makefile
 # used by databases/mysql55-server/Makefile
 
-DISTNAME=      mysql-5.5.37
+DISTNAME=      mysql-5.5.38
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_MYSQL:=MySQL-5.5/}
 
diff -r 7d15208988ca -r 103c83f4228b databases/mysql55-client/distinfo
--- a/databases/mysql55-client/distinfo Mon Jun 02 06:56:16 2014 +0000
+++ b/databases/mysql55-client/distinfo Mon Jun 02 07:17:31 2014 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.32 2014/03/31 08:03:22 adam Exp $
+$NetBSD: distinfo,v 1.33 2014/06/02 07:17:31 adam Exp $
 
-SHA1 (mysql-5.5.37.tar.gz) = b5f15ff72c86358693c250203e7cb9c20fbe5f7f
-RMD160 (mysql-5.5.37.tar.gz) = 1af56fc6d508a512fbac3372a0db50722b8c5f4e
-Size (mysql-5.5.37.tar.gz) = 21718944 bytes
+SHA1 (mysql-5.5.38.tar.gz) = 569c76385b24b981df35e703eefd34f9f76a2ee2
+RMD160 (mysql-5.5.38.tar.gz) = 57034b4b0642de0b08a4cf4e7e2641c775485e06
+Size (mysql-5.5.38.tar.gz) = 21739681 bytes
 SHA1 (patch-BUILD_compile-pentium-gcov) = a1ac666efa953a98455a726e5db359c903d699b6
 SHA1 (patch-CMakeLists.txt) = 632e036cd9578d0636328c2259a8529c36f2d14a
 SHA1 (patch-client_completion_hash.cc) = e27fd7072a8206380f0a932b1a31d2843c985cbf
diff -r 7d15208988ca -r 103c83f4228b databases/mysql55-server/PLIST
--- a/databases/mysql55-server/PLIST    Mon Jun 02 06:56:16 2014 +0000
+++ b/databases/mysql55-server/PLIST    Mon Jun 02 07:17:31 2014 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.28 2014/03/31 08:03:22 adam Exp $
+@comment $NetBSD: PLIST,v 1.29 2014/06/02 07:17:31 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -101,7 +101,6 @@
 share/mysql/russian/errmsg.sys
 share/mysql/serbian/errmsg.sys
 share/mysql/slovak/errmsg.sys
-share/mysql/solaris/postinstall-solaris
 share/mysql/spanish/errmsg.sys
 share/mysql/sql-bench/sql-bench/Data/ATIS/aircraft.txt
 share/mysql/sql-bench/sql-bench/Data/ATIS/airline.txt
@@ -1516,6 +1515,7 @@
 share/mysql/test/suite/binlog/r/binlog_switch_inside_trans.result
 share/mysql/test/suite/binlog/r/binlog_tmp_table.result
 share/mysql/test/suite/binlog/r/binlog_truncate_innodb.result
+share/mysql/test/suite/binlog/r/binlog_truncate_kill.result
 share/mysql/test/suite/binlog/r/binlog_truncate_myisam.result
 share/mysql/test/suite/binlog/r/binlog_unsafe.result
 share/mysql/test/suite/binlog/r/binlog_write_error.result
@@ -1608,6 +1608,7 @@
 share/mysql/test/suite/binlog/t/binlog_tmp_table.test
 share/mysql/test/suite/binlog/t/binlog_truncate_innodb-master.opt
 share/mysql/test/suite/binlog/t/binlog_truncate_innodb.test
+share/mysql/test/suite/binlog/t/binlog_truncate_kill.test
 share/mysql/test/suite/binlog/t/binlog_truncate_myisam.test
 share/mysql/test/suite/binlog/t/binlog_unsafe-master.opt
 share/mysql/test/suite/binlog/t/binlog_unsafe.test
@@ -4020,6 +4021,7 @@
 share/mysql/test/suite/rpl/r/rpl_row_colSize.result
 share/mysql/test/suite/rpl/r/rpl_row_conflicts.result
 share/mysql/test/suite/rpl/r/rpl_row_corruption.result
+share/mysql/test/suite/rpl/r/rpl_row_create_select.result
 share/mysql/test/suite/rpl/r/rpl_row_create_table.result
 share/mysql/test/suite/rpl/r/rpl_row_delayed_ins.result
 share/mysql/test/suite/rpl/r/rpl_row_drop.result
@@ -4398,6 +4400,7 @@
 share/mysql/test/suite/rpl/t/rpl_row_conflicts.test
 share/mysql/test/suite/rpl/t/rpl_row_corruption-slave.opt
 share/mysql/test/suite/rpl/t/rpl_row_corruption.test
+share/mysql/test/suite/rpl/t/rpl_row_create_select.test
 share/mysql/test/suite/rpl/t/rpl_row_create_table.test
 share/mysql/test/suite/rpl/t/rpl_row_delayed_ins.test
 share/mysql/test/suite/rpl/t/rpl_row_drop.test