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

Re: DISTINCT MAX() results mismatch on 8.2 and 8.3

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>,"Taiki Yamaguchi" <yamaguchi(at)sraoss(dot)co(dot)jp>
Subject: Re: DISTINCT MAX() results mismatch on 8.2 and 8.3
Date: 2008-04-22 15:52:34
Message-ID: 480DC384.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
>>> On Wed, Mar 26, 2008 at  9:23 PM, in message
<20080327112308(dot)b1e9a692(dot)yamaguchi(at)sraoss(dot)co(dot)jp>, Taiki Yamaguchi
<yamaguchi(at)sraoss(dot)co(dot)jp> wrote: 
 
> 8.3.0
> ==============================
> yamaguti=# create table t1 (i int, j int primary key);
> NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
> "t1_pkey" for table "t1" CREATE TABLE
> yamaguti=# insert into t1 select g, g from generate_series(1, 100) as
g;
> INSERT 0 100
> yamaguti=# select distinct max(i) from t1;
>  max 
> -----
>  100
> (1 row)
> 
> yamaguti=# select distinct max(j) from t1;
> ERROR:  could not find pathkey item to sort
> ==============================
 
For the benefit of anyone searching the archives for the problem we
just hit, this message also occurs in 8.3.1 and also occurs against
the above test table for this statement:
 
test=# select max(j) as "maxj" from t1 order by "maxj";
ERROR:  could not find pathkey item to sort
 
Neither statement causes the error when run against a build from
REL8_3_STABLE from 35 minutes ago (2008-04-22 10:15 CDT).
 
-Kevin
 


In response to

Responses

pgsql-bugs by date

Next:From: Kris JurkaDate: 2008-04-22 15:53:19
Subject: Re: BUG #4123: Statement.setQueryTimeout does not work with Postgres Java Driver
Previous:From: Tom LaneDate: 2008-04-22 15:11:13
Subject: Re: BUG #4122: ./postres 'restart' does not start server with same options as 'start' does

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