Bug #61032 | Convert to Integers Returns Errorneous Results | ||
---|---|---|---|
Submitted: | 2 May 2011 22:46 | Modified: | 3 Jun 2011 1:36 |
Reporter: | Benjamin Robinson | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.0.51b | OS: | Windows (Vista) |
Assigned to: | CPU Architecture: | Any | |
Tags: | convert, SQL |
[2 May 2011 22:46]
Benjamin Robinson
[3 May 2011 1:36]
MySQL Verification Team
Thank you for the bug report. Could you please check the Manual: http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html CONVERT(expr,type) The type can be one of the following values: SIGNED [INTEGER] UNSIGNED [INTEGER] Then your example convert(1.5, int) is actually wrong syntax. Thanks in advance.
[3 Jun 2011 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".