Re: Some regression tests are failed RH7.0

Tom Lane wrote:

> Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> writes:
> > Tom Lane wrote:
> >> Can't tell a thing from that amount of detail. What's in
> >> regression.diffs?
>
> > It appears to be the locale deal, Tom. It hits a little too familiar of
> > a chord (and pattern). If we analyze his regression.diffs, we'll see
> > lots of collation stuff, as well as money format stuff, I'd wager.
>
> I suspected as much, but didn't want to leap to a conclusion without
> seeing the diffs.
>
> > The fix is to set the locale to C. Editing /etc/sysconfig/i18n to set
> > either LANG=C or LC_ALL=C. Or simply delete it and reboot.
>
> Note also that if you change the postmaster's locale you'd better redo
> initdb.
>
> BTW, it occurs to me that we don't have anything about locale issues in
> the documentation about interpreting the regression tests. Will fix.
>
> regards, tom lane

Hi tom lane and lamar owen

Thank your for our fast answer.

1. i will give your more infomation about regression tests
(regression.diff and /etc/sysconfig/i18n see below).

2. Should i change the LANG="en_US" to LANG="C" and send your a new regression

test report?

regards, martin eichhorn

/usr/lib/pgsql/test/regress/regression.diffs:
******************************************************************************************************

*** expected/char.out Tue Jan 4 17:19:34 2000
--- results/char.out Mon Mar 19 14:38:22 2001
***************
*** 62,73 ****
WHERE c.f1 < 'a';
five | f1
------+----
- | A
| 1
| 2
| 3
|
! (5 rows)

SELECT '' AS six, c.*
FROM CHAR_TBL c
--- 62,72 ----
WHERE c.f1 < 'a';
five | f1
------+----
| 1
| 2
| 3
|
! (4 rows)

SELECT '' AS six, c.*
FROM CHAR_TBL c
***************
*** 75,94 ****
six | f1
-----+----
| a
- | A
| 1
| 2
| 3
|
! (6 rows)

SELECT '' AS one, c.*
FROM CHAR_TBL c
WHERE c.f1 > 'a';
one | f1
-----+----
| c
! (1 row)

SELECT '' AS two, c.*
FROM CHAR_TBL c
--- 74,93 ----
six | f1
-----+----
| a
| 1
| 2
| 3
|
! (5 rows)

SELECT '' AS one, c.*
FROM CHAR_TBL c
WHERE c.f1 > 'a';
one | f1
-----+----
+ | A
| c
! (2 rows)

SELECT '' AS two, c.*
FROM CHAR_TBL c
***************
*** 96,103 ****
two | f1
-----+----
| a
| c
! (2 rows)

DROP TABLE CHAR_TBL;
--
--- 95,103 ----
two | f1
-----+----
| a
+ | A
| c
! (3 rows)

DROP TABLE CHAR_TBL;
--

----------------------

*** expected/varchar.out Tue Jan 4 17:19:34 2000
--- results/varchar.out Mon Mar 19 14:38:26 2001
***************
*** 50,61 ****
WHERE c.f1 < 'a';
five | f1
------+----
- | A
| 1
| 2
| 3
|
! (5 rows)

SELECT '' AS six, c.*
FROM VARCHAR_TBL c
--- 50,60 ----
WHERE c.f1 < 'a';
five | f1
------+----
| 1
| 2
| 3
|
! (4 rows)

SELECT '' AS six, c.*
FROM VARCHAR_TBL c
***************
*** 63,82 ****
six | f1
-----+----
| a
- | A
| 1
| 2
| 3
|
! (6 rows)

SELECT '' AS one, c.*
FROM VARCHAR_TBL c
WHERE c.f1 > 'a';
one | f1
-----+----
| c
! (1 row)

SELECT '' AS two, c.*
FROM VARCHAR_TBL c
--- 62,81 ----
six | f1
-----+----
| a
| 1
| 2
| 3
|
! (5 rows)

SELECT '' AS one, c.*
FROM VARCHAR_TBL c
WHERE c.f1 > 'a';
one | f1
-----+----
+ | A
| c
! (2 rows)

SELECT '' AS two, c.*
FROM VARCHAR_TBL c
***************
*** 84,91 ****
two | f1
-----+----
| a
| c
! (2 rows)

DROP TABLE VARCHAR_TBL;
--
--- 83,91 ----
two | f1
-----+----
| a
+ | A
| c
! (3 rows)

DROP TABLE VARCHAR_TBL;
--

----------------------

*** expected/int8.out Fri Apr 7 21:17:39 2000
--- results/int8.out Mon Mar 19 14:38:30 2001
***************
*** 246,256 ****
SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM
INT8_TBL;
to_char_13 | to_char
------------+------------------------
! | 456.000
! | 4567890123456789.000
! | 123.000
! | 4567890123456789.000
! | -4567890123456789.000
(5 rows)

SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM
INT8_TBL;
--- 246,256 ----
SELECT '' AS to_char_13, to_char(q2, 'L9999999999999999.000') FROM
INT8_TBL;
to_char_13 | to_char
------------+------------------------
! | $ 456.000
! | $ 4567890123456789.000
! | $ 123.000
! | $ 4567890123456789.000
! | $-4567890123456789.000
(5 rows)

SELECT '' AS to_char_14, to_char(q2, 'FM9999999999999999.999') FROM
INT8_TBL;

----------------------

*** expected/numeric.out Fri Apr 7 21:17:42 2000
--- results/numeric.out Mon Mar 19 14:40:51 2001
***************
*** 928,943 ****
SELECT '' AS to_char_16, to_char(val,
'L9999999999999999.099999999999999') FROM num_data;
to_char_16 | to_char
------------+------------------------------------
! | .000000000000000
! | .000000000000000
! | -34338492.215397047000000
! | 4.310000000000000
! | 7799461.411900000000000
! | 16397.038491000000000
! | 93901.577630260000000
! | -83028485.000000000000000
! | 74881.000000000000000
! | -24926804.045047420000000
(10 rows)

SELECT '' AS to_char_17, to_char(val,
'FM9999999999999999.99999999999999') FROM num_data;
--- 928,943 ----
SELECT '' AS to_char_16, to_char(val,
'L9999999999999999.099999999999999') FROM num_data;
to_char_16 | to_char
------------+------------------------------------
! | $ .000000000000000
! | $ .000000000000000
! | $ -34338492.215397047000000
! | $ 4.310000000000000
! | $ 7799461.411900000000000
! | $ 16397.038491000000000
! | $ 93901.577630260000000
! | $ -83028485.000000000000000
! | $ 74881.000000000000000
! | $ -24926804.045047420000000
(10 rows)

SELECT '' AS to_char_17, to_char(val,
'FM9999999999999999.99999999999999') FROM num_data;

----------------------

*** expected/select_implicit.out Thu Jan 6 07:40:54 2000
--- results/select_implicit.out Mon Mar 19 14:44:01 2001
***************
*** 22,32 ****
c | count
----------+-------
AAAA | 2
BBBB | 2
CCCC | 2
XXXX | 1
- bbbb | 1
- cccc | 2
(6 rows)

-- w/o existing GROUP BY target using a relation name in GROUP BY clause
--- 22,32 ----
c | count
----------+-------
AAAA | 2
+ bbbb | 1
BBBB | 2
+ cccc | 2
CCCC | 2
XXXX | 1
(6 rows)

-- w/o existing GROUP BY target using a relation name in GROUP BY clause
***************
*** 34,44 ****
count
-------
2
2
2
- 1
- 1
2
(6 rows)

-- w/o existing GROUP BY target and w/o existing a different ORDER BY
target
--- 34,44 ----
count
-------
2
+ 1
2
2
2
+ 1
(6 rows)

-- w/o existing GROUP BY target and w/o existing a different ORDER BY
target
***************
*** 104,114 ****
c | count
----------+-------
AAAA | 2
BBBB | 2
CCCC | 2
XXXX | 1
- bbbb | 1
- cccc | 2
(6 rows)

-- group using reference number out of range
--- 104,114 ----
c | count
----------+-------
AAAA | 2
+ bbbb | 1
BBBB | 2
+ cccc | 2
CCCC | 2
XXXX | 1
(6 rows)

-- group using reference number out of range

----------------------

*** expected/select_having.out Thu Jan 6 07:40:54 2000
--- results/select_having.out Mon Mar 19 14:44:02 2001
***************
*** 34,41 ****
GROUP BY c HAVING count(*) > 2 OR min(a) = max(a);
c | max
----------+-----
- XXXX | 0
bbbb | 5
(2 rows)

DROP TABLE test_having;
--- 34,41 ----
GROUP BY c HAVING count(*) > 2 OR min(a) = max(a);
c | max
----------+-----
bbbb | 5
+ XXXX | 0
(2 rows)

DROP TABLE test_having;

----------------------

*** expected/select_views.out Sun Jan 9 04:48:37 2000
--- results/select_views.out Mon Mar 19 14:44:51 2001
***************
*** 415,420 ****
--- 415,434 ----
I- 580 | 21
I- 580 | 22
I- 580 | 22
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 2
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 4
+ I- 580/I-680 Ramp | 5
+ I- 580/I-680 Ramp | 6
+ I- 580/I-680 Ramp | 6
+ I- 580/I-680 Ramp | 6
I- 580 Ramp | 2
I- 580 Ramp | 2
I- 580 Ramp | 2
***************
*** 665,684 ****
I- 580 Ramp | 8
I- 580 Ramp | 8
I- 580 Ramp | 8
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 2
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 4
- I- 580/I-680 Ramp | 5
- I- 580/I-680 Ramp | 6
- I- 580/I-680 Ramp | 6
- I- 580/I-680 Ramp | 6
I- 680 | 2
I- 680 | 2
I- 680 | 2
--- 679,684 ----

----------------------

******************************************************************************************************

/etc/sysconfig/i18n:
******************************************************************************************************

LANG="en_US"
******************************************************************************************************