Bug #4441 UNHEX Function
Submitted: 7 Jul 2004 22:58 Modified: 8 Jul 2004 1:42
Reporter: Francis Lennert
Status: Closed
Category:Server Severity:S2 (Serious)
Version:4.1.3 OS:
Assigned to: Sergei Golubchik Target Version:

[7 Jul 2004 22: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 23:37] Paul DuBois 
It's not just on Windows. I can repeat this on Linux and Mac OS X, too.
[8 Jul 2004 1: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