Subject Re: [ib-support] Re: IB6 BUG #221589: numeric fields and mathematical operations
Author Svein Erling Tysvær
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 database.

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?