diff options
| author | unknown <timour@mysql.com> | 2005-10-25 09:01:47 +0300 |
|---|---|---|
| committer | unknown <timour@mysql.com> | 2005-10-25 09:01:47 +0300 |
| commit | 215602cbe39243e9b6421894e11aa52ef576da81 (patch) | |
| tree | 168f5a86e7698959406d97159f23e199d53eb224 /mysql-test/r/select.result | |
| parent | bd3ec22f85dfeb1382e5a1a2aa27c9092c940603 (diff) | |
| parent | 3efd251ae3dac657b5576f111f70564ba3d7f289 (diff) | |
| download | mariadb-git-215602cbe39243e9b6421894e11aa52ef576da81.tar.gz | |
Merge mysql.com:/home/timka/mysql/src/5.0-virgin
into mysql.com:/home/timka/mysql/src/5.0-bug-13832
mysql-test/r/select.result:
Auto merged
mysql-test/t/select.test:
Auto merged
sql/sql_yacc.yy:
Auto merged
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index fb61095cf22..cd7c70b603c 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -3181,3 +3181,15 @@ from t1 inner join (t2 right join t3 on t2.id = t3.b_id) on t1.id = t3.a_id; count(*) 6 drop table t1,t2,t3; +create table t1 (a int); +create table t2 (b int); +create table t3 (c int); +select * from t1 join t2 join t3 on (t1.a=t3.c); +a b c +select * from t1 join t2 left join t3 on (t1.a=t3.c); +a b c +select * from t1 join t2 right join t3 on (t1.a=t3.c); +a b c +select * from t1 join t2 straight_join t3 on (t1.a=t3.c); +a b c +drop table t1, t2 ,t3; |