Changes 5.6.25:

Functionality Added or Changed
* MySQL Enterprise Firewall operates on parser states and does not work well together with the query cache, which circumvents the parser. MySQL Enterprise Firewall now checks whether the query cache is enabled. If so, it displays a message that the query cache must be disabled and does not load.

* my_print_defaults now masks passwords. To display passwords in cleartext, use the new --show option.

* MySQL distributions now include an innodb_stress suite of test cases. Thanks to Mark Callaghan for the contribution.

Bugs Fixed
* InnoDB; Partitioning: The CREATE_TIME column of the INFORMATION_SCHEMA.TABLES table now shows the correct table creation time for partitioned InnoDB tables. The CREATE_TIME column of the INFORMATION_SCHEMA.PARTITIONS table now shows the correct partition creation time for a partition of partitioned InnoDB tables.

The UPDATE_TIME column of the INFORMATION_SCHEMA.TABLES table now shows when a partitioned InnoDB table was last updated by an INSERT, DELETE, or UPDATE. The UPDATE_TIME column of the INFORMATION_SCHEMA.PARTITIONS table now shows when a partition of a partitioned InnoDB table was last updated.

* InnoDB: An assertion was raised on shutdown due to XA PREPARE transactions holding explicit locks.

* InnoDB: The strict_* forms of innodb_checksum_algorithm settings (strict_none, strict_innodb, and strict_crc32) caused the server to halt when a non-matching checksum was encountered, even though the non-matching checksum was valid. For example, with innodb_checksum_algorithm=strict_crc32, encountering a valid innodb checksum caused the server to halt. Instead of halting the server, a message is now printed to the error log and the page is accepted as valid if it matches an innodb, crc32 or none checksum.

* InnoDB: The memcached set command permitted a negative expire time value. Expire time is stored internally as an unsigned integer. A negative value would be converted to a large number and accepted. The maximum expire time value is now restricted to INT_MAX32 to prevent negative expire time values.

* InnoDB: Removal of a foreign key object from the data dictionary cache during error handling caused the server to exit.

* InnoDB: SHOW ENGINE INNODB STATUS output showed negative reservation and signal count values due to a counter overflow error.

* InnoDB: Failure to check the status of a cursor transaction read-only option before reusing the cursor transaction for a write operation resulted in a server exit during a memcached workload.

* InnoDB: MDL locks taken by memcached clients caused a MySQL Enterprise Backup FLUSH TABLES WITH READ LOCK operation to hang.

* InnoDB: Estimates that were too low for the size of merge chunks in the result sorting algorithm caused a server exit.

* InnoDB: For full-text searches, the optimizer could choose an index that does not produce correct relevancy rankings.

* Partitioning: When creating a partitioned table, partition-level DATA DIRECTORY or INDEX DIRECTORY option values that contained an excessive number of characters were handled incorrectly.

* Partitioning: Executing an ALTER TABLE on a partitioned table on which a write lock was in effect could cause subsequent SQL statements on this table to fail.

* Replication: When binary logging was enabled, using stored functions and triggers resulting in a long running procedure that inserted many records caused the memory use to increase rapidly. This was due to memory being allocated per variable. The fix ensures that in such a situation, memory is allocated once and the same memory is reused.

* Replication: If an error was encountered while adding a GTID to the received GTID set, the log lock was not being correctly released. This could cause a deadlock.

more...

1 files changed, 116 insertions, 2 deletions

diff --git a/databases/mysql56-server/PLIST b/databases/mysql56-server/PLIST
index b8202290d63..097f6bf3c16 100644
--- a/databases/mysql56-server/PLIST
+++ b/databases/mysql56-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.16 2015/04/08 10:38:48 adam Exp $
+@comment $NetBSD: PLIST,v 1.17 2015/06/01 08:15:05 adam Exp $
 bin/innochecksum
 bin/my_print_defaults
 bin/myisam_ftdump
@@ -333,6 +333,7 @@ share/mysql/test/include/analyze-sync_with_master.test
 share/mysql/test/include/analyze-timeout.test
 share/mysql/test/include/assert.inc
 share/mysql/test/include/assert_command_output.inc
