RE: Bug in FLOOR() function

2002-07-30 Thread Peter Normann
From: Andrea Forghieri [mailto:[EMAIL PROTECTED]] Sent: 30. juli 2002 11:51 To: [EMAIL PROTECTED] Subject: Bug in FLOOR() function Dear Sirs, please try this with Mysql 4.0.2 SELECT 25*9.54; -> 238.5 (so far so good) then SELECT (25*9.54)+0.5; -> 239.000 (still OK ) SEL

Bug in FLOOR() function

2002-07-30 Thread Andrea Forghieri
Dear Sirs, please try this with Mysql 4.0.2 SELECT 25*9.54; -> 238.5 (so far so good) then SELECT (25*9.54)+0.5; -> 239.000 (still OK ) SELECT FLOOR((25*9.54)+0.5); -> 238 (ouch !!) Best Regards Andrea Forghieri Emmegi S.p.A. # Usefu