Bug #4441 UNHEX Function
Submitted: 7 Jul 2004 20:58 Modified: 7 Jul 2004 23:42
Reporter: Francis Lennert Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.3 OS:
Assigned to: Sergei Golubchik CPU Architecture:Any

[7 Jul 2004 20:58] Francis Lennert 
Description:
When you use the new UNHEX Function with a NULL Value, you crash your system.

How to repeat:

 update MyPoorTableWichWillCrash set MYVAL = UNHEX( MYNULLVALUE ) ;

Suggested fix:
I have used the Workaround :
Update ....Set ..= IF( MYVAL IS NULL , NULL , unhex(MYVAL ).

I am sure that you will fix that better than me 

;=)
[7 Jul 2004 21:37] Paul DuBois 
It's not just on Windows. I can repeat this on Linux and Mac OS X, too.
[7 Jul 2004 23:42] Sergei Golubchik 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.1.4