summaryrefslogtreecommitdiff
path: root/mysql-test/r/func_str.result
diff options
context:
space:
mode:
authorgkodinov/kgeorge@magare.gmz <>2007-03-02 12:14:50 +0200
committergkodinov/kgeorge@magare.gmz <>2007-03-02 12:14:50 +0200
commit4a6efcd664791457ee2793e1d6286705bebcee86 (patch)
tree5ad96de4d1308f8e66de478889fd2215aa0c3f8b /mysql-test/r/func_str.result
parentb3cb8466804f1ab6d888c027948bb6ad3c5d0cb8 (diff)
downloadmariadb-git-4a6efcd664791457ee2793e1d6286705bebcee86.tar.gz
Bug #26537: item_unhex() was not expected
to return NULL for non-NULL arguments. This is not the case as it can return NULL for invalid hexidecimal strings. Fixed by setting the maybe_null flag.
Diffstat (limited to 'mysql-test/r/func_str.result')
-rw-r--r--mysql-test/r/func_str.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result
index 052451f8c54..d09d3aeb529 100644
--- a/mysql-test/r/func_str.result
+++ b/mysql-test/r/func_str.result
@@ -1940,4 +1940,10 @@ abcxx
select lpad('abc', cast(5 as unsigned integer), 'x');
lpad('abc', cast(5 as unsigned integer), 'x')
xxabc
+SELECT UNHEX('G');
+UNHEX('G')
+NULL
+SELECT UNHEX('G') IS NULL;
+UNHEX('G') IS NULL
+1
End of 5.0 tests