diff options
Diffstat (limited to 'mysql-test/t/func_if.test')
| -rw-r--r-- | mysql-test/t/func_if.test | 6 |
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() # |