Bug #6537 | SUM() function loses precision with Connector J and 4.1 database | ||
---|---|---|---|
Submitted: | 10 Nov 2004 2:07 | Modified: | 10 Nov 2004 23:09 |
Reporter: | Test Test | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | Connector / J | Severity: | S2 (Serious) |
Version: | 3.0.15-ga | OS: | Linux (Linux) |
Assigned to: | Mark Matthews | CPU Architecture: | Any |
[10 Nov 2004 2:07]
Test Test
[10 Nov 2004 23:09]
Mark Matthews
I couldn't repeat this in 3.0.15, however it is repeatable in 3.1.x with server-side prepared statements (due to the server converting to a Double before sending it because of the SUM(), and thus dropping the 'extra' zeroes, which doesn't happen when not using prepared statements, because the values are _always_ sent back to the client as strings, with formatting intact. This is now fixed, and will be available in 3.1.5.