summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_str.result
diff options
context:
space:
mode:
authortnurnberg@mysql.com <>2006-05-12 10:27:20 +0200
committertnurnberg@mysql.com <>2006-05-12 10:27:20 +0200
commitab69fac55d63425658510a6636605aff8df37640 (patch)
tree8dab981ba0cfeef2555a11afd8d5ef84ea2b7515 /mysql-test/r/func_str.result
parentd1417ad55a1b1b53abdde1034ba3fd52599c8244 (diff)
parent133a5d17f790f5f4c930fa892e6cb5a00fcbe346 (diff)
downloadmariadb-git-ab69fac55d63425658510a6636605aff8df37640.tar.gz
Merge mysql.com:/home/mysql-4.1-10418
into mysql.com:/home/mysql-5.0-10418
Diffstat (limited to 'mysql-test/r/func_str.result')
-rw-r--r--mysql-test/r/func_str.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index aed79e7f8fa..6f8269bdcbd 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -1017,6 +1017,13 @@ t
1000000
1
drop table t1;
+select load_file("lkjlkj");
+load_file("lkjlkj")
+NULL
+select ifnull(load_file("lkjlkj"),"it's null");
+ifnull(load_file("lkjlkj"),"it's null")
+it's null
+End of 4.1 tests
create table t1 (d decimal default null);
insert into t1 values (null);
select format(d, 2) from t1;