MySQL Bugs: #10320: UPPER(MD5(NOW())) or UPPER(SHA1(NOW())) do not capitalize

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:	Windows (Windows XP Professional)
Assigned to:		CPU Architecture:	Any

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.

see Bug #7008