List:Commits« Previous MessageNext Message »
From:Olav Sandstaa Date:November 10 2011 6:17pm
Subject:bzr push into mysql-trunk branch (olav.sandstaa:3592 to 3593) Bug#54398
View as plain text  
 3593 Olav Sandstaa	2011-11-10
      Follow-up patch for Bug#54398 Explain output for estimated number of
      rows varies between runs on InnoDB.
      
      Re-enable two test cases that was disabled due to variations in
      row estimates in explain output. The fix is to replace the row estimate
      column with a # pattern.
     @ mysql-test/include/mrr_tests.inc
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/include/subquery_sj_innodb.inc
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr_all.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr_cost.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr_cost_all.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr_cost_icp.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr_icp.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/innodb_mrr_none.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr_all.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr_cost.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr_cost_all.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr_cost_icp.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr_icp.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/myisam_mrr_none.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_all.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_all_bka.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_all_bka_nixbnl.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_all_bkaunique.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_none.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_none_bka.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_none_bka_nixbnl.result
        Re-enable test case that had been disabled due to Bug#54398.
     @ mysql-test/r/subquery_sj_innodb_none_bkaunique.result
        Re-enable test case that had been disabled due to Bug#54398.

    modified:
      mysql-test/include/mrr_tests.inc
      mysql-test/include/subquery_sj_innodb.inc
      mysql-test/r/innodb_mrr.result
      mysql-test/r/innodb_mrr_all.result
      mysql-test/r/innodb_mrr_cost.result
      mysql-test/r/innodb_mrr_cost_all.result
      mysql-test/r/innodb_mrr_cost_icp.result
      mysql-test/r/innodb_mrr_icp.result
      mysql-test/r/innodb_mrr_none.result
      mysql-test/r/myisam_mrr.result
      mysql-test/r/myisam_mrr_all.result
      mysql-test/r/myisam_mrr_cost.result
      mysql-test/r/myisam_mrr_cost_all.result
      mysql-test/r/myisam_mrr_cost_icp.result
      mysql-test/r/myisam_mrr_icp.result
      mysql-test/r/myisam_mrr_none.result
      mysql-test/r/subquery_sj_innodb_all.result
      mysql-test/r/subquery_sj_innodb_all_bka.result
      mysql-test/r/subquery_sj_innodb_all_bka_nixbnl.result
      mysql-test/r/subquery_sj_innodb_all_bkaunique.result
      mysql-test/r/subquery_sj_innodb_none.result
      mysql-test/r/subquery_sj_innodb_none_bka.result
      mysql-test/r/subquery_sj_innodb_none_bka_nixbnl.result
      mysql-test/r/subquery_sj_innodb_none_bkaunique.result
 3592 Marko Mäkelä	2011-11-10 [merge]
      Merge mysql-5.5 to mysql-trunk.

    modified:
      mysql-test/suite/innodb/r/innodb-lock.result
      mysql-test/suite/innodb/t/innodb-lock.test
=== modified file 'mysql-test/include/mrr_tests.inc'
--- a/mysql-test/include/mrr_tests.inc	2011-09-07 10:21:50 +0000
+++ b/mysql-test/include/mrr_tests.inc	2011-11-10 18:15:44 +0000
@@ -240,8 +240,8 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
                  filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
-## -- [DISABLED Bug#54398]
-#explain select * from t2 force index (d) where d < 10;
+--replace_column 9 #
+explain select * from t2 force index (d) where d < 10;
 drop table t2;
 
 drop table t1;

=== modified file 'mysql-test/include/subquery_sj_innodb.inc'
--- a/mysql-test/include/subquery_sj_innodb.inc	2011-01-24 11:56:54 +0000
+++ b/mysql-test/include/subquery_sj_innodb.inc	2011-11-10 18:15:44 +0000
@@ -55,8 +55,8 @@ insert into t3 select
   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;
 
-# -- [DISABLED Bug#54398]
-#explain select * from t3 where b in (select a from t0);
+--replace_column 9 #
+explain select * from t3 where b in (select a from t0);
 --sorted_result
 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/innodb_mrr.result'
