Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Regina Obe" <lr(at)pcorp(dot)us>
Cc: "'David Rowley'" <david(dot)rowley(at)2ndquadrant(dot)com>, "'PostgreSQL-development'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
Date: 2018-06-29 18:02:20
Message-ID: 26933.1530295340@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Regina Obe" <lr(at)pcorp(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2018-06-29 18:22:17 Re: Explain buffers wrong counter with parallel plans
Previous Message Alvaro Herrera 2018-06-29 17:52:07 Re: Concurrency bug in UPDATE of partition-key