It seems the 'numeric' and 'int8' tests are failing in CVS HEAD. The
culprit seems to be the recent to_char() change made by Karel, but I
haven't verified that. The diff follows.

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

*** ./expected/int8.out	Fri Jan 26 17:50:26 2001
--- ./results/int8.out	Fri Sep 20 12:37:25 2002
***************
*** 245,256 ****
  
  SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
   to_char_14 |      to_char      
! ------------+-------------------
!             | 456
!             | 4567890123456789
!             | 123
!             | 4567890123456789
!             | -4567890123456789
  (5 rows)
  
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
--- 245,256 ----
  
  SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
   to_char_14 |      to_char       
! ------------+--------------------
!             | 456.
!             | 4567890123456789.
!             | 123.
!             | 4567890123456789.
!             | -4567890123456789.
  (5 rows)
  
  SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;

======================================================================

*** ./expected/numeric.out	Fri Apr  7 15:17:42 2000
--- ./results/numeric.out	Fri Sep 20 12:37:36 2002
***************
*** 785,792 ****
             | +7799461.4119
             | +16397.038491
             | +93901.57763026
!            | -83028485
!            | +74881
             | -24926804.04504742
  (10 rows)
  
--- 785,792 ----
             | +7799461.4119
             | +16397.038491
             | +93901.57763026
!            | -83028485.
!            | +74881.
             | -24926804.04504742
  (10 rows)
  
***************
*** 800,807 ****
             | 7799461.4119
             | 16397.038491
             | 93901.57763026
!            | <83028485>
!            | 74881
             | <24926804.04504742>
  (10 rows)
  
--- 800,807 ----
             | 7799461.4119
             | 16397.038491
             | 93901.57763026
!            | <83028485.>
!            | 74881.
             | <24926804.04504742>
  (10 rows)
  
***************
*** 860,867 ****
              | 0000000007799461.4119
              | 0000000000016397.038491
              | 0000000000093901.57763026
!             | -0000000083028485
!             | 0000000000074881
              | -0000000024926804.04504742
  (10 rows)
  
--- 860,867 ----
              | 0000000007799461.4119
              | 0000000000016397.038491
              | 0000000000093901.57763026
!             | -0000000083028485.
!             | 0000000000074881.
              | -0000000024926804.04504742
  (10 rows)
  
***************
*** 950,957 ****
              | 7799461.4119
              | 16397.038491
              | 93901.57763026
!             | -83028485
!             | 74881
              | -24926804.04504742
  (10 rows)
  
--- 950,957 ----
              | 7799461.4119
              | 16397.038491
              | 93901.57763026
!             | -83028485.
!             | 74881.
              | -24926804.04504742
  (10 rows)
  
***************
*** 980,987 ****
              | +         7 7 9 9 4 6 1 . 4 1 1 9              
              | +           1 6 3 9 7 . 0 3 8 4 9 1            
              | +           9 3 9 0 1 . 5 7 7 6 3 0 2 6          
!             | -        8 3 0 2 8 4 8 5                   
!             | +           7 4 8 8 1                   
              | -        2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2          
  (10 rows)
  
--- 980,987 ----
              | +         7 7 9 9 4 6 1 . 4 1 1 9              
              | +           1 6 3 9 7 . 0 3 8 4 9 1            
              | +           9 3 9 0 1 . 5 7 7 6 3 0 2 6          
!             | -        8 3 0 2 8 4 8 5 .                  
!             | +           7 4 8 8 1 .                  
              | -        2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2          
  (10 rows)
  
***************
*** 1025,1032 ****
              | 7799461.4119
              | 16397.038491
              | 93901.57763026
!             | -83028485
!             | 74881
              | -24926804.04504742
  (10 rows)
  
--- 1025,1032 ----
              | 7799461.4119
              | 16397.038491
              | 93901.57763026
!             | -83028485.
!             | 74881.
              | -24926804.04504742
  (10 rows)
  

======================================================================


20 Sep 2002 12:42:27 -0400
Neil Conway <neilc@samurai.com>
regression test failure in CVS HEAD

Tom has fixed it.  Sorry I didn't test earlier.

---------------------------------------------------------------------------