--- a/mysql-test/r/innodb_mrr.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/innodb_mrr.result	2011-11-10 18:15:44 +0000
@@ -410,6 +410,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using where; Using MRR
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/innodb_mrr_all.result'
--- a/mysql-test/r/innodb_mrr_all.result	2011-10-05 13:16:38 +0000
+++ b/mysql-test/r/innodb_mrr_all.result	2011-11-10 18:15:44 +0000
@@ -410,6 +410,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition; Using MRR
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/innodb_mrr_cost.result'
--- a/mysql-test/r/innodb_mrr_cost.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/innodb_mrr_cost.result	2011-11-10 18:15:44 +0000
@@ -410,6 +410,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using where
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/innodb_mrr_cost_all.result'
--- a/mysql-test/r/innodb_mrr_cost_all.result	2011-10-05 13:16:38 +0000
+++ b/mysql-test/r/innodb_mrr_cost_all.result	2011-11-10 18:15:44 +0000
@@ -410,6 +410,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/innodb_mrr_cost_icp.result'
--- a/mysql-test/r/innodb_mrr_cost_icp.result	2011-10-05 13:16:38 +0000
+++ b/mysql-test/r/innodb_mrr_cost_icp.result	2011-11-10 18:15:44 +0000
@@ -410,6 +410,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/innodb_mrr_icp.result'
--- a/mysql-test/r/innodb_mrr_icp.result	2011-10-05 13:16:38 +0000
+++ b/mysql-test/r/innodb_mrr_icp.result	2011-11-10 18:15:44 +0000
@@ -410,6 +410,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition; Using MRR
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/innodb_mrr_none.result'
--- a/mysql-test/r/innodb_mrr_none.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/innodb_mrr_none.result	2011-11-10 18:15:44 +0000
@@ -409,6 +409,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using where
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr.result'
--- a/mysql-test/r/myisam_mrr.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr.result	2011-11-10 18:15:44 +0000
@@ -413,6 +413,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using where; Using MRR
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr_all.result'
--- a/mysql-test/r/myisam_mrr_all.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr_all.result	2011-11-10 18:15:44 +0000
@@ -413,6 +413,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition; Using MRR
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr_cost.result'
--- a/mysql-test/r/myisam_mrr_cost.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr_cost.result	2011-11-10 18:15:44 +0000
@@ -413,6 +413,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using where
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr_cost_all.result'
--- a/mysql-test/r/myisam_mrr_cost_all.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr_cost_all.result	2011-11-10 18:15:44 +0000
@@ -413,6 +413,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr_cost_icp.result'
--- a/mysql-test/r/myisam_mrr_cost_icp.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr_cost_icp.result	2011-11-10 18:15:44 +0000
@@ -413,6 +413,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr_icp.result'
--- a/mysql-test/r/myisam_mrr_icp.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr_icp.result	2011-11-10 18:15:44 +0000
@@ -413,6 +413,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using index condition; Using MRR
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/myisam_mrr_none.result'
--- a/mysql-test/r/myisam_mrr_none.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/myisam_mrr_none.result	2011-11-10 18:15:44 +0000
@@ -412,6 +412,9 @@ drop table t2;
 create table t2 (a char(100), b char(100), c char(100), d int, 
 filler char(10), key(d), primary key (a,b,c));
 insert into t2 select A.a, B.a, B.a, A.a, 'filler' from t1 A, t1 B;
+explain select * from t2 force index (d) where d < 10;
+id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+1	SIMPLE	t2	range	d	d	5	NULL	#	Using where
 drop table t2;
 drop table t1;
 set @@read_rnd_buffer_size= @read_rnd_buffer_size_save;

