Subject Re: IB6 BUG #221589: numeric fields and mathematical operations
Author lobolo2000
It turned out that in my case (IB6 instead of Firebird), dialect 1 (which I
was using) gave different results than what you have. I'll install FB 1.0
the soonest.


----- Original Message -----
Date: Fri, 24 Aug 2001 10:50:37 +0200
From: Svein Erling Tysvær <svein.erling.tysvaer@...>
Subject: Re: Re: IB6 BUG #221589: numeric fields and mathematical operations

Hmm, something must be different between us. Using IB_SQL (the new name for
IB_WISQL) I do get 0.1 running against Firebird 0.9.4 on a dialect 3

If I remember correctly, you did divide by 100 in your query. Are you
saying that your result doesn't improve if you change that to 100.00?


>Thanx Svein.
>I had nearly lost hope in getting a reply to my post.
>SELECT 10.5/100 FROM RDB$DATABASE gave 0.105 (and not 0.1) as I would
>expect. But anyway, this query is a little bit different than the one in my
>post as 0.1 is not an intermediate result. Having intermediate results with
>a low precision would be awful. I would expect from any decent expression
>evaluator to use doubles or better for intermediate results. And my version
>of IB (6 open source) is consistent in this respect.
>Am I missing something?

Do You Yahoo!?
Get your free @... address at