+share/mysql/test/include/assert_grep.inc
 share/mysql/test/include/begin_include_file.inc
 share/mysql/test/include/big_test.inc
 share/mysql/test/include/binlog_inject_error.inc
@@ -590,6 +591,7 @@ share/mysql/test/include/ndb_restore_master.inc
 share/mysql/test/include/ndb_restore_slave_eoption.inc
 share/mysql/test/include/ndb_setup_slave.inc
 share/mysql/test/include/ndb_wait_connected.inc
+share/mysql/test/include/no_protocol.inc
 share/mysql/test/include/no_running_event_scheduler.inc
 share/mysql/test/include/no_running_events.inc
 share/mysql/test/include/no_valgrind_without_big.inc
@@ -756,6 +758,7 @@ share/mysql/test/include/wait_for_slave_sql_to_start.inc
 share/mysql/test/include/wait_for_slave_sql_to_stop.inc
 share/mysql/test/include/wait_for_slave_to_start.inc
 share/mysql/test/include/wait_for_slave_to_stop.inc
+share/mysql/test/include/wait_for_slave_to_sync_with_master.inc
 share/mysql/test/include/wait_for_status_var.inc
 share/mysql/test/include/wait_innodb_all_purged.inc
 share/mysql/test/include/wait_show_condition.inc
@@ -1221,6 +1224,7 @@ share/mysql/test/r/lock_multi_bug38499.result
 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_empty_name.result
 share/mysql/test/r/log_errchk.result
 share/mysql/test/r/log_state.result
 share/mysql/test/r/log_state_bug33693.result
@@ -3595,7 +3599,9 @@ share/mysql/test/suite/innodb/r/insert_debug.result
 share/mysql/test/suite/innodb/r/monitor.result
 share/mysql/test/suite/innodb/r/monitor_debug.result
 share/mysql/test/suite/innodb/r/sp_temp_table.result
+share/mysql/test/suite/innodb/r/strict_checksum.result
 share/mysql/test/suite/innodb/r/strict_mode.result
+share/mysql/test/suite/innodb/r/xa_recovery.result
 share/mysql/test/suite/innodb/t/add_foreign_key.test
 share/mysql/test/suite/innodb/t/blob-update-debug.test
 share/mysql/test/suite/innodb/t/blob_redo-master.opt
@@ -3811,7 +3817,9 @@ share/mysql/test/suite/innodb/t/monitor_debug.test
 share/mysql/test/suite/innodb/t/portability_wl5980_linux.zip
 share/mysql/test/suite/innodb/t/portability_wl5980_windows.zip
 share/mysql/test/suite/innodb/t/sp_temp_table.test
+share/mysql/test/suite/innodb/t/strict_checksum.test
 share/mysql/test/suite/innodb/t/strict_mode.test
+share/mysql/test/suite/innodb/t/xa_recovery.test
 share/mysql/test/suite/innodb_fts/r/fts_compatibility.result
 share/mysql/test/suite/innodb_fts/r/fts_compatibility_win.result
 share/mysql/test/suite/innodb_fts/r/fulltext.result
@@ -3880,6 +3888,105 @@ share/mysql/test/suite/innodb_fts/t/innodb_fts_stopword_charset.test
 share/mysql/test/suite/innodb_fts/t/innodb_fts_transaction.test
 share/mysql/test/suite/innodb_fts/t/phrase.test
 share/mysql/test/suite/innodb_fts/t/subexpr.test
+share/mysql/test/suite/innodb_stress/include/innodb_stress.inc
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_blob.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_blob_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_crash.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_crash_blob.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_crash_blob_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_crash_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_bigstress_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_blob.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_blob_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_crash.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_crash_blob.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_crash_blob_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_crash_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_hugestress_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_blob.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_blob_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_crash.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_crash_blob.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_crash_blob_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_crash_nocompress.result
+share/mysql/test/suite/innodb_stress/r/innodb_stress_nocompress.result
+share/mysql/test/suite/innodb_stress/t/Readme
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_blob-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_blob-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_blob.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_blob_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_blob_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_blob_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_blob-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_blob-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_blob.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_blob_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_blob_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_blob_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_crash_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_bigstress_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_blob-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_blob-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_blob.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_blob_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_blob_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_blob_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_blob-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_blob-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_blob.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_blob_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_blob_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_blob_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_crash_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_hugestress_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_blob-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_blob-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_blob.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_blob_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_blob_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_blob_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_blob-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_blob-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_blob.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_blob_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_blob_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_blob_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_crash_nocompress.test
+share/mysql/test/suite/innodb_stress/t/innodb_stress_nocompress-master.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_nocompress-slave.opt
+share/mysql/test/suite/innodb_stress/t/innodb_stress_nocompress.test
+share/mysql/test/suite/innodb_stress/t/load_generator.py
 share/mysql/test/suite/innodb_zip/include/innodb_create_tab_indx.inc
 share/mysql/test/suite/innodb_zip/include/innodb_fetch_records.inc
 share/mysql/test/suite/innodb_zip/include/innodb_load_data.inc