=== modified file 'mysql-test/r/subquery_sj_innodb_all.result'
--- a/mysql-test/r/subquery_sj_innodb_all.result	2011-03-17 11:23:06 +0000
+++ b/mysql-test/r/subquery_sj_innodb_all.result	2011-11-10 18:15:44 +0000
@@ -70,6 +70,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	t0	ALL	NULL	NULL	NULL	NULL	#	Using where; Start temporary
+1	PRIMARY	t3	ref	b	b	5	test.t0.a	#	End temporary
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_all_bka.result'
--- a/mysql-test/r/subquery_sj_innodb_all_bka.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/subquery_sj_innodb_all_bka.result	2011-11-10 18:15:44 +0000
@@ -71,6 +71,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	t0	ALL	NULL	NULL	NULL	NULL	#	Using where; Start temporary
+1	PRIMARY	t3	ref	b	b	5	test.t0.a	#	End temporary; Using join buffer (Batched Key Access)
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_all_bka_nixbnl.result'
--- a/mysql-test/r/subquery_sj_innodb_all_bka_nixbnl.result	2011-10-05 13:16:38 +0000
+++ b/mysql-test/r/subquery_sj_innodb_all_bka_nixbnl.result	2011-11-10 18:15:44 +0000
@@ -71,6 +71,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	t0	ALL	NULL	NULL	NULL	NULL	#	Using where; Start temporary
+1	PRIMARY	t3	ref	b	b	5	test.t0.a	#	End temporary; Using join buffer (Batched Key Access)
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_all_bkaunique.result'
--- a/mysql-test/r/subquery_sj_innodb_all_bkaunique.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/subquery_sj_innodb_all_bkaunique.result	2011-11-10 18:15:44 +0000
@@ -72,6 +72,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	t0	ALL	NULL	NULL	NULL	NULL	#	Using where; Start temporary
+1	PRIMARY	t3	ref	b	b	5	test.t0.a	#	End temporary; Using join buffer (Batched Key Access (unique))
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_none.result'
--- a/mysql-test/r/subquery_sj_innodb_none.result	2011-06-24 12:53:57 +0000
+++ b/mysql-test/r/subquery_sj_innodb_none.result	2011-11-10 18:15:44 +0000
@@ -69,6 +69,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	NULL	NULL	NULL	NULL	#	Using where
+2	DEPENDENT SUBQUERY	t0	ALL	NULL	NULL	NULL	NULL	#	Using where
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_none_bka.result'
--- a/mysql-test/r/subquery_sj_innodb_none_bka.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/subquery_sj_innodb_none_bka.result	2011-11-10 18:15:44 +0000
@@ -70,6 +70,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	NULL	NULL	NULL	NULL	#	Using where
+2	DEPENDENT SUBQUERY	t0	ALL	NULL	NULL	NULL	NULL	#	Using where
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_none_bka_nixbnl.result'
--- a/mysql-test/r/subquery_sj_innodb_none_bka_nixbnl.result	2011-10-05 13:16:38 +0000
+++ b/mysql-test/r/subquery_sj_innodb_none_bka_nixbnl.result	2011-11-10 18:15:44 +0000
@@ -70,6 +70,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	NULL	NULL	NULL	NULL	#	Using where
+2	DEPENDENT SUBQUERY	t0	ALL	NULL	NULL	NULL	NULL	#	Using where
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

=== modified file 'mysql-test/r/subquery_sj_innodb_none_bkaunique.result'
--- a/mysql-test/r/subquery_sj_innodb_none_bkaunique.result	2011-09-07 10:21:50 +0000
+++ b/mysql-test/r/subquery_sj_innodb_none_bkaunique.result	2011-11-10 18:15:44 +0000
@@ -71,6 +71,10 @@ primary key(pk1, pk2)
 insert into t3 select 
 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;
+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	NULL	NULL	NULL	NULL	#	Using where
+2	DEPENDENT SUBQUERY	t0	ALL	NULL	NULL	NULL	NULL	#	Using where
 select * from t3 where b in (select A.a+B.a from t0 A, t0 B where B.a<5);
 a	b	pk1	pk2
 0	0	0	0

No bundle (reason: useless for push emails).
Thread
bzr push into mysql-trunk branch (olav.sandstaa:3592 to 3593) Bug#54398Olav Sandstaa11 Nov