From 4a6efcd664791457ee2793e1d6286705bebcee86 Mon Sep 17 00:00:00 2001
From: "gkodinov/kgeorge@magare.gmz" <>
Date: Fri, 2 Mar 2007 12:14:50 +0200
Subject: 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.

---
 mysql-test/r/func_str.result | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'mysql-test/r/func_str.result')

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
-- 
cgit v1.2.1