diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-16 13:39:39 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2003-04-16 13:39:39 +0300 |
| commit | a3274c2222bc09a055cdcac8d5606d11da37ed8e (patch) | |
| tree | 26e419ebd2f4756ce4924a20e3e530278d411fb5 /mysql-test/r/join_outer.result | |
| parent | 24aba046bf287388622e2fdc34bb66a6cca40876 (diff) | |
| download | mariadb-git-a3274c2222bc09a055cdcac8d5606d11da37ed8e.tar.gz | |
fix for a bug with two natural joins.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 6e69616b7c6..e68f3e6b006 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -652,3 +652,15 @@ fooID barID fooID 20 2 NULL 30 3 30 drop table t1,t2; +drop table if exists t3; +create table t1 (i int); +create table t2 (i int); +create table t3 (i int); +insert into t1 values(1),(2); +insert into t2 values(2),(3); +insert into t3 values(2),(4); +select * from t1 natural left join t2 natural left join t3; +i i i +1 NULL NULL +2 2 2 +drop table t1,t2,t3; |