From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Neil Conway <neilc(at)samurai(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Subject: | Re: regression test failure in CVS HEAD |
Date: | 2002-09-20 17:12:17 |
Message-ID: | 200209201712.g8KHCHI07107@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)samurai(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Benoit | 2002-09-20 17:27:13 | Re: Improving speed of copy |
Previous Message | Neil Conway | 2002-09-20 16:42:27 | regression test failure in CVS HEAD |