bzr commit into mysql-6.0-bka-preview branch (sergefp:2658) Bug#40118

[Sergey Petrunia]

#At file:///home/spetrunia/dev/mysql-6.0-bka-preview-merge2/

 2658 Sergey Petrunia	2008-10-16
      Fix testcase for BUG#40118
modified:
  mysql-test/r/subselect3.result
  mysql-test/t/subselect3.test

per-file messages:
  mysql-test/r/subselect3.result
    Fix testcase for BUG#40118
  mysql-test/t/subselect3.test
    Fix testcase for BUG#40118
=== modified file 'mysql-test/r/subselect3.result'
--- a/mysql-test/r/subselect3.result	2008-10-15 22:06:36 +0000
+++ b/mysql-test/r/subselect3.result	2008-10-16 04:31:09 +0000
@@ -827,17 +827,17 @@ insert into t1 select * from t1;
 insert into t1 select * from t1;
 set @save_join_cache_level=@@join_cache_level;
 set join_cache_level=6;
-select * from t0 left join t1 on t0.a=t1.a where t1.b is null;
-a	a	b	filler
-0	0	0	NULL
-1	1	0	NULL
-2	2	0	NULL
-3	3	0	NULL
-4	4	0	NULL
-5	5	0	NULL
-6	6	0	NULL
-7	7	0	NULL
-8	8	0	NULL
-9	9	0	NULL
+select * from t0 where t0.a in (select t1.a from t1 where t1.b=0);
+a
+0
+1
+2
+3
+4
+5
+6
+7
+8
+9
 set join_cache_level=@save_join_cache_level;
 drop table t0, t1;

=== modified file 'mysql-test/t/subselect3.test'
--- a/mysql-test/t/subselect3.test	2008-10-15 22:06:36 +0000
+++ b/mysql-test/t/subselect3.test	2008-10-16 04:31:09 +0000
@@ -684,8 +684,7 @@ insert into t1 select * from t1;
 
 set @save_join_cache_level=@@join_cache_level;
 set join_cache_level=6;
-select * from t0 left join t1 on t0.a=t1.a where t1.b is null; 
-
+select * from t0 where t0.a in (select t1.a from t1 where t1.b=0); 
 set join_cache_level=@save_join_cache_level;
 drop table t0, t1;