diff options
| author | serg@serg.mylan <> | 2005-03-13 23:56:25 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2005-03-13 23:56:25 +0100 |
| commit | 9248f0d714dbd56ad0995ae38cf0679c8005d39f (patch) | |
| tree | a3dc3b28d35464516a5cc1c4942cca93e5d491a9 /mysql-test/r/join_outer.result | |
| parent | 8986ffebde7495d97bf2476521cf1338b6b1670d (diff) | |
| download | mariadb-git-9248f0d714dbd56ad0995ae38cf0679c8005d39f.tar.gz | |
Item_func_isnotnull::not_null_tables - return 0 if not top-level item
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); |