[Commits] Rev 3493: Make test results stable. in file:///home/psergey/dev2/5.3-look4/

Sergey Petrunya psergey at askmonty.org
Wed Apr 4 20:35:37 EEST 2012


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

------------------------------------------------------------
revno: 3493
revision-id: psergey at askmonty.org-20120404173534-e7ve3vnmxivod6sk
parent: monty at askmonty.org-20120404111946-mccdwx348niqo4ki
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.3-look4
timestamp: Wed 2012-04-04 21:35:34 +0400
message:
  Make test results stable.
=== modified file 'mysql-test/r/subselect_sj2.result'
--- a/mysql-test/r/subselect_sj2.result	2012-04-02 17:41:54 +0000
+++ b/mysql-test/r/subselect_sj2.result	2012-04-04 17:35:34 +0000
@@ -95,9 +95,9 @@
 from t0 A, t0 B where B.a <5;
 explain select * from t3 where b in (select a from t0);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	PRIMARY	t3	ALL	b	NULL	NULL	NULL	56	
-1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1	
-2	MATERIALIZED	t0	ALL	NULL	NULL	NULL	NULL	10	
+1	PRIMARY	t3	ALL	b	NULL	NULL	NULL	#	
+1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	#	
+2	MATERIALIZED	t0	ALL	NULL	NULL	NULL	NULL	#	
 set @save_ecp= @@engine_condition_pushdown;
 set engine_condition_pushdown=0;
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);

=== modified file 'mysql-test/r/subselect_sj2_jcl6.result'
--- a/mysql-test/r/subselect_sj2_jcl6.result	2012-04-02 17:41:54 +0000
+++ b/mysql-test/r/subselect_sj2_jcl6.result	2012-04-04 17:35:34 +0000
@@ -106,9 +106,9 @@
 from t0 A, t0 B where B.a <5;
 explain select * from t3 where b in (select a from t0);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	PRIMARY	t3	ALL	b	NULL	NULL	NULL	56	
-1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1	
-2	MATERIALIZED	t0	ALL	NULL	NULL	NULL	NULL	10	
+1	PRIMARY	t3	ALL	b	NULL	NULL	NULL	#	
+1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	#	
+2	MATERIALIZED	t0	ALL	NULL	NULL	NULL	NULL	#	
 set @save_ecp= @@engine_condition_pushdown;
 set engine_condition_pushdown=0;
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);

=== modified file 'mysql-test/r/subselect_sj2_mat.result'
--- a/mysql-test/r/subselect_sj2_mat.result	2012-04-02 17:41:54 +0000
+++ b/mysql-test/r/subselect_sj2_mat.result	2012-04-04 17:35:34 +0000
@@ -97,9 +97,9 @@
 from t0 A, t0 B where B.a <5;
 explain select * from t3 where b in (select a from t0);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	PRIMARY	t3	ALL	b	NULL	NULL	NULL	46	
-1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	1	
-2	MATERIALIZED	t0	ALL	NULL	NULL	NULL	NULL	10	
+1	PRIMARY	t3	ALL	b	NULL	NULL	NULL	#	
+1	PRIMARY	<subquery2>	eq_ref	distinct_key	distinct_key	4	func	#	
+2	MATERIALIZED	t0	ALL	NULL	NULL	NULL	NULL	#	
 set @save_ecp= @@engine_condition_pushdown;
 set engine_condition_pushdown=0;
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);

=== modified file 'mysql-test/t/subselect_sj2.test'
--- a/mysql-test/t/subselect_sj2.test	2012-03-27 10:43:26 +0000
+++ b/mysql-test/t/subselect_sj2.test	2012-04-04 17:35:34 +0000
@@ -78,6 +78,7 @@
   A.a + 10*B.a, A.a + 10*B.a, A.a + 10*B.a, A.a + 10*B.a 
 from t0 A, t0 B where B.a <5;
 
+--replace_column 9 #
 explain select * from t3 where b in (select a from t0);
 # Because of BUG#40154, run the next select w/o index condition pushdown:
 set @save_ecp= @@engine_condition_pushdown;



More information about the commits mailing list