diff options
Diffstat (limited to 'mysql-test/main/optimizer_costs.result')
-rw-r--r-- | mysql-test/main/optimizer_costs.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/optimizer_costs.result b/mysql-test/main/optimizer_costs.result index fefc03ae411..49bfdc09a7c 100644 --- a/mysql-test/main/optimizer_costs.result +++ b/mysql-test/main/optimizer_costs.result @@ -228,7 +228,7 @@ flush tables; explain select sum(t2.p+length(t1.a)) from t1, t2 where t1.p = t2.i; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL PRIMARY NULL NULL NULL 2 -1 SIMPLE t2 ref k1 k1 5 test.t1.p 2 +1 SIMPLE t2 ref k1 k1 5 test.t1.p 1 set @@optimizer_scan_setup_cost=0.0, @@global.myisam.optimizer_disk_read_ratio=0.0; flush tables; explain select sum(t2.p+length(t1.a)) from t1, t2 where t1.p = t2.i; |