Bug #42489 LOWER(SUBSTR(DAYNAME( FROM_UNIXTIME( 1233464398 ) ) ,1,3)) show capital letters
Submitted: 30 Jan 2009 18:36 Modified: 1 Feb 2009 21:37
Reporter: Itay Moav Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.0.51 OS:Linux
Assigned to: CPU Architecture:Any
Tags: dayname, LOWER, substr

[30 Jan 2009 18:36] Itay Moav 
Description:
The following SQL should return a lowercase string.
It isn't
SELECT LOWER(SUBSTR(DAYNAME( FROM_UNIXTIME( 1233464398 ) ) ,1,3))

How to repeat:
run
SELECT LOWER(SUBSTR(DAYNAME( FROM_UNIXTIME( 1233464398 ) ) ,1,3))
[30 Jan 2009 18:38] Paul DuBois 
Fixed by Bug#37575 in MySQL 5.0.76?
[31 Jan 2009 6:01] Itay Moav 
http://bugs.mysql.com/bug.php?id=37575 seems to be the same bug
[1 Feb 2009 21:37] MySQL Verification Team 
Indeed duplicate of bug; http://bugs.mysql.com/bug.php?id=37575 and already fixed on source.