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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Repair corner-case bug in array version of percentile_cont().
Date: 2014-12-13 16:49:54
Message-ID: E1XzptC-0003Ra-QL@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
REL9_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/9ccae6360df4a8be845e28b0ab9042ab09e8c397

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(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2014-12-13 18:46:56 pgsql: Improve recovery target settings documentation.
Previous Message Heikki Linnakangas 2014-12-13 16:22:34 pgsql: Remove duplicate #define