bzr commit into mysql-6.0-codebase-bugfixing branch (epotemkin:3707) Bug#45191

[Evgeny Potemkin]

#At file:///work/bzrroot/mysql-6.0-codebase-bugfixing/ based on revid:alik@stripped

 3707 Evgeny Potemkin	2009-11-12
      Test cases results corrected after fixing bug#45191.

    modified:
      mysql-test/r/subselect_sj2.result
      mysql-test/r/subselect_sj2_jcl6.result
=== modified file 'mysql-test/r/subselect_sj2.result'
--- a/mysql-test/r/subselect_sj2.result	2009-10-22 10:45:44 +0000
+++ b/mysql-test/r/subselect_sj2.result	2009-11-12 14:31:12 +0000
@@ -702,6 +702,6 @@ c1 in (select convert(c6,char(1)) from t
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where
 1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	
-1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where; Using join buffer
-1	PRIMARY	t3	ALL	NULL	NULL	NULL	NULL	2	FirstMatch(t2); Using join buffer
+1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where
+1	PRIMARY	t3	ALL	NULL	NULL	NULL	NULL	2	FirstMatch(t2)
 drop table t2, t3;

=== modified file 'mysql-test/r/subselect_sj2_jcl6.result'
--- a/mysql-test/r/subselect_sj2_jcl6.result	2009-10-22 10:45:44 +0000
+++ b/mysql-test/r/subselect_sj2_jcl6.result	2009-11-12 14:31:12 +0000
@@ -705,9 +705,9 @@ c2 in (select 1 from t3, t2) and
 c1 in (select convert(c6,char(1)) from t2);
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where
-1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using join buffer
-1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where; Using join buffer
-1	PRIMARY	t3	ALL	NULL	NULL	NULL	NULL	2	FirstMatch(t2); Using join buffer
+1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	
+1	PRIMARY	t2	ALL	NULL	NULL	NULL	NULL	1	Using where
+1	PRIMARY	t3	ALL	NULL	NULL	NULL	NULL	2	FirstMatch(t2)
 drop table t2, t3;
 set join_cache_level=default;
 show variables like 'join_cache_level';


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