summaryrefslogtreecommitdiff
path: root/mysql-test/t/join_outer.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2005-03-14 11:04:42 +0100
committerunknown <serg@serg.mylan>2005-03-14 11:04:42 +0100
commit1c234737515106342180daa9671de15dedd48fcc (patch)
treea33cb38030f4e9f10952cc9ce0e35488b230d788 /mysql-test/t/join_outer.test
parent174a177ccb176e03d02bc57c05a7cc4d76a0a4c3 (diff)
downloadmariadb-git-1c234737515106342180daa9671de15dedd48fcc.tar.gz
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()
Diffstat (limited to 'mysql-test/t/join_outer.test')
-rw-r--r--mysql-test/t/join_outer.test1
1 files changed, 1 insertions, 0 deletions
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;
#