diff options
| author | unknown <jani@ua141d10.elisa.omakaista.fi> | 2004-11-12 20:38:58 +0200 |
|---|---|---|
| committer | unknown <jani@ua141d10.elisa.omakaista.fi> | 2004-11-12 20:38:58 +0200 |
| commit | 75a4c71b67508c7b1390477a4a3a4a4aba120bbb (patch) | |
| tree | d351998dbbb6448d1c9c837ff4fa33e2687cce1c /mysql-test/r/func_str.result | |
| parent | 20d88eb76f4e5fea1acdb68b6d2ad86b59ba61f9 (diff) | |
| parent | c7b66f9ddefb95050c21a9938578a0f56d9dd0d0 (diff) | |
| download | mariadb-git-75a4c71b67508c7b1390477a4a3a4a4aba120bbb.tar.gz | |
Merge with 4.0
Diffstat (limited to 'mysql-test/r/func_str.result')
| -rw-r--r-- | mysql-test/r/func_str.result | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 4a3a70274fd..8d49d55be39 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -201,6 +201,9 @@ hex(unhex("1")) hex(unhex("12")) hex(unhex("123")) hex(unhex("1234")) hex(unhex( select length(unhex(md5("abrakadabra"))); length(unhex(md5("abrakadabra"))) 16 +select concat('a', quote(NULL)); +concat('a', quote(NULL)) +aNULL select reverse(""); reverse("") @@ -312,7 +315,7 @@ insert into t1 values ('one'),(NULL),('two'),('four'); select a, quote(a), isnull(quote(a)), quote(a) is null, ifnull(quote(a), 'n') from t1; a quote(a) isnull(quote(a)) quote(a) is null ifnull(quote(a), 'n') one 'one' 0 0 'one' -NULL NULL 1 1 n +NULL NULL 0 0 NULL two 'two' 0 0 'two' four 'four' 0 0 'four' drop table t1; |