From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paesold <mpaesold(at)gmx(dot)at>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Interval aggregate regression failure |
Date: | 2006-09-06 02:05:48 |
Message-ID: | 200609060205.k8625mw21002@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Patch applied. Thanks.
---------------------------------------------------------------------------
Michael Glaesemann wrote:
>
> On Sep 5, 2006, at 10:14 , Bruce Momjian wrote:
>
> > Bruce Momjian wrote:
> >> OK, updated patch. It will fix the >=24:00:00 case because it
> >> cascades
> >> up if the remainder number of seconds is greater or equal to one day.
> >> One open item is that it still might show >24 hours if the seconds
> >> computation combined with the remaning seconds >24 hours. Not
> >> sure if
> >> that should be handled or not. If you fix that, you really are
> >> cascading up because the resulting seconds might be less than the
> >> computed value, e.g. result is 23:00:00, remainder is 02:00:00,
> >> cascade
> >> up would be 1 day, 01:00:00. I am unsure we want to do that. Right
> >> now, this will show 25:00:00.
> >
> > Updated patch that uses TSROUND for partial month and days. Michael
> > says the tests look good on his system. I think we are done with this
> > bug. :-)
>
> Please find attached regression tests for this patch.
>
> Michael Glaesemann
> grzm seespotcode net
>
[ Attachment, skipping... ]
>
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bernd Helmle | 2006-09-06 06:13:20 | Re: Open items for 8.2 |
Previous Message | Jeremy Drake | 2006-09-06 01:06:11 | Re: [HACKERS] large object regression tests |