diff options
| author | unknown <serg@serg.mylan> | 2005-03-13 23:56:25 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-03-13 23:56:25 +0100 |
| commit | d2c943b05b748566d798092dc42c163acb93d6cd (patch) | |
| tree | a3dc3b28d35464516a5cc1c4942cca93e5d491a9 /mysql-test | |
| parent | c99dfbd8a834034c440e6ae58f3dbe9535ec59d5 (diff) | |
| download | mariadb-git-d2c943b05b748566d798092dc42c163acb93d6cd.tar.gz | |
Item_func_isnotnull::not_null_tables - return 0 if not top-level item
mysql-test/r/join_outer.result:
test for some obscure usage of IS NOT NULL
mysql-test/t/join_outer.test:
test for some obscure usage of IS NOT NULL
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/join_outer.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/join_outer.test | 1 |
2 files changed, 4 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); diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 7d85ab09b08..31ddcfd7cf4 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -430,6 +430,7 @@ 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; +select * from t1 natural left join t2 where (t2.i is not null)=0; drop table t1,t2,t3; # |