9.4rc bug in percentile_cont - Mailing list pgsql-hackers

From Andrew Gierth
Subject 9.4rc bug in percentile_cont
Date
Msg-id 878uicrq9w.fsf@news-spur.riddles.org.uk
Whole thread Raw
Responses Re: 9.4rc bug in percentile_cont  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Just got a report on IRC of a bug in the array version of
percentile_cont; if two of the requested percentiles were between the
same pair of input rows, the result could be wrong or an error would
be generated.

e.g.

select percentile_cont(array[0.4,0.6]) within group (order by gs)
  from generate_series(1,2) gs;
ERROR: missing row in percentile_cont

Proposed patch (against current master) attached.

--
Andrew (irc:RhodiumToad)


Attachment

pgsql-hackers by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: Final Patch for GROUPING SETS
Next
From: Craig Ringer
Date:
Subject: Making BackgroundWorkerHandle a complete type or offering a worker enumeration API?