Bug #10320 UPPER(MD5(NOW())) or UPPER(SHA1(NOW())) do not capitalize
Submitted: 2 May 2005 20:23 Modified: 2 May 2005 21:20
Reporter: Darin Dubie Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.1.11-NT OS:Microsoft Windows (Windows XP Professional)
Assigned to: CPU Architecture:Any

[2 May 2005 20:23] Darin Dubie
Description:
Running either of the above queries does not capitalize the hexadecimal digits of the digest returned.  "ad657e09d786b870c8b3c46da2277ec6"

I do not believe this is the expected behavior as running in the MySQL Query Browser returns the expected ''AD657E09D786B870C8B3C46DA2277EC6''.  Is this just a display issue with the command line utilities?

How to repeat:
FROM the 'mysql' command line utility running either of the following queries

SELECT UPPER(MD5(NOW()))

or

SELECT UPPER(SHA1(NOW()))

and observe none of the hex characters 'a' through 'f' get upper cased.

Suggested fix:
Check the display calls being made in the command line utilities.  Same problem does not occur in MySQL Query Analyzer so it appears to be restricted to the command line utilities.  I was not able to test on a UNIX machine.
[2 May 2005 21:20] Hartmut Holzgraefe
see Bug #7008