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#54398 | Olav Sandstaa | 11 Nov |
