Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed

From: Meng Zhang <mza117jc(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed
Date: 2026-01-25 04:09:27
Message-ID: CAErYLFAuxmW0UVdgrz7iiuNrxGQnFK_OP9hBD5CUzRgjrVrz=Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 function to not be modified in the new
window.

Attachment Content-Type Size
0001-Fix-a-reference-error-for-window-functions.patch application/octet-stream 3.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Lakhin 2026-01-25 06:00:00 Re: pg_stat_statements: add missing tests for nesting_level
Previous Message Michael Paquier 2026-01-25 02:35:50 Re: Extended Statistics set/restore/clear functions.