On Wed, May 25, 2016 at 7:12 PM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>
> =# CREATE TABLE twocol(col01 int, col02 int);
> =# SELECT DISTINCT col01, col02, col01 FROM twocol ;
> ERROR: XX000: ORDER/GROUP BY expression not found in targetlist
> LOCATION: get_sortgroupref_tle, tlist.c:341
>
> which appears to be a 9.6 regression, presumable fallout from the path
> restructuring.
It's surprising that SQL Smith didn't catch something with such simple
steps to reproduce.
--
Peter Geoghegan