pgsql: Handle WindowClause.runCondition in tree walker/mutator function

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Handle WindowClause.runCondition in tree walker/mutator function
Дата
Msg-id E1rNdRe-000nzn-SK@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Handle WindowClause.runCondition in tree walker/mutator functions.

Commit 9d9c02ccd, which added the notion of a "run condition" for
window functions, neglected to teach nodeFuncs.c to process the new
field.  Remarkably, that doesn't seem to have had any ill effects
before we invented Var.varnullingrels, but now it can cause visible
failures in join-removal scenarios.

I have no faith that there's not reachable problems in v15 too,
so back-patch the code change to v15 where 9d9c02ccd came in.
The test case seems irrelevant to v15, though.

Per bug #18277 from Zuming Jiang.  Diagnosis and patch by
Richard Guo.

Discussion: https://postgr.es/m/18277-089ead83b329a2fd@postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/d641b827af3966e349cbcc592bc51a4ab770c37b

Modified Files
--------------
src/backend/nodes/nodeFuncs.c        |  6 ++++++
src/test/regress/expected/window.out | 26 ++++++++++++++++++++++++++
src/test/regress/sql/window.sql      |  9 +++++++++
3 files changed, 41 insertions(+)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: pgsql: doc: clarify who owns the initdb-created cluster, by default
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix Asserts in calc_non_nestloop_required_outer().