Skip site navigation (1) Skip section navigation (2)

BUG #3959: Huge calculation error

From: "Renaud Diez" <rdiez(at)salesprize(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3959: Huge calculation error
Date: 2008-02-13 09:53:57
Message-ID: 200802130953.m1D9rv00042872@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3959
Logged by:          Renaud Diez
Email address:      rdiez(at)salesprize(dot)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.

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2008-02-13 11:09:45
Subject: Re: BUG #3958: Self-Join Group-By Clause Produces Incorrect Results
Previous:From: Marcus TorresDate: 2008-02-13 02:17:37
Subject: BUG #3958: Self-Join Group-By Clause Produces Incorrect Results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group