diff options
| author | unknown <monty@mysql.com> | 2004-03-17 10:36:12 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2004-03-17 10:36:12 +0200 |
| commit | 219bbd5232d6ff958f97b30abbc0cb9646abf6a8 (patch) | |
| tree | 6f4235e7fd4eb101374c74e2c3c02470bb69d2ab /mysql-test/r/func_if.result | |
| parent | b523802138eef0c66d6ce89263b512c1494a277b (diff) | |
| parent | b54698374b5eea922a6f054338d804c2ba3aa682 (diff) | |
| download | mariadb-git-219bbd5232d6ff958f97b30abbc0cb9646abf6a8.tar.gz | |
merge with 4.0
innobase/btr/btr0cur.c:
Auto merged
innobase/btr/btr0sea.c:
Auto merged
innobase/include/log0log.h:
Auto merged
innobase/include/log0log.ic:
Auto merged
innobase/log/log0recv.c:
Auto merged
innobase/page/page0cur.c:
Auto merged
innobase/que/que0que.c:
Auto merged
myisam/myisam_ftdump.c:
Auto merged
mysql-test/r/func_if.result:
Auto merged
mysql-test/t/func_if.test:
Auto merged
Diffstat (limited to 'mysql-test/r/func_if.result')
| -rw-r--r-- | mysql-test/r/func_if.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index bea16c07f86..0a04585d77d 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -59,6 +59,12 @@ id select_type table type possible_keys key key_len ref rows Extra Warnings: Note 1003 select high_priority nullif((test.t1.u = 0),_latin1'test') AS `nullif(u=0, 'test')` from test.t1 drop table t1; +select NULLIF(NULL,NULL), NULLIF(NULL,1), NULLIF(NULL,1.0), NULLIF(NULL,"test"); +NULLIF(NULL,NULL) NULLIF(NULL,1) NULLIF(NULL,1.0) NULLIF(NULL,"test") +NULL NULL NULL NULL +select NULLIF(1,NULL), NULLIF(1.0, NULL), NULLIF("test", NULL); +NULLIF(1,NULL) NULLIF(1.0, NULL) NULLIF("test", NULL) +1 1.0 test create table t1 (num double(12,2)); insert into t1 values (144.54); select sum(if(num is null,0.00,num)) from t1; |