Обсуждение: Regression failures: time, timetz, horology

I'm getting time, timetz, and horology regression failures in HEAD
on Solaris 9 / gcc 3.4.2.  So are other machines in the build farm,
such as this one:

http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=shark&dt=2005-05-26%2004:21:00

I'm getting the same regression failures shown in that link; here's
an example:

***************
*** 34,45 ****  SELECT f1 AS "Five" FROM TIME_TBL WHERE f1 > '05:06:07';     Five     
! -------------  11:59:00  12:00:00  12:01:00  23:59:00
!  23:59:59.99 (5 rows)  SELECT f1 AS "None" FROM TIME_TBL WHERE f1 < '00:00';
--- 34,45 ----  SELECT f1 AS "Five" FROM TIME_TBL WHERE f1 > '05:06:07';      Five     
! --------------  11:59:00  12:00:00  12:01:00  23:59:00
!  23:59:59.990 (5 rows)  SELECT f1 AS "None" FROM TIME_TBL WHERE f1 < '00:00';

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Michael Fuhr <mike@fuhr.org> writes:
> I'm getting time, timetz, and horology regression failures in HEAD
> on Solaris 9 / gcc 3.4.2.  So are other machines in the build farm,
> such as this one:

I'll bet a nickel this broke it:

2005-05-25 23:48  momjian
* src/: backend/utils/adt/datetime.c,interfaces/ecpg/pgtypeslib/interval.c: Display only 9 not 10 digitsof precision
fortimestamp values when using non-integertimestamps.  This prevents the display of rounding errors forcommon values
likedays < 32.
 
        regards, tom lane

Tom Lane wrote:
> Michael Fuhr <mike@fuhr.org> writes:
> > I'm getting time, timetz, and horology regression failures in HEAD
> > on Solaris 9 / gcc 3.4.2.  So are other machines in the build farm,
> > such as this one:
> 
> I'll bet a nickel this broke it:
> 
> 2005-05-25 23:48  momjian
> 
>     * src/: backend/utils/adt/datetime.c,
>     interfaces/ecpg/pgtypeslib/interval.c: Display only 9 not 10 digits
>     of precision for timestamp values when using non-integer
>     timestamps.  This prevents the display of rounding errors for
>     common values like days < 32.

Yea, backing out.  I thought I tested it, but I guess not.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073