diff options
Diffstat (limited to 'mysql-test/main/opt_trace.test')
| -rw-r--r-- | mysql-test/main/opt_trace.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/opt_trace.test b/mysql-test/main/opt_trace.test index 314e5825c08..3f221717279 100644 --- a/mysql-test/main/opt_trace.test +++ b/mysql-test/main/opt_trace.test @@ -155,8 +155,12 @@ update t1 set a=1 where pk between 0 and 180; update t1 set b=2 where pk between 0 and 20; analyze table t1; set optimizer_trace='enabled=on'; + +set @save_optimizer_switch= @@optimizer_switch; +set optimizer_switch='cost_based_order_by_limit=off'; explain select * from t1 where a=1 and b=2 order by c limit 1; select * from INFORMATION_SCHEMA.OPTIMIZER_TRACE; +set optimizer_switch=@save_optimizer_switch; drop table t1,ten,one_k; --echo # |