From 1c234737515106342180daa9671de15dedd48fcc Mon Sep 17 00:00:00 2001 From: unknown Date: Mon, 14 Mar 2005 11:04:42 +0100 Subject: anotehr fix for Item_func_isnotnull::not_null_tables() mysql-test/r/join_outer.result: anotehr test for Item_func_isnotnull::not_null_tables() mysql-test/t/join_outer.test: anotehr test for Item_func_isnotnull::not_null_tables() --- mysql-test/t/join_outer.test | 1 + 1 file changed, 1 insertion(+) (limited to 'mysql-test/t/join_outer.test') diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 31ddcfd7cf4..00f7e5f00bf 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -431,6 +431,7 @@ 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; +select * from t1 natural left join t2 where (t2.i is not null) is not null; drop table t1,t2,t3; # -- cgit v1.2.1