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

From: "Regina Obe" <lr(at)pcorp(dot)us>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(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:49:33
Message-ID: 001301d40fd9$ec5b18e0$c5114aa0$@pcorp.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

Yes, that concerned me too because our PostgreSQL 11 head is the first to
run in our battery of tests
So I would have expected any change in 10 would be committed in 11 as well
and 11 would fail too, but it didn't.

Thanks,
Regina

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Cramer 2018-06-29 18:55:02 Comment refers to non existent function IncreaseRestartDecodingForSlot
Previous Message Andres Freund 2018-06-29 18:47:41 Re: ERROR: cannot start subtransactions during a parallel operation