diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-07-03 01:08:46 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-07-03 01:08:46 +0300 |
| commit | 688baf8390a812507ab14a43b4902b8e5d0d6c97 (patch) | |
| tree | 6116cc924e2a15d1eeafb3f39091156f97c05f9e /mysql-test/r/join_nested.result | |
| parent | 148eecbd4008b4d47e5167e10503b2cc82f9a3d1 (diff) | |
| download | mariadb-git-688baf8390a812507ab14a43b4902b8e5d0d6c97.tar.gz | |
right join print fixed
mysql-test/r/join_nested.result:
right join test
mysql-test/t/join_nested.test:
right join test
Diffstat (limited to 'mysql-test/r/join_nested.result')
| -rw-r--r-- | mysql-test/r/join_nested.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/join_nested.result b/mysql-test/r/join_nested.result index 7a205811113..845fceab2f1 100644 --- a/mysql-test/r/join_nested.result +++ b/mysql-test/r/join_nested.result @@ -845,6 +845,20 @@ a b a b a b a b 1 3 5 3 2 2 NULL NULL 2 2 5 3 1 2 NULL NULL 2 2 5 3 2 2 NULL NULL +EXPLAIN EXTENDED +SELECT t1.a,t1.b,t2.a,t2.b,t3.a,t3.b,t4.a,t4.b +FROM t1, t3, t4 +RIGHT JOIN +t2 +ON t3.a=1 AND t2.b=t4.b +WHERE t1.a <= 2; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t3 ALL NULL NULL NULL NULL 2 +1 SIMPLE t1 ALL NULL NULL NULL NULL 3 Using where +1 SIMPLE t2 ALL NULL NULL NULL NULL 3 +1 SIMPLE t4 ALL NULL NULL NULL NULL 2 +Warnings: +Note 1003 select test.t1.a AS `a`,test.t1.b AS `b`,test.t2.a AS `a`,test.t2.b AS `b`,test.t3.a AS `a`,test.t3.b AS `b`,test.t4.a AS `a`,test.t4.b AS `b` from test.t1 join test.t3 join test.t2 left join test.t4 on(((test.t3.a = 1) and (test.t2.b = test.t4.b))) where (test.t1.a <= 2) CREATE INDEX idx_b ON t2(b); EXPLAIN EXTENDED SELECT t2.a,t2.b,t3.a,t3.b,t4.a,t4.b |