bzr commit into mysql-next-mr-bugfixing branch (marc.alff:3162) Bug#53394

[Marc Alff]

#At file:///Users/malff/BZR_TREE/mysql-next-mr-bugfixing-53394/ based on revid:marc.alff@stripped

 3162 Marc Alff	2010-05-04
      Bug#53394 Tests: perfschema.myisam_file_io fails
      
      Before this fix, the test perfschema.myisam_file_io could fail
      with spurious failures, depending on which test was executed in the same
      MTR run.
      
      With this fix, the test perfschema.myisam_file_io resets the server
      status variables, to be independent of previous runs.
      
      In particular, performance_schema_*_lost now have a predictable value.

    modified:
      mysql-test/suite/perfschema/r/myisam_file_io.result
      mysql-test/suite/perfschema/t/myisam_file_io.test
=== modified file 'mysql-test/suite/perfschema/r/myisam_file_io.result'
--- a/mysql-test/suite/perfschema/r/myisam_file_io.result	2010-01-12 01:47:27 +0000
+++ b/mysql-test/suite/perfschema/r/myisam_file_io.result	2010-05-04 07:44:57 +0000
@@ -4,6 +4,7 @@ update performance_schema.SETUP_INSTRUME
 update performance_schema.SETUP_CONSUMERS
 set enabled='YES';
 truncate table performance_schema.EVENTS_WAITS_HISTORY_LONG;
+flush status;
 drop table if exists test.no_index_tab;
 create table test.no_index_tab ( a varchar(255), b int ) engine=myisam;
 insert into no_index_tab set a = 'foo', b = 1;

=== modified file 'mysql-test/suite/perfschema/t/myisam_file_io.test'
--- a/mysql-test/suite/perfschema/t/myisam_file_io.test	2010-05-04 06:53:22 +0000
+++ b/mysql-test/suite/perfschema/t/myisam_file_io.test	2010-05-04 07:44:57 +0000
@@ -29,6 +29,9 @@ update performance_schema.SETUP_CONSUMER
 
 truncate table performance_schema.EVENTS_WAITS_HISTORY_LONG;
 
+# Reset lost counters to a known state
+flush status;
+
 # Code to test
 
 --disable_warnings


Attachment: [text/bzr-bundle] bzr/[e-mail]