| Bug #26269 | UPPER(CONCAT(...)) does not convert to uppercase | ||
|---|---|---|---|
| Submitted: | 11 Feb 2007 17:34 | Modified: | 12 Feb 2007 8:48 |
| Reporter: | Helge Rustad | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
| Version: | 5.0.24a-Debian_9-log | OS: | Linux (Ubuntu edgy, 2.6.17-10-server) |
| Assigned to: | CPU Architecture: | Any | |
[12 Feb 2007 8:48]
Valeriy Kravchuk
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ (http://dev.mysql.com/doc/refman/5.0/en/charset-result.html in this case) and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php. You have a binary string as a result of CONCAT because you added NOW() there.
Description: I run the following query: mysql> SELECT UPPER(CONCAT('rust',' ', NOW())) ; +----------------------------------+ | UPPER(CONCAT('rust',' ', NOW())) | +----------------------------------+ | rust 2007-02-11 18:29:34 | +----------------------------------+ 1 row in set (0.00 sec) The string is not converted to uppercase as would be expected. The same happens if the NOW() call is replaced by a datetime field from a table. The NOW() function call has something to do with it. If I remove it it works correctly. How to repeat: As described above.