BUG #3387: mod on non-integer returns bad result

From: "Filip Krska" <filip(dot)krska(at)comstar(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3387: mod on non-integer returns bad result
Date: 2007-06-15 12:53:14
Message-ID: 200706151253.l5FCrECp022959@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3387
Logged by: Filip Krska
Email address: filip(dot)krska(at)comstar(dot)cz
PostgreSQL version: 8.1.5
Operating system: CentOS Linux 3.8 on x86_64
Description: mod on non-integer returns bad result
Details:

Hello,

select mod (70.0,70) from dual;

returns

70.0

instead of

0.0

This happens on x86_64 architecture (e.g. Intel Xeon E5310, Xeon
DP 3GHz, but not only) with PostgreSQL compiled for x86_64. If compiled for
i686, gives right results.

Bad results occurs for 70.0 and multiples.
e. g.
select mod (60.0,60) from dual;
returns 0.0

Also
select mod (70,70) from dual;
gives 0 correctly.

Thanks, Filip

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-06-15 14:15:50 Re: BUG #3387: mod on non-integer returns bad result
Previous Message Douglas Toltzman 2007-06-14 11:13:22 Re: Duplicate Data insertion