Request a Demo
Home   >   mailing lists

Re: BUG #17502: View based on window functions returns wrong results when queried - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17502: View based on window functions returns wrong results when queried
Date
Msg-id 2450292.1782786425@sss.pgh.pa.us
Whole thread
In response to Re: BUG #17502: View based on window functions returns wrong results when queried  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-bugs
Tree view 
David Rowley <dgrowleyml@gmail.com> writes:
> On Tue, 31 Jan 2023 at 11:53, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This bug seems to have slipped off the radar screen, but it's still
>> a bug.  I continue to believe that the best fix is to disallow SRFs
>> in window definitions, and present the trivial patch to do so.
>> As discussed, I'm comfortable with leaving this alone in the back
>> branches.

> There has been another report about this in bug #19535. Should we
> consider going with disallowing SRFs in the WindowClause for v19?

Yeah, that slipped off the radar screen *again*.  Let's disallow
SRFs in WindowClauses in HEAD and v19, and see if anyone complains.

            regards, tom lane

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #17502: View based on window functions returns wrong results when queried
Next
From: PG Bug reporting form
Date:
Subject: BUG #19540: Inconsistent integer-to-octal formatting for permission GUCs in pg_settings (boot_val vs setting)