Re: Failure assertion in GROUPS mode of window function in current HEAD

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2018-07-12T15:17:10Z
Lists: pgsql-hackers
Masahiko Sawada <sawada.mshk@gmail.com> writes:
> I think we also can update the doc about that GROUPS offset mode
> requires ORDER BY clause. Thoughts? Attached patch updates it.

Ooops, I forgot to check the docs.  This isn't quite the right fix
though --- the problem is that there's a sentence at the end of that
para that now says exactly the wrong thing.  I fixed that.

			regards, tom lane


Commits

  1. Fix bugs with degenerate window ORDER BY clauses in GROUPS/RANGE mode.