pgsql: Repair corner-case bug in array version of percentile_cont(). - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Repair corner-case bug in array version of percentile_cont().
Date
Msg-id E1XzptC-0003RZ-QG@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Repair corner-case bug in array version of percentile_cont().

The code for advancing through the input rows overlooked the case that we
might already be past the first row of the row pair now being considered,
in case the previous percentile also fell between the same two input rows.

Report and patch by Andrew Gierth; logic rewritten a bit for clarity by me.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b0f479113abaf28f1c9ed25d856ffe6fd4bb7dc9

Modified Files
--------------
src/backend/utils/adt/orderedsetaggs.c   |   34 ++++++++++++++++++------------
src/test/regress/expected/aggregates.out |    8 +++----
src/test/regress/sql/aggregates.sql      |    2 +-
3 files changed, 26 insertions(+), 18 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Repair corner-case bug in array version of percentile_cont().
Next
From: Tom Lane
Date:
Subject: pgsql: Improve recovery target settings documentation.