Postgres Pro
Downloads
Home   >   mailing lists

BUG #3959: Huge calculation error - Mailing list pgsql-bugs

From Renaud Diez
Subject BUG #3959: Huge calculation error
Date
Msg-id 200802130953.m1D9rv00042872@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3959: Huge calculation error  (Magnus Hagander <magnus@hagander.net>)
Re: BUG #3959: Huge calculation error  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Re: BUG #3959: Huge calculation error  (Rodriguez Fernando <rodriguez@ort.edu.uy>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      3959
Logged by:          Renaud Diez
Email address:      rdiez@salesprize.com
PostgreSQL version: 8.2
Operating system:   Debian
Description:        Huge calculation error
Details:

the basic mathematical expression like the following one doesn't compute the
correct result:

> select 100*(1+(21/100));

return a result of 100 instead of 121.

pgsql-bugs by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #3958: Self-Join Group-By Clause Produces Incorrect Results
Next
From: Magnus Hagander
Date:
Subject: Re: BUG #3959: Huge calculation error