Page 1 of 1
Error when input low decimal values for SQL Server
Posted: Mon 21 Dec 2015 14:28
by andy_bri
Important bug in version 6.2.9:
If one inputs value less than 0.1 it is multiplied by 10!
For example one inputs 0.04, but it is saved as 0.4.
This happens for SQL Server, but this bug does not appear for Firebird.
Re: Error when input low decimal values for SQL Server
Posted: Wed 23 Dec 2015 15:26
by azyk
Thank you for the information. We have reproduced this problem and are investigating it. We will notify you about the results as any are available.
Re: Error when input low decimal values for SQL Server
Posted: Thu 07 Jan 2016 12:49
by cschwerdtfeger
You can work around this bug when you cast the value to float.
yields 0.625, but
Code: Select all
select cast((0.25 * 0.25) as float)
yields 0.0625 which is correct.
It's not just multiplied by 10, the precision is ignored. 0.04 is interpreted as 0.4, but also 0.004 is interpreted as 0.4 and so on.
0.001 has a precision of 3, but is interpreted as 0.1, 0.01 has a precision of 2 but is also interpreted as 0.1.
Re: Error when input low decimal values for SQL Server
Posted: Tue 12 Jan 2016 12:20
by AlexP
We have already fixed the problem. The fix will be included in the next version.