subject:"\[HACKERS\] regression test failure in CVS HEAD"

Re: [HACKERS] regression test failure in CVS HEAD

2002-09-23 Thread Karel Zak


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, 'FM.999') FROM INT8_TBL;
 to_char_14 |  to_char   
  ! +
  ! | 456.
  ! | 4567890123456789.
  ! | 123.
  ! | 4567890123456789.
  ! | -4567890123456789.


 The results like this are right.

Karel

-- 
 Karel Zak  [EMAIL PROTECTED]
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

[HACKERS] regression test failure in CVS HEAD

2002-09-20 Thread Neil Conway


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 [EMAIL PROTECTED] || 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, 'FM.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, 'FM.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 
  | 07799461.4119
  | 00016397.038491
  | 00093901.57763026
! | -83028485
! | 00074881
  | -24926804.04504742
  (10 rows)
  
--- 860,867 
  | 07799461.4119
  | 00016397.038491
  | 00093901.57763026
! | -83028485.
! | 00074881.
  | -24926804.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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Re: [HACKERS] regression test failure in CVS HEAD

2002-09-20 Thread Bruce Momjian



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 [EMAIL PROTECTED] || PGP Key ID: DB3C29FC
 
 *** ./expected/int8.out   Fri Jan 26 17:50:26 2001
 --- ./results/int8.outFri Sep 20 12:37:25 2002
 ***
 *** 245,256 
   
   SELECT '' AS to_char_14, to_char(q2, 'FM.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, 'FM.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.outFri 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 
   | 07799461.4119
   | 00016397.038491
   | 00093901.57763026
 ! | -83028485
 ! | 00074881
   | -24926804.04504742
   (10 rows)
   
 --- 860,867 
   | 07799461.4119
   | 00016397.038491
   | 00093901.57763026
 ! | -83028485.
 ! | 00074881.
   | -24926804.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

Re: [HACKERS] regression test failure in CVS HEAD

[HACKERS] regression test failure in CVS HEAD

Re: [HACKERS] regression test failure in CVS HEAD

3 matches

Site Navigation

Mail list logo

Footer information