| Bug #6825 | wrong result,CONCAT(<string>,converted negative integer) UNION ... | ||
|---|---|---|---|
| Submitted: | 25 Nov 2004 12:33 | Modified: | 20 Dec 2004 23:58 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 4.1, 5.0 | OS: | |
| Assigned to: | Sergey Petrunya | CPU Architecture: | Any |
[25 Nov 2004 12:35]
Matthias Leich
test cases + comments
Attachment: ml50.test (application/octet-stream, text), 4.04 KiB.
[20 Dec 2004 23:58]
Sergey Petrunya
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.
If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information
about accessing the source trees is available at
http://www.mysql.com/doc/en/Installing_source_tree.html
Description: SELECT CONCAT(<string>, <explicit or implicit converted negative integer>) UNION <string> gives in my test cases wong results. I miss the last digit of the negative integer. A SELECT without the UNION gives the expected result. Please have a look into the attached test cases including many statements for comparison purposes and many comments. My environment: - Intel PC with Linux(SuSE 9.1) - MySQL compiled from source Version 5.0 ChangeSet@1.1687.2.1, 2004-11-25 Version 4.1 ChangeSet@1.2092.1.39, 2004-11-19 How to repeat: Please use my attached test file ml50.test , copy it to mysql-test/t ./mysql-test-run ml50