diff options
| -rw-r--r-- | mysql-test/main/subselect_sj.result | 2 | ||||
| -rw-r--r-- | mysql-test/main/subselect_sj.test | 2 | ||||
| -rw-r--r-- | mysql-test/main/subselect_sj_jcl6.result | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/subselect_sj.result b/mysql-test/main/subselect_sj.result index a7cca9d4831..246330db7d5 100644 --- a/mysql-test/main/subselect_sj.result +++ b/mysql-test/main/subselect_sj.result @@ -3273,7 +3273,7 @@ insert into t4 select floor(rand()*1000) from t2 limit 500; # | 1 | PRIMARY | t3 | ALL | NULL | ... | 10000 | Using where; Using join buffer (flat, BNL join) | # # Instead, it should use eq_ref on the materialized table. -explain select * from t3 where a in (select a from t4 group by a); +explain select * from t3 where a in (select a from t4); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t3 ALL NULL NULL NULL NULL 10000 1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func 1 diff --git a/mysql-test/main/subselect_sj.test b/mysql-test/main/subselect_sj.test index d5a55026f25..cade91c6f44 100644 --- a/mysql-test/main/subselect_sj.test +++ b/mysql-test/main/subselect_sj.test @@ -2959,7 +2959,7 @@ insert into t4 select floor(rand()*1000) from t2 limit 500; --echo # --echo # Instead, it should use eq_ref on the materialized table. -explain select * from t3 where a in (select a from t4 group by a); +explain select * from t3 where a in (select a from t4); drop table t1, t2, t3, t4; diff --git a/mysql-test/main/subselect_sj_jcl6.result b/mysql-test/main/subselect_sj_jcl6.result index 72dd5590e07..91079aacb3d 100644 --- a/mysql-test/main/subselect_sj_jcl6.result +++ b/mysql-test/main/subselect_sj_jcl6.result @@ -3286,7 +3286,7 @@ insert into t4 select floor(rand()*1000) from t2 limit 500; # | 1 | PRIMARY | t3 | ALL | NULL | ... | 10000 | Using where; Using join buffer (flat, BNL join) | # # Instead, it should use eq_ref on the materialized table. -explain select * from t3 where a in (select a from t4 group by a); +explain select * from t3 where a in (select a from t4); id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY t3 ALL NULL NULL NULL NULL 10000 1 PRIMARY <subquery2> eq_ref distinct_key distinct_key 4 func 1 |