From: "Regina Obe" <lr@pcorp.us>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: "'David Rowley'" <david.rowley@2ndquadrant.com>,
	"'PostgreSQL-development'" <pgsql-hackers@postgresql.org>
References: <001501d40f88$75186950$5f493bf0$@pcorp.us>
 <CAKJS1f9r9-u16wEkQT2sKh5wRf3DJVVPSwoNAoJnnyqhH39dDg@mail.gmail.com>
 <000701d40fce$d1098a50$731c9ef0$@pcorp.us> <26933.1530295340@sss.pgh.pa.us>
In-Reply-To: <26933.1530295340@sss.pgh.pa.us>
Subject: RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found
 in targetlist
Date: Fri, 29 Jun 2018 14:49:33 -0400
Message-ID: <001301d40fd9$ec5b18e0$c5114aa0$@pcorp.us>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
Thread-Index: AQJsRSJPxw50c9w80aArPo91dZMGXgJZOOQ+AS1wVHYCKU69nKMZqTkQ
Content-Language: en-us
Precedence: bulk

> "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

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