| Bug #43423 | UPPER with Substring extracting DAYNAME doesnt convert to UPPER | ||
|---|---|---|---|
| Submitted: | 5 Mar 2009 16:23 | Modified: | 5 Mar 2009 23:15 |
| Reporter: | venkat Java | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S1 (Critical) |
| Version: | 6.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[5 Mar 2009 20:21]
Sveta Smirnova
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely to be the same. Because of this, we hope you add your comments to the original bug instead. Thank you for your interest in MySQL. Duplicate of bug #37575 which fixed in version 6.0.10. Please wait next release.
[5 Mar 2009 23:15]
venkat Java
I didnt notice the duplicate .Thanks for the update. Sure i will look for 6.0.10 release.
Description: Its pretty straight by looking at the below query. It works if you just give string as 'Saturday' instead of DAYNAME function. mysql> SELECT UPPER(SUBSTRING(DAYNAME('2007-02-03'),1,3) ); +----------------------------------------------+ | UPPER(SUBSTRING(DAYNAME('2007-02-03'),1,3) ) | +----------------------------------------------+ | Sat | +----------------------------------------------+ 1 row in set (0.04 sec) How to repeat: mysql> SELECT UPPER(SUBSTRING(DAYNAME('2007-02-03'),1,3) );