diff options
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 46 |
1 files changed, 23 insertions, 23 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 9d3c152e516..3b9b13bdd3c 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -90,12 +90,12 @@ grp a c id a c d 2 3 c NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL explain select t1.*,t2.* from t1,t2 where t1.a=t2.a and isnull(t2.a)=1; -Comment -Impossible WHERE noticed after reading const tables +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST Impossible WHERE noticed after reading const tables explain select t1.*,t2.* from t1 left join t2 on t1.a=t2.a where isnull(t2.a)=1; -table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 7 -t2 eq_ref PRIMARY PRIMARY 8 t1.a 1 where used +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t1 ALL NULL NULL NULL NULL 7 +1 FIRST t2 eq_ref PRIMARY PRIMARY 8 t1.a 1 where used select t1.*,t2.*,t3.a from t1 left join t2 on (t1.a=t2.a) left join t1 as t3 on (t2.a=t3.a); grp a c id a c d a 1 1 a 1 1 a 1 1 @@ -311,13 +311,13 @@ select t1.name, t2.name, t2.id from t1 left join t2 on (t1.id = t2.owner) where name name id Lilliana Angelovska NULL NULL explain select t1.name, t2.name, t2.id from t1 left join t2 on (t1.id = t2.owner) where t2.id is null; -table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 3 -t2 ALL NULL NULL NULL NULL 3 where used; Not exists +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t1 ALL NULL NULL NULL NULL 3 +1 FIRST t2 ALL NULL NULL NULL NULL 3 where used; Not exists explain select t1.name, t2.name, t2.id from t1 left join t2 on (t1.id = t2.owner) where t2.name is null; -table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 3 -t2 ALL NULL NULL NULL NULL 3 where used +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t1 ALL NULL NULL NULL NULL 3 +1 FIRST t2 ALL NULL NULL NULL NULL 3 where used select count(*) from t1 left join t2 on (t1.id = t2.owner); count(*) 4 @@ -331,13 +331,13 @@ select t1.name, t2.name, t2.id from t2 right join t1 on (t1.id = t2.owner) where name name id Lilliana Angelovska NULL NULL explain select t1.name, t2.name, t2.id from t2 right join t1 on (t1.id = t2.owner) where t2.id is null; -table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 3 -t2 ALL NULL NULL NULL NULL 3 where used; Not exists +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t1 ALL NULL NULL NULL NULL 3 +1 FIRST t2 ALL NULL NULL NULL NULL 3 where used; Not exists explain select t1.name, t2.name, t2.id from t2 right join t1 on (t1.id = t2.owner) where t2.name is null; -table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 3 -t2 ALL NULL NULL NULL NULL 3 where used +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t1 ALL NULL NULL NULL NULL 3 +1 FIRST t2 ALL NULL NULL NULL NULL 3 where used select count(*) from t2 right join t1 on (t1.id = t2.owner); count(*) 4 @@ -618,9 +618,9 @@ UNIQUE id (id,idx) ); INSERT INTO t2 VALUES (1,1); explain SELECT * from t1 left join t2 on t1.id=t2.id where t2.id IS NULL; -table type possible_keys key key_len ref rows Extra -t1 ALL NULL NULL NULL NULL 2 -t2 index id id 8 NULL 1 where used; Using index; Not exists +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t1 ALL NULL NULL NULL NULL 2 +1 FIRST t2 index id id 8 NULL 1 where used; Using index; Not exists SELECT * from t1 left join t2 on t1.id=t2.id where t2.id IS NULL; id name id idx 2 no NULL NULL @@ -638,9 +638,9 @@ create table t2 (fooID smallint unsigned not null, barID smallint unsigned not n insert into t1 (fooID) values (10),(20),(30); insert into t2 values (10,1),(20,2),(30,3); explain select * from t2 left join t1 on t1.fooID = t2.fooID and t1.fooID = 30; -table type possible_keys key key_len ref rows Extra -t2 index NULL PRIMARY 4 NULL 3 Using index -t1 eq_ref PRIMARY PRIMARY 2 const 1 where used; Using index +id select_type table type possible_keys key key_len ref rows Extra +1 FIRST t2 index NULL PRIMARY 4 NULL 3 Using index +1 FIRST t1 eq_ref PRIMARY PRIMARY 2 const 1 where used; Using index select * from t2 left join t1 on t1.fooID = t2.fooID and t1.fooID = 30; fooID barID fooID 10 1 NULL |