diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2019-08-29 16:07:15 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2019-08-30 12:02:40 +0300 |
| commit | a379f151b18e4bc7e4c26be5f5e1254a59e27bfa (patch) | |
| tree | da41fd103d7e90ab296c80cb6da15f0af5917adb /mysql-test/main/subselect_sj_jcl6.result | |
| parent | ef76f81c982bdbcfa4797ce26224db9c016ddebd (diff) | |
| download | mariadb-git-a379f151b18e4bc7e4c26be5f5e1254a59e27bfa.tar.gz | |
MDEV-20109: Optimizer ignores distinct key created for materialized...
Adjust the testcase according to the review input
Diffstat (limited to 'mysql-test/main/subselect_sj_jcl6.result')
| -rw-r--r-- | mysql-test/main/subselect_sj_jcl6.result | 2 |
1 files changed, 1 insertions, 1 deletions
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 |