@@ -5282,7 +5389,6 @@ share/mysql/test/suite/perfschema/include/event_aggregate_setup.inc
 share/mysql/test/suite/perfschema/include/have_aligned_memory.inc
 share/mysql/test/suite/perfschema/include/hostcache_dump.inc
 share/mysql/test/suite/perfschema/include/hostcache_set_state.inc
-share/mysql/test/suite/perfschema/include/no_protocol.inc
 share/mysql/test/suite/perfschema/include/privilege.inc
 share/mysql/test/suite/perfschema/include/rpl_statements_truncate.inc
 share/mysql/test/suite/perfschema/include/schema.inc
@@ -6195,9 +6301,12 @@ share/mysql/test/suite/rpl/r/rpl_gtid_ignore_table_filter_insensitive.result
 share/mysql/test/suite/rpl/r/rpl_gtid_ignore_table_filter_sensitive.result
 share/mysql/test/suite/rpl/r/rpl_gtid_loaddata_s.result
 share/mysql/test/suite/rpl/r/rpl_gtid_mode.result
+share/mysql/test/suite/rpl/r/rpl_gtid_mode_off_new_master.result
+share/mysql/test/suite/rpl/r/rpl_gtid_mode_on_new_master.result
 share/mysql/test/suite/rpl/r/rpl_gtid_parallel.result
 share/mysql/test/suite/rpl/r/rpl_gtid_purged_fail_to_connect.result
 share/mysql/test/suite/rpl/r/rpl_gtid_purged_maintained.result
+share/mysql/test/suite/rpl/r/rpl_gtid_replay_relaylog.result
 share/mysql/test/suite/rpl/r/rpl_gtid_row_event_max_size.result
 share/mysql/test/suite/rpl/r/rpl_gtid_row_show_relaylog_events.result
 share/mysql/test/suite/rpl/r/rpl_gtid_server_sighup.result
@@ -6701,11 +6810,14 @@ share/mysql/test/suite/rpl/t/rpl_gtid_ignore_table_filter_sensitive.test
 share/mysql/test/suite/rpl/t/rpl_gtid_loaddata_s-slave.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_loaddata_s.test
 share/mysql/test/suite/rpl/t/rpl_gtid_mode.test
+share/mysql/test/suite/rpl/t/rpl_gtid_mode_off_new_master.test
+share/mysql/test/suite/rpl/t/rpl_gtid_mode_on_new_master.test
 share/mysql/test/suite/rpl/t/rpl_gtid_parallel.test
 share/mysql/test/suite/rpl/t/rpl_gtid_purged_fail_to_connect-master.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_purged_fail_to_connect-slave.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_purged_fail_to_connect.test
 share/mysql/test/suite/rpl/t/rpl_gtid_purged_maintained.test
+share/mysql/test/suite/rpl/t/rpl_gtid_replay_relaylog.test
 share/mysql/test/suite/rpl/t/rpl_gtid_row_event_max_size-master.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_row_event_max_size-slave.opt
 share/mysql/test/suite/rpl/t/rpl_gtid_row_event_max_size.test
@@ -8982,6 +9094,8 @@ share/mysql/test/t/lock_sync-master.opt
 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_empty_name.opt
+share/mysql/test/t/log_empty_name.test
 share/mysql/test/t/log_errchk.test
 share/mysql/test/t/log_state-master.opt
 share/mysql/test/t/log_state.test