diff options
| author | jan@hundin.mysql.fi <> | 2004-12-21 07:49:38 +0200 |
|---|---|---|
| committer | jan@hundin.mysql.fi <> | 2004-12-21 07:49:38 +0200 |
| commit | 198dc7a8ec6e220c348bb47e59a2ac7532be18b8 (patch) | |
| tree | 5d3767a8558fd05da17b5d4e3f361ef643d3a9b8 /mysql-test/r/join_outer.result | |
| parent | c187798fcbdb055bc69ec727c81840a132481cbe (diff) | |
| parent | 88b63ab6690bd453a1b841968b468759898cd94a (diff) | |
| download | mariadb-git-198dc7a8ec6e220c348bb47e59a2ac7532be18b8.tar.gz | |
Content merge.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 2f420905195..b7343065c73 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -853,4 +853,19 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE t2 ALL NULL NULL NULL NULL 2 1 SIMPLE t3 ALL NULL NULL NULL NULL 2 +drop table t1,t2; +create table t1 (a int, b int); +insert into t1 values (1,1),(2,2),(3,3); +create table t2 (a int, b int); +insert into t2 values (1,1), (2,2); +select * from t2 right join t1 on t2.a=t1.a; +a b a b +1 1 1 1 +2 2 2 2 +NULL NULL 3 3 +select straight_join * from t2 right join t1 on t2.a=t1.a; +a b a b +1 1 1 1 +2 2 2 2 +NULL NULL 3 3 DROP TABLE t0,t1,t2,t3; |