|
|
Posted by Nicholas Sherlock on 05/11/05 07:53
Wescotte wrote:
> So why does it correct find results the first two times? I understand
> the concept of being unable to exactly represent a real number in
> binary do to limited bits but I fail to see how after two attempts
> conversion would suddenly differ.
The floating point control word of the CPU may be changed by code in one
part of your database server, then never reset. This means that the
rounding mode may change unpredictably, causing different results on
different runs. This is a bug, IMO.
Cheers,
Nicholas Sherlock
Navigation:
[Reply to this message]
|