diff options
Diffstat (limited to 'mysql-test/main/subselect.test')
| -rw-r--r-- | mysql-test/main/subselect.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/main/subselect.test b/mysql-test/main/subselect.test index 7ed423edf96..5389e5da5cd 100644 --- a/mysql-test/main/subselect.test +++ b/mysql-test/main/subselect.test @@ -26,7 +26,8 @@ if (`select @join_cache_level_for_subselect_test is not null`) { set join_cache_level=@join_cache_level_for_subselect_test; } - set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; +SET optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; +SET optimizer_use_condition_selectivity=4; select (select 2); explain extended select (select 2); |