diff options
| author | unknown <gluh@gluh.mysql.r18.ru> | 2004-03-16 11:33:03 +0400 |
|---|---|---|
| committer | unknown <gluh@gluh.mysql.r18.ru> | 2004-03-16 11:33:03 +0400 |
| commit | 5adbc611dd70bcba787e4c2b8c264a0253cdd875 (patch) | |
| tree | b96052040aa2326af60424f3196dba87bd2b986f /mysql-test/t/func_if.test | |
| parent | bb305494397b4fa02eacfc8b23348255074cbf97 (diff) | |
| download | mariadb-git-5adbc611dd70bcba787e4c2b8c264a0253cdd875.tar.gz | |
Fix for bug #2629 NULLIF() doesn't behave as described in manual
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 85553d1a2fd..1f95239bf4b 100644 --- a/mysql-test/t/func_if.test +++ b/mysql-test/t/func_if.test @@ -21,6 +21,12 @@ select if(u=1,st,binary st) s from t1 where st like "%a%" order by s; 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() # |