diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-11-21 05:16:16 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-11-21 05:16:16 -0800 |
| commit | af3d1da31d486cdda78fe2cbcd94781be35ef2a8 (patch) | |
| tree | a802cd8373a7dae75dc5e224262efc3be941a04f /mysql-test/suite/maria/r/maria.result | |
| parent | 3c496ea9ad4e7ef289eee35f9775c58a0e5f82b8 (diff) | |
| download | mariadb-git-af3d1da31d486cdda78fe2cbcd94781be35ef2a8.tar.gz | |
Made the optimizer switch for index condition pushdown set to 'on' by default.
Diffstat (limited to 'mysql-test/suite/maria/r/maria.result')
| -rw-r--r-- | mysql-test/suite/maria/r/maria.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/suite/maria/r/maria.result b/mysql-test/suite/maria/r/maria.result index 4ff0b57a230..e6835a478f7 100644 --- a/mysql-test/suite/maria/r/maria.result +++ b/mysql-test/suite/maria/r/maria.result @@ -401,10 +401,10 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref a a 4 test.t2.a 1 explain select * from t1 where a=0 or a=2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 4 NULL 5 Using where +1 SIMPLE t1 range a a 4 NULL 5 Using index condition; Using where explain select * from t1 force index (a) where a=0 or a=2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 range a a 4 NULL 5 Using where +1 SIMPLE t1 range a a 4 NULL 5 Using index condition; Using where explain select * from t1 where c=1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref c,c_2 c 5 const 2 @@ -1143,7 +1143,7 @@ qq *a *a*a * explain select * from t1 where v='a'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref v,v_2 # 13 const # Using where +1 SIMPLE t1 ref v,v_2 # 13 const # Using index condition select v,count(*) from t1 group by v limit 10; v count(*) a 1 @@ -1319,7 +1319,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref v v 303 const # Using where; Using index explain select * from t1 where v='a'; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref v v 303 const # Using where +1 SIMPLE t1 ref v v 303 const # Using index condition select v,count(*) from t1 group by v limit 10; v count(*) a 1 |