[Commits] Rev 3398: Make testcase stable by adding --sorted_result for SHOW STATUS commands. in file:///home/psergey/dev2/5.3-look48/

Sergey Petrunya psergey at askmonty.org
Fri Jan 27 15:51:41 EET 2012


At file:///home/psergey/dev2/5.3-look48/

------------------------------------------------------------
revno: 3398
revision-id: psergey at askmonty.org-20120127135140-4ues2tk6juf4iynx
parent: psergey at askmonty.org-20120126102034-tp33uzyuqnyk30mn
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.3-look48
timestamp: Fri 2012-01-27 17:51:40 +0400
message:
  Make testcase stable by adding --sorted_result for SHOW STATUS commands.
=== modified file 'mysql-test/t/myisam_mrr.test'
--- a/mysql-test/t/myisam_mrr.test	2012-01-25 14:27:34 +0000
+++ b/mysql-test/t/myisam_mrr.test	2012-01-27 13:51:40 +0000
@@ -272,6 +272,7 @@
 --echo # Test of MRR handler counters
 --echo #
 flush status;
+--sorted_result
 show status like 'Handler_mrr%';
 create table t0 (a int);
 insert into t0 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
@@ -283,6 +284,7 @@
 --echo # This should show one MRR scan and no re-fills:
 flush status;
 select sum(b) from t1 where a < 10;
+--sorted_result
 show status like 'handler_mrr%';
 
 set @mrr_buffer_size_save= @@mrr_buffer_size;
@@ -294,6 +296,7 @@
 --echo # This should show one MRR scan and one extra rowid sort:
 flush status;
 select sum(b) from t1 where a < 1600;
+--sorted_result
 show status like 'handler_mrr%';
 set @@mrr_buffer_size= @mrr_buffer_size_save;
 
@@ -305,6 +308,7 @@
 explain select sum(t1.b) from t0,t1 where t0.a=t1.a;
 flush status;
 select sum(t1.b) from t0,t1 where t0.a=t1.a;
+--sorted_result
 show status like 'handler_mrr%';
 
 --disable_warnings
@@ -313,6 +317,7 @@
 explain select sum(t1.b) from t0,t1 where t0.a=t1.a;
 flush status;
 select sum(t1.b) from t0,t1 where t0.a=t1.a;
+--sorted_result
 --replace_result 1 1or2 2 1or2
 show status like 'handler_mrr%';
 



More information about the commits mailing list