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

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