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;

1 files changed, 5 insertions, 2 deletions

diff --git a/databases/mysql55-server/PLIST b/databases/mysql55-server/PLIST
index d000e8f8078..055e70ee5cf 100644
--- a/databases/mysql55-server/PLIST
+++ b/databases/mysql55-server/PLIST
@@ -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/romanian/errmsg.sys
 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_stm_user_variables.result
 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_switch_inside_trans.test
 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_blob_myisam.result
 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_colSize.test
 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