Bug #43403 UPPER(),LOWER() fail when called with some date-string funcs
Submitted: 5 Mar 2009 8:49 Modified: 6 Mar 2009 7:20
Reporter: Peter Brawley (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.31,6.0.9 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc

[5 Mar 2009 8:49] Peter Brawley 
Description:
select upper(dayname('2007-02-03') );
+------------------------------+
| upper(dayname('2007-02-03')) |
+------------------------------+
| Saturday                     |
+------------------------------+

select lower(dayname('2007-02-03') );
+-------------------------------+
| lower(dayname('2007-02-03') ) |
+-------------------------------+
| Saturday                      |
+-------------------------------+

select upper(date_format(curdate(),'%W %Y %M %D'));
+---------------------------------------------+
| upper(date_format(curdate(),'%W %Y %M %D')) |
+---------------------------------------------+
| THURSDAY 2009 MARCH 5TH                     |
+---------------------------------------------+

How to repeat:
As above
[5 Mar 2009 10:40] Sveta Smirnova 
Thank you for the report.

This is duplicate of bug #37575, but it should be fixed in version 5.1.31 (and I can not repeat bug in my environment). Please try with current version 5.1.32 and if bug still exists in your environment indicate accurate version of your operating system and MySQL package you are using (filename).
[6 Mar 2009 5:13] Peter Brawley 
The bug occurs in 5.1.30 back to at least 5.1.25. Not, though, in 5.1.31.

The bug occurs in 6.0.9.
[6 Mar 2009 7:20] Sveta Smirnova 
Thank you for the feedback.

>  Not, though, in 5.1.31.

If I understood correctly bug is not repeatable with version 5.1.31. So I close the report as duplicate of bug #37575. Regarding to version 6.0 please wait next 6.0.10 release where this bug is fixed.