From d7281b331a79d1e2e3f026bbf71660006ee6df0b Mon Sep 17 00:00:00 2001 From: unknown Date: Sat, 18 Sep 2004 13:06:44 +0400 Subject: Fix for bug #5595: NULLIF() IS NULL returns false if NULLIF() returns NULL --- mysql-test/r/func_if.result | 3 +++ 1 file changed, 3 insertions(+) (limited to 'mysql-test/r/func_if.result') diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index aee54ede324..72226588de3 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -64,3 +64,6 @@ select if(1>2,a,avg(a)) from t1; if(1>2,a,avg(a)) 1.5000 drop table t1; +SELECT NULLIF(5,5) IS NULL, NULLIF(5,5) IS NOT NULL; +NULLIF(5,5) IS NULL NULLIF(5,5) IS NOT NULL +1 0 -- cgit v1.2.1