pgsql: Fix failure to set correct operator in window run condition - Mailing list pgsql-committers

From David Rowley
Subject pgsql: Fix failure to set correct operator in window run condition
Date
Msg-id E1oJj7R-000KwZ-8f@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix failure to set correct operator in window run condition

This was a simple omission in 9d9c02ccd where the code didn't correctly
set the operator to use in the run condition OpExpr when the window
function was both monotonically increasing and decreasing.

Bug discovered by Julien Roze, although he did not report it.

Reported-by: Phil Florent
Discussion: https://postgr.es/m/PA4P191MB160009A09B9D0624359278CFBA9F9@PA4P191MB1600.EURP191.PROD.OUTLOOK.COM
Backpatch-through: 15, where 9d9c02ccd was added

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/270eb4b5d4986534f2d522ebb19f67396d13cf44

Modified Files
--------------
src/backend/optimizer/path/allpaths.c |  1 +
src/test/regress/expected/window.out  | 17 +++++++++++++++++
src/test/regress/sql/window.sql       | 11 +++++++++++
3 files changed, 29 insertions(+)


pgsql-committers by date:

Previous
From: David Rowley
Date:
Subject: pgsql: Fix failure to set correct operator in window run condition
Next
From: Michael Paquier
Date:
Subject: pgsql: Use hba_file/ident_file GUCs rather than pg_hba.conf/pg_ident.co