From: Regina Obe <lr@pcorp.us>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: 'David Rowley' <david.rowley@2ndquadrant.com>
Cc: 'PostgreSQL-development' <pgsql-hackers@postgresql.org>
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> (raw)
In-Reply-To: <26933.1530295340@sss.pgh.pa.us>
References: <001501d40f88$75186950$5f493bf0$@pcorp.us>
<CAKJS1f9r9-u16wEkQT2sKh5wRf3DJVVPSwoNAoJnnyqhH39dDg@mail.gmail.com>
<000701d40fce$d1098a50$731c9ef0$@pcorp.us>
<26933.1530295340@sss.pgh.pa.us>
> "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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: lr@pcorp.us, tgl@sss.pgh.pa.us, david.rowley@2ndquadrant.com
Subject: RE: Regression on PostgreSQL 10 ORDER/GROUP BY expression not found in targetlist
In-Reply-To: <001301d40fd9$ec5b18e0$c5114aa0$@pcorp.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox