diff options
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 01447d5e464..c278e50afdc 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -650,6 +650,9 @@ select * from t1 natural left join t2 natural left join t3; i i i 1 NULL NULL 2 2 2 +select * from t1 natural left join t2 where (t2.i is not null)=0; +i i +1 NULL drop table t1,t2,t3; create table t1 (f1 integer,f2 integer,f3 integer); create table t2 (f2 integer,f4 integer); |