Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed - Mailing list pgsql-hackers

From David Rowley
Subject Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed
Date
Msg-id CAApHDvoW8LZuiGK+_cyAR7q2kgoEeZfjNwm6wK2KcpvTGbcRgQ@mail.gmail.com
Whole thread Raw
In response to Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed  (Meng Zhang <mza117jc@gmail.com>)
Responses Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed
Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed
List pgsql-hackers
On Sun, 25 Jan 2026 at 17:09, Meng Zhang <mza117jc@gmail.com> wrote:
> The deduplication logic won't cause an error when the result of this function is only used in
`select_active_windows`.
> But when the result is used in `optimize_window_clauses`, it will cause the `winref` field of a certain window
functionto not be modified in the new window.
 

Thanks for the report. I'll have a look.

David



pgsql-hackers by date:

Previous
From: Junwang Zhao
Date:
Subject: [PATCH] Replace COUNT(NULL) with '0'::bigint
Next
From: Tender Wang
Date:
Subject: Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed