On 12/14/05, Cariotoglou Mike <[EMAIL PROTECTED]> wrote: > I now have a concrete example, which actually happened in an > installation, and helps to demonstrate the severity of the issue: > > try this code: > > create table test(f double); > insert into test values(13.04); > update test set f=f+0.02; > select * from test where f=13.06; -- returns no data > > can you imagine how many bugs waiting to happen are out there, because > of code like this ?
I found that same bug when comparing dates that microsoft was storing as floating point numbers. It's a problem with the programmer not understanding how floating point works, it's not a problem with any particular language.
