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

Re: BUG #3958: Self-Join Group-By Clause Produces Incorrect Results

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Marcus Torres" <marcsf23(at)yahoo(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3958: Self-Join Group-By Clause Produces Incorrect Results
Date: 2008-02-13 11:09:45
Message-ID: 47B2CFF9.6040506@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Marcus Torres wrote:
> The following bug has been logged online:
> 
> Bug reference:      3958
> Logged by:          Marcus Torres
> Email address:      marcsf23(at)yahoo(dot)com
> PostgreSQL version: 8.19
> Operating system:   Linux - Ubuntu
> Description:        Self-Join Group-By Clause Produces Incorrect Results
> Details: 
> 
> This is a repost of my original bug with self-contained sql to reproduce the
> problem:
> 
> I wrote a simple self-join query to sum the transaction count of different
> types of records in a audit table and the result set for the different sum
> totals was the same which is incorrect.  

Looks perfectly correct to me.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

In response to

Responses

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2008-02-13 11:24:13
Subject: Re: BUG #3959: Huge calculation error
Previous:From: Renaud DiezDate: 2008-02-13 09:53:57
Subject: BUG #3959: Huge calculation error

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