diff options
| author | Igor Babaev <igor@askmonty.org> | 2010-05-26 13:18:18 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2010-05-26 13:18:18 -0700 |
| commit | 709a0a131021135e9fb7a2095fcfcbc223dfb126 (patch) | |
| tree | 9f8143ae3fa17bac5ab74140da692228d73c283f /mysql-test/r/index_merge_myisam.result | |
| parent | cb325eb2b2f738b63d162fb0d46cf335e4ae84a4 (diff) | |
| download | mariadb-git-709a0a131021135e9fb7a2095fcfcbc223dfb126.tar.gz | |
MWL#106: Backport optimizations for derived tables and views.
The main consolidated patch.
Diffstat (limited to 'mysql-test/r/index_merge_myisam.result')
| -rw-r--r-- | mysql-test/r/index_merge_myisam.result | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/mysql-test/r/index_merge_myisam.result b/mysql-test/r/index_merge_myisam.result index 04738abfd3e..23df18543ba 100644 --- a/mysql-test/r/index_merge_myisam.result +++ b/mysql-test/r/index_merge_myisam.result @@ -285,8 +285,7 @@ id select_type table type possible_keys key key_len ref rows Extra NULL UNION RESULT <union1,2> ALL NULL NULL NULL NULL NULL explain select * from (select * from t1 where key1 = 3 or key2 =3) as Z where key8 >5; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> system NULL NULL NULL NULL 1 -2 DERIVED t1 index_merge i1,i2 i1,i2 4,4 NULL 2 Using union(i1,i2); Using where; Using index +1 SIMPLE t1 ALL i1,i2,i8 NULL NULL NULL 1024 Using where create table t3 like t0; insert into t3 select * from t0; alter table t3 add key9 int not null, add index i9(key9); |