Skip Menu |

This queue is for tickets about the DBD-mysql CPAN distribution.

Report information
The Basics
Id: 122541
Status: resolved
Priority: 0/
Queue: DBD-mysql

Owner: Nobody in particular
Requestors: dimitrios.kechagias [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

Subject: Missing trailing zero in some cases with mysql round()
Date: Wed, 19 Jul 2017 16:14:48 +0100
To: bug-DBD-mysql [...]
From: Dimitrios Kechagias <dimitrios.kechagias [...]>
Download (untitled) / with headers
text/plain 1.4k
This bug seems to have been introduced in DBD::mysql version 4.038_01 and is still present (4.043), tested on CentOS 6.5 with perl 5.10 and CentOS 7.2 with perl 5.24. Minimum reproducible code: use DBI; my $dbh = DBI->connect("DBI:mysql:host=localhost"); my $stmt = "SELECT round( degrees(0.00043)*69, 2)"; print $dbh->selectrow_array($stmt); result is “1.7” instead of the expected “1.70” for DBD::mysql versions > 4.038. Flatshare is a limited company registered in England and Wales. Registration #04407847, Registered office: 32 Park Green, Macclesfield, Cheshire, SK11 7NA. T: 01625 666 750 This electronic mail may contain confidential or legally privileged information. It is for the intended recipient(s) only. Should you receive this message in error, please notify the sender immediately by replying to this email. If you are not the intended recipient, any disclosure, distribution, reproduction, printing or reliance on the contents of this information is strictly prohibited. Whilst all care has been taken, Flatshare Ltd is not responsible for the integrity or content of any attachment(s) or links included within. * THE CONTENT OF THIS EMAIL IS NOT LEGAL ADVICE AND SHOULD NOT BE TREATED AS SUCH. CONTENT IS THE AUTHORS OPINION BASED ON EXPERIENCE OR THEIR INTERPRETATION OF PUBLICLY AVAILABLE INFORMATION. NONE OF OUR STAFF ARE LEGALLY TRAINED AND WE ALWAYS ADVISE THAT PROPER LEGAL ADVICE IS TAKEN IF REQUIRED.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to