Subject Re: [firebird-support] It´s a bug or whatever?
Author Carlos H. Cantu
Post date 2015-10-29T18:36:47Z
Re: [firebird-support] It´s a bug or whatever? It is by design... result of division will have as many decimal places as the sum of the number of the decimal places of the members of the equation, in your first example, 4.

Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br


Hi everybody.

When I try:
select (2183.48/(1-(37.25/100))) as valor from rdb$database

As result  Firebird: 3465,8412
But other databases(MSSQL) and spreadshets(Excel and Calc) the correct result is 3479,6494023904

If I change  (37.25/100) to 0.3725 as follow:
select (2183.48/(1-0.3725)) as valor from rdb$database

Then Result is correct 3479,6494023904

I would like to understand why this
or if it´s a new bug to post.

Firebird-2.5.4.26856_0_Win32