Merge lp:~percona-dev/percona-server/5.5.8-fix-warning-in-query_response_time-tests into lp:~percona-dev/percona-server/5.5.8

[Oleg Tsarev]

Fix warnings on replication and query_response_time tests:

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.percona_query_response_time-replication [ fail ] Found warnings/errors in server log file!
        Test ended at 2011-02-08 20:05:09
line
110208 21:05:07 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement: INSERT INTO t SELECT SLEEP(0.4)
110208 21:05:08 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement: INSERT INTO t SELECT SLEEP(0.4)
110208 21:05:09 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement: INSERT INTO t SELECT SLEEP(0.4)
110208 21:05:09 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement: INSERT INTO t SELECT SLEEP(0.4)
^ Found warnings in /storage/project/percona/08-Feb-2011/5.5.8/Percona-Server-debug/mysql-test/var/log/mysqld.2.err
ok

[Oleg Tsarev (tsarev)]

Nothing changed for documentation

[Alexey Kopytov (akopytov)]

http://dev.mysql.com/doc/mysqltest/2.0/en/writing-tests-warning-supp.html

[Oleg Tsarev (tsarev)]

Alexey, fixed how described.

[Alexey Kopytov (akopytov)]

Can you merge both revisions into a single one?

review: Needs Fixing

[Alexey Kopytov (akopytov)]

Does it require a RN entry? This is a fix for a failing test, looks like user-visible change to me.

[Alexey Kopytov (akopytov)]

review: Approve

=== modified file 'mysql-test/response-time-distribution.patch/percona_query_response_time-replication.test'
--- mysql-test/response-time-distribution.patch/percona_query_response_time-replication.test	2011-01-17 01:49:51 +0000
+++ mysql-test/response-time-distribution.patch/percona_query_response_time-replication.test	2011-02-09 12:36:46 +0000
@@ -2,6 +2,9 @@
 --source include/master-slave.inc
 --source include/have_binlog_format_statement.inc
 --source include/have_debug.inc
+--disable_query_log
+call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. Statement:")
+--enable_query_log
 SET SESSION debug="+d,response_time_distribution_log_only_more_300_milliseconds";
 
 connection master;