Neil Conway wrote:
> It seems the 'numeric' and 'int8' tests are failing in CVS HEAD. The
> culprit seems to be the recent to_char() change made by Karel, but I
> haven't verified that. The diff follows.
> 
> Cheers,
> 
> Neil
> 
> -- 
> Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
> 
> *** ./expected/int8.out	Fri Jan 26 17:50:26 2001
> --- ./results/int8.out	Fri Sep 20 12:37:25 2002
> ***************
> *** 245,256 ****
>   
>   SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
>    to_char_14 |      to_char      
> ! ------------+-------------------
> !             | 456
> !             | 4567890123456789
> !             | 123
> !             | 4567890123456789
> !             | -4567890123456789
>   (5 rows)
>   
>   SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
> --- 245,256 ----
>   
>   SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
>    to_char_14 |      to_char       
> ! ------------+--------------------
> !             | 456.
> !             | 4567890123456789.
> !             | 123.
> !             | 4567890123456789.
> !             | -4567890123456789.
>   (5 rows)
>   
>   SELECT '' AS to_char_15, to_char(q2, 'S 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 . 9 9 9') FROM INT8_TBL;
> 
> ======================================================================
> 
> *** ./expected/numeric.out	Fri Apr  7 15:17:42 2000
> --- ./results/numeric.out	Fri Sep 20 12:37:36 2002
> ***************
> *** 785,792 ****
>              | +7799461.4119
>              | +16397.038491
>              | +93901.57763026
> !            | -83028485
> !            | +74881
>              | -24926804.04504742
>   (10 rows)
>   
> --- 785,792 ----
>              | +7799461.4119
>              | +16397.038491
>              | +93901.57763026
> !            | -83028485.
> !            | +74881.
>              | -24926804.04504742
>   (10 rows)
>   
> ***************
> *** 800,807 ****
>              | 7799461.4119
>              | 16397.038491
>              | 93901.57763026
> !            | <83028485>
> !            | 74881
>              | <24926804.04504742>
>   (10 rows)
>   
> --- 800,807 ----
>              | 7799461.4119
>              | 16397.038491
>              | 93901.57763026
> !            | <83028485.>
> !            | 74881.
>              | <24926804.04504742>
>   (10 rows)
>   
> ***************
> *** 860,867 ****
>               | 0000000007799461.4119
>               | 0000000000016397.038491
>               | 0000000000093901.57763026
> !             | -0000000083028485
> !             | 0000000000074881
>               | -0000000024926804.04504742
>   (10 rows)
>   
> --- 860,867 ----
>               | 0000000007799461.4119
>               | 0000000000016397.038491
>               | 0000000000093901.57763026
> !             | -0000000083028485.
> !             | 0000000000074881.
>               | -0000000024926804.04504742
>   (10 rows)
>   
> ***************
> *** 950,957 ****
>               | 7799461.4119
>               | 16397.038491
>               | 93901.57763026
> !             | -83028485
> !             | 74881
>               | -24926804.04504742
>   (10 rows)
>   
> --- 950,957 ----
>               | 7799461.4119
>               | 16397.038491
>               | 93901.57763026
> !             | -83028485.
> !             | 74881.
>               | -24926804.04504742
>   (10 rows)
>   
> ***************
> *** 980,987 ****
>               | +         7 7 9 9 4 6 1 . 4 1 1 9              
>               | +           1 6 3 9 7 . 0 3 8 4 9 1            
>               | +           9 3 9 0 1 . 5 7 7 6 3 0 2 6          
> !             | -        8 3 0 2 8 4 8 5                   
> !             | +           7 4 8 8 1                   
>               | -        2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2          
>   (10 rows)
>   
> --- 980,987 ----
>               | +         7 7 9 9 4 6 1 . 4 1 1 9              
>               | +           1 6 3 9 7 . 0 3 8 4 9 1            
>               | +           9 3 9 0 1 . 5 7 7 6 3 0 2 6          
> !             | -        8 3 0 2 8 4 8 5 .                  
> !             | +           7 4 8 8 1 .                  
>               | -        2 4 9 2 6 8 0 4 . 0 4 5 0 4 7 4 2          
>   (10 rows)
>   
> ***************
> *** 1025,1032 ****
>               | 7799461.4119
>               | 16397.038491
>               | 93901.57763026
> !             | -83028485
> !             | 74881
>               | -24926804.04504742
>   (10 rows)
>   
> --- 1025,1032 ----
>               | 7799461.4119
>               | 16397.038491
>               | 93901.57763026
> !             | -83028485.
> !             | 74881.
>               | -24926804.04504742
>   (10 rows)
>   
> 
> ======================================================================
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
  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, Pennsylvania 19073

Fri, 20 Sep 2002 13:12:17 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: regression test failure in CVS HEAD
On Fri, Sep 20, 2002 at 01:12:17PM -0400, Bruce Momjian wrote:
> 
> Tom has fixed it.  Sorry I didn't test earlier.

 Thanks.

> Neil Conway wrote:
> > It seems the 'numeric' and 'int8' tests are failing in CVS HEAD. The
> > culprit seems to be the recent to_char() change made by Karel, but I
> > haven't verified that. The diff follows.

 You're right. Sorry.

> >   SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM INT8_TBL;
> >    to_char_14 |      to_char       
> > ! ------------+--------------------
> > !             | 456.
> > !             | 4567890123456789.
> > !             | 123.
> > !             | 4567890123456789.
> > !             | -4567890123456789.


 The results like this are right.

    Karel

-- 
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

Mon, 23 Sep 2002 08:39:34 +0200
Karel Zak <zakkr@zf.jcu.cz>
Re: regression test failure in CVS HEAD