On 2019-07-29 05:49, Geoff Worboys [email protected] [firebird-support] wrote: > Can anyone explain why the following example gives inconsistent > results. The first two I consider correct (rounded up to 8.42), > the last four I consider incorrect (rounded down to 8.41). > [..] > > I was changing over from a UDF of my own that used an explicitly > DOUBLE PRECISION input parameter. When I use that UDF in the > above code, all results return the same 8.42 value.
Without knowing what exactly you're previous UDF did, we can't really answer it. Likely it used a different rounding mode or rounding strategy than applied by Firebird. Mark
