Re: bug with aggregate + multi column index + index_scan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Brian Hirt <bhirt(at)mobygames(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: bug with aggregate + multi column index + index_scan
Date: 2006-01-29 18:58:19
Message-ID: 9391.1138561099@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Brian Hirt <bhirt(at)mobygames(dot)com> writes:
> I've run across a rather nasty bug in 8.1.2. It seems when the
> planer uses an index_scan within a GroupAggregate for a multi column
> index you can get incorrect results.

Patch is here if you need it before 8.1.3:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00377.php

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-01-29 20:14:59 Re: BUG #2218: Variables selected in VIEWs under different names break queries using those views
Previous Message Tom Lane 2006-01-29 16:31:46 Re: bug with aggregate + multi column index + index_scan