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

[Marc Alff]

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

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

    modified:
      mysql-test/suite/perfschema/r/query_cache.result
      mysql-test/suite/perfschema/t/query_cache.test
=== modified file 'mysql-test/suite/perfschema/r/query_cache.result'
--- a/mysql-test/suite/perfschema/r/query_cache.result	2010-01-12 01:47:27 +0000
+++ b/mysql-test/suite/perfschema/r/query_cache.result	2010-05-04 07:44:13 +0000
@@ -4,6 +4,7 @@ insert into t1 values (1), (2), (3);
 SET GLOBAL query_cache_size=1355776;
 flush query cache;
 reset query cache;
+flush status;
 select * from t1;
 a
 1

=== modified file 'mysql-test/suite/perfschema/t/query_cache.test'
--- a/mysql-test/suite/perfschema/t/query_cache.test	2010-05-04 06:53:22 +0000
+++ b/mysql-test/suite/perfschema/t/query_cache.test	2010-05-04 07:44:13 +0000
@@ -33,6 +33,8 @@ SET GLOBAL query_cache_size=1355776;
 
 flush query cache;
 reset query cache;
+# Reset Qcache_* to a known state
+flush status;
 
 select * from t1;
 


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