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

Re: non-deterministic error related to MIN/MAX optimization

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: non-deterministic error related to MIN/MAX optimization
Date: 2008-08-26 05:04:44
Message-ID: 19796.1219727084@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> On Mon, 2008-08-25 at 22:26 -0400, Tom Lane wrote: 
>> ... It's mostly accidental that there are any
>> variants that do work, I think.  Why would you want a SRF in a sort key?

> The following line was added to the regression tests:
> aggregates.sql:226:
> select max(unique2), generate_series(1,3) as g from tenk1 order by g desc;

Hmm ... by me, even, according to the CVS logs :-)

> I have no argument with what you say above. But one of my colleagues at
> Truviso was doing some experiments, and it was causing a regression
> failure here. I should have been more clear.

Please provide some more detail about those experiments.  The test case
hasn't been seen to fail in the buildfarm, AFAIR.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Janardhanachari, JagadeeshaDate: 2008-08-26 06:16:24
Subject: Re: Need default password for the user "sa"
Previous:From: Jeff DavisDate: 2008-08-26 04:49:45
Subject: Re: non-deterministic error related to MIN/MAX optimization

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