diff options
Diffstat (limited to 'mysql-test/r/join.result')
| -rw-r--r-- | mysql-test/r/join.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index a7f1b5b64f1..25dcb1cc5c0 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -870,7 +870,7 @@ insert into t3 select * from t2 where a < 800; explain select * from t2,t3 where t2.a < 200 and t2.b=t3.b; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ALL a,b NULL NULL NULL 1000 Using where -1 SIMPLE t3 ref b b 5 test.t2.b 1 Using where +1 SIMPLE t3 ref b b 5 test.t2.b 1 drop table t1, t2, t3; create table t1 (a int); insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); @@ -1097,9 +1097,9 @@ ON t1.a = t3.a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 3 1 SIMPLE t3 ref a a 5 test.t1.a 2 Using index -1 SIMPLE t4 ALL NULL NULL NULL NULL 0 -1 SIMPLE t5 ALL NULL NULL NULL NULL 0 -1 SIMPLE t6 ALL NULL NULL NULL NULL 0 +1 SIMPLE t4 ALL NULL NULL NULL NULL 0 Using where +1 SIMPLE t5 ALL NULL NULL NULL NULL 0 Using where +1 SIMPLE t6 ALL NULL NULL NULL NULL 0 Using where 1 SIMPLE t2 ALL NULL NULL NULL NULL 10 Using where; Using join buffer SELECT * FROM @@ -1128,9 +1128,9 @@ EXPLAIN EXTENDED SELECT 1 FROM v1 right join v1 AS v2 ON RAND(); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 -1 SIMPLE t2 ALL NULL NULL NULL NULL 2 100.00 +1 SIMPLE t2 ALL NULL NULL NULL NULL 2 100.00 Using where 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 100.00 -1 SIMPLE t2 ALL NULL NULL NULL NULL 2 100.00 +1 SIMPLE t2 ALL NULL NULL NULL NULL 2 100.00 Using where Warnings: Note 1003 select 1 AS `1` from `test`.`t1` left join `test`.`t1` `t2` on((1 = 1)) left join (`test`.`t1` left join `test`.`t1` `t2` on((1 = 1))) on(rand()) where 1 DROP VIEW v1; |