summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_if.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2004-03-17 10:36:12 +0200
committermonty@mysql.com <>2004-03-17 10:36:12 +0200
commitf9ad65049088dc58591c954903a22e527e96ea5a (patch)
tree6f4235e7fd4eb101374c74e2c3c02470bb69d2ab /mysql-test/t/func_if.test
parent44667503b75b539e43a057743f7baefce418d4d6 (diff)
parente8c65b886d91eded17d3aa859da831fd04877549 (diff)
downloadmariadb-git-f9ad65049088dc58591c954903a22e527e96ea5a.tar.gz
merge with 4.0
Diffstat (limited to 'mysql-test/t/func_if.test')
-rw-r--r--mysql-test/t/func_if.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/func_if.test b/mysql-test/t/func_if.test
index e44a7f6d6f9..36c3a38d2fe 100644
--- a/mysql-test/t/func_if.test
+++ b/mysql-test/t/func_if.test
@@ -30,6 +30,12 @@ explain extended select nullif(u=0, 'test') from t1;
drop table t1;
#
+# Bug 2629
+#
+select NULLIF(NULL,NULL), NULLIF(NULL,1), NULLIF(NULL,1.0), NULLIF(NULL,"test");
+select NULLIF(1,NULL), NULLIF(1.0, NULL), NULLIF("test", NULL);
+
+#
# Problem with IF()
#