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
|
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: