[HACKERS] Regression failures: time, timetz, horology

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[HACKERS] Regression failures: time, timetz, horology

Michael Fuhr
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/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Reply | Threaded
Open this post in threaded view
|

Re: [HACKERS] Regression failures: time, timetz, horology

Tom Lane-2
Michael Fuhr <[hidden email]> 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.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Reply | Threaded
Open this post in threaded view
|

Re: [HACKERS] Regression failures: time, timetz, horology

Bruce Momjian-2
Tom Lane wrote:

> Michael Fuhr <[hidden email]> 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
  [hidden email]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match