Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
Date
Msg-id 26933.1530295340@sss.pgh.pa.us
Whole thread Raw
In response to RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist  ("Regina Obe" <lr@pcorp.us>)
Responses RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
List pgsql-hackers
"Regina Obe" <lr@pcorp.us> writes:
> Here is a trivial example to exercise that doesn't involve PostGIS.

> CREATE TABLE edge AS SELECT 1 AS edge_id;
> SELECT 't3280', 'L1b' || generate_series(1,10) 
> FROM edge
> ORDER BY 1;

That's odd.  It works fine in HEAD but not the v10 branch.  I suspect
that the fix David mentioned failed to cover some case related to the
issue we saw last week ... but why the cross-version difference?

Don't have time to investigate further right now.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Concurrency bug in UPDATE of partition-key
Next
From: Alvaro Herrera
Date:
Subject: Re: Explain buffers wrong counter with parallel plans