regression test failure in CVS HEAD - Mailing list pgsql-hackers

From Neil Conway
Subject regression test failure in CVS HEAD
Date
Msg-id 87hegk7guk.fsf@mailbox.samurai.com
Whole thread Raw
Responses Re: regression test failure in CVS HEAD  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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
99') 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 .
99 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
38 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
38 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) 

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



pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Novell releasing PostgreSQL for NetWare.
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Memory Errors...