diff options
author | Igor Babaev <igor@askmonty.org> | 2010-08-31 15:45:25 -0700 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2010-08-31 15:45:25 -0700 |
commit | 56d3674ba594fd9797332ad83f5fdfcabe37520b (patch) | |
tree | f3933f46ed69506a3b2abf4a3ab80e42012b64c1 /mysql-test/r/index_merge_myisam.result | |
parent | 72a26cb020fdbee7bba7612f55ab4e254092a7af (diff) | |
parent | 6ac61bbe405764a1d05cf102d62dec799e772c84 (diff) | |
download | mariadb-git-56d3674ba594fd9797332ad83f5fdfcabe37520b.tar.gz |
Merge
Diffstat (limited to 'mysql-test/r/index_merge_myisam.result')
-rw-r--r-- | mysql-test/r/index_merge_myisam.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/index_merge_myisam.result b/mysql-test/r/index_merge_myisam.result index 182455f8c06..0a017ff8c8a 100644 --- a/mysql-test/r/index_merge_myisam.result +++ b/mysql-test/r/index_merge_myisam.result @@ -115,11 +115,11 @@ id select_type table type possible_keys key key_len ref rows Extra explain select * from t0 where (key1 < 3 or key2 < 3) and (key3 < 100); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t0 range i1,i2,i3 i3 4 NULL 95 Using where +1 SIMPLE t0 index_merge i1,i2,i3 i1,i2 4,4 NULL 6 Using sort_union(i1,i2); Using where explain select * from t0 where (key1 < 3 or key2 < 3) and (key3 < 1000); id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t0 ALL i1,i2,i3 NULL NULL NULL 1024 Using where +1 SIMPLE t0 index_merge i1,i2,i3 i1,i2 4,4 NULL 6 Using sort_union(i1,i2); Using where explain select * from t0 where ((key1 < 4 or key2 < 4) and (key2 <5 or key3 < 4)) or @@ -259,7 +259,7 @@ explain select * from t0,t1 where (t0.key1=t1.key1) and (t0.key1=3 or t0.key2=4) and t1.key1<200; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t0 ALL i1,i2 NULL NULL NULL 1024 Using where +1 SIMPLE t0 index_merge i1,i2 i1,i2 4,4 NULL 2 Using union(i1,i2); Using where 1 SIMPLE t1 ref i1 i1 4 test.t0.key1 1 explain select * from t0,t1 where (t0.key1=t1.key1) and |