[Commits] Rev 2940: Changed the test case for bug #53161 to make it independent on in file:///home/igor/maria/maria-5.1-bug53161/

igor at askmonty.org igor at askmonty.org
Sat Sep 25 19:00:21 EEST 2010


At file:///home/igor/maria/maria-5.1-bug53161/

------------------------------------------------------------
revno: 2940
revision-id: igor at askmonty.org-20100925160001-25ckxcja960cqs7f
parent: igor at askmonty.org-20100921042200-o52vwhnkz6kuwrcn
committer: Igor Babaev <igor at askmonty.org>
branch nick: maria-5.1-bug53161
timestamp: Sat 2010-09-25 09:00:01 -0700
message:
  Changed the test case for bug #53161 to make it independent on
  the setting of optimizer switch for table elimination.
-------------- next part --------------
=== modified file 'mysql-test/r/join_outer.result'
--- a/mysql-test/r/join_outer.result	2010-09-21 04:22:00 +0000
+++ b/mysql-test/r/join_outer.result	2010-09-25 16:00:01 +0000
@@ -1423,11 +1423,9 @@
 insert into t2 values (2000, 2), (2001, 2);
 insert into t3 values (3000, 3), (3001, 2);
 insert into t4 values (4000), (4001);
-set @save_optimizer_switch=@@optimizer_switch;
-set @@optimizer_switch='table_elimination=off';
 explain extended
 select t2.pk, 
-(select t3.pk 
+(select t3.pk+if(isnull(t4.pk),0,t4.pk) 
 from t3 left join t4 on t4.pk=t3.pk 
 where t3.pk=t2.pk+1000 limit 1 ) as t
 from t1,t2 
@@ -1440,9 +1438,9 @@
 2	DEPENDENT SUBQUERY	t4	eq_ref	PRIMARY	PRIMARY	4	test.t3.pk	1	100.00	Using where; Using index
 Warnings:
 Note	1276	Field or reference 'test.t2.pk' of SELECT #2 was resolved in SELECT #1
-Note	1003	select `test`.`t2`.`pk` AS `pk`,(select `test`.`t3`.`pk` from `test`.`t3` left join `test`.`t4` on((`test`.`t4`.`pk` = `test`.`t3`.`pk`)) where (`test`.`t3`.`pk` = (`test`.`t2`.`pk` + 1000)) limit 1) AS `t` from `test`.`t1` join `test`.`t2` where ((`test`.`t2`.`pk` = (`test`.`t1`.`pk` + 1000)) and (`test`.`t1`.`pk` > 1000)) group by `test`.`t2`.`pk`
+Note	1003	select `test`.`t2`.`pk` AS `pk`,(select (`test`.`t3`.`pk` + if(isnull(`test`.`t4`.`pk`),0,`test`.`t4`.`pk`)) from `test`.`t3` left join `test`.`t4` on((`test`.`t4`.`pk` = `test`.`t3`.`pk`)) where (`test`.`t3`.`pk` = (`test`.`t2`.`pk` + 1000)) limit 1) AS `t` from `test`.`t1` join `test`.`t2` where ((`test`.`t2`.`pk` = (`test`.`t1`.`pk` + 1000)) and (`test`.`t1`.`pk` > 1000)) group by `test`.`t2`.`pk`
 select t2.pk, 
-(select t3.pk 
+(select t3.pk+if(isnull(t4.pk),0,t4.pk)
 from t3 left join t4 on t4.pk=t3.pk 
 where t3.pk=t2.pk+1000 limit 1 ) as t
 from t1,t2 
@@ -1450,6 +1448,5 @@
 group by t2.pk;
 pk	t
 2001	3001
-set @@optimizer_switch=@save_optimizer_switch;
 drop table t1,t2,t3,t4;
 End of 5.1 tests

=== modified file 'mysql-test/t/join_outer.test'
--- a/mysql-test/t/join_outer.test	2010-09-21 04:22:00 +0000
+++ b/mysql-test/t/join_outer.test	2010-09-25 16:00:01 +0000
@@ -1010,12 +1010,9 @@
 insert into t3 values (3000, 3), (3001, 2);
 insert into t4 values (4000), (4001);
 
-set @save_optimizer_switch=@@optimizer_switch;
-set @@optimizer_switch='table_elimination=off';
-
 explain extended
 select t2.pk, 
-      (select t3.pk 
+      (select t3.pk+if(isnull(t4.pk),0,t4.pk) 
          from t3 left join t4 on t4.pk=t3.pk 
            where t3.pk=t2.pk+1000 limit 1 ) as t
   from t1,t2 
@@ -1023,15 +1020,13 @@
   group by t2.pk;
 
 select t2.pk, 
-      (select t3.pk 
+      (select t3.pk+if(isnull(t4.pk),0,t4.pk)
          from t3 left join t4 on t4.pk=t3.pk 
            where t3.pk=t2.pk+1000 limit 1 ) as t
   from t1,t2 
     where t2.pk=t1.pk+1000 and t1.pk>1000
   group by t2.pk;
 
-set @@optimizer_switch=@save_optimizer_switch;
-
 drop table t1,t2,t3,t4;
 
 --echo End of 5.1 tests



More information about the commits mailing list