diff options
| author | igor@rurik.mysql.com <> | 2004-06-10 22:27:21 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2004-06-10 22:27:21 -0700 |
| commit | 356cbe4fa21aaddd48f5bd9541634214b3aa220d (patch) | |
| tree | dea74bc620f67c825c7c66767c81c27051cec635 /mysql-test/r/join_outer.result | |
| parent | f9e2c6cd27268e72198bde3c1a71eb1273df335a (diff) | |
| download | mariadb-git-356cbe4fa21aaddd48f5bd9541634214b3aa220d.tar.gz | |
join_nested.test, join_nested.result:
new file
Many files:
Nested joins added.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 8 |
1 files changed, 1 insertions, 7 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index c40f86827f8..34b00e5bd37 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -356,13 +356,7 @@ select t1.name, t2.name, t2.id, t2.owner, t3.id from t1 left join t2 on (t1.id = name name id owner id Antonio Paz El Gato 1 1 1 Antonio Paz Perrito 2 1 1 -Lilliana Angelovska NULL NULL NULL 1 -Thimble Smith NULL NULL NULL 1 -Antonio Paz NULL NULL NULL 2 -Lilliana Angelovska NULL NULL NULL 2 -Thimble Smith NULL NULL NULL 2 -Antonio Paz NULL NULL NULL 3 -Lilliana Angelovska NULL NULL NULL 3 +NULL NULL NULL NULL 2 Thimble Smith Happy 3 3 3 drop table t1,t2; create table t1 (id int not null, str char(10), index(str)); |