| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | 9.4rc bug in percentile_cont |
| Date: | 2014-12-13 07:05:39 |
| Message-ID: | 878uicrq9w.fsf@news-spur.riddles.org.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| pcontfix.patch | text/x-patch | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2014-12-13 09:13:52 | Making BackgroundWorkerHandle a complete type or offering a worker enumeration API? |
| Previous Message | Andrew Gierth | 2014-12-13 04:37:48 | Re: Final Patch for GROUPING SETS |