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/t/join_nested.test | |
| 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/t/join_nested.test')
| -rw-r--r-- | mysql-test/t/join_nested.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/join_nested.test b/mysql-test/t/join_nested.test index f4b6370539d..8247a12fc56 100644 --- a/mysql-test/t/join_nested.test +++ b/mysql-test/t/join_nested.test @@ -458,6 +458,14 @@ SELECT t1.a,t1.b,t2.a,t2.b,t3.a,t3.b,t4.a,t4.b ON t3.a=1 AND t2.b=t4.b WHERE t1.a <= 2; +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; + CREATE INDEX idx_b ON t2(b); EXPLAIN EXTENDED |