Re: regress test failed

On 09/04/2011 08:23 AM, Pavel Stehule wrote:
> Hello
>
> there is one regress test, that failed on my f14
>
> [pavel(at)nemesis postgresql]$ uname -a
> Linux nemesis 2.6.35.14-95.fc14.i686.PAE #1 SMP Tue Aug 16 21:12:22
> UTC 2011 i686 i686 i386 GNU/Linux
>
> regression.diffs
>
> 3676/3676 100%
> *** /home/pavel/src/postgresql/src/test/regress/expected/foreign_data.out
> 2011-09-04 14:17:23.463589991 +0200
> --- /home/pavel/src/postgresql/src/test/regress/results/foreign_data.out
> 2011-09-04 14:20:06.649144130 +0200
> ***************
> *** 781,791 ****
> SELECT * FROM information_schema.foreign_servers ORDER BY 1, 2;
> foreign_server_catalog | foreign_server_name |
> foreign_data_wrapper_catalog | foreign_data_wrapper_name |
> foreign_server_type | foreign_server_version |
> authorization_identifier
> ------------------------+---------------------+------------------------------+---------------------------+---------------------+------------------------+--------------------------
> regression | s4 | regression
> | foo | oracle |
> | foreign_data_user
> regression | s5 | regression
> | foo | | 15.0
> | regress_test_role
> regression | s6 | regression
> | foo | | 16.0
> | regress_test_indirect
> regression | s8 | regression
> | postgresql | |
> | foreign_data_user
> - regression | sc | regression
> | dummy | |
> | foreign_data_user
> regression | t1 | regression
> | foo | |
> | regress_test_indirect
> regression | t2 | regression
> | foo | |
> | regress_test_role
> (7 rows)
> --- 781,791 ----
> SELECT * FROM information_schema.foreign_servers ORDER BY 1, 2;
> foreign_server_catalog | foreign_server_name |
> foreign_data_wrapper_catalog | foreign_data_wrapper_name |
> foreign_server_type | foreign_server_version |
> authorization_identifier
> ------------------------+---------------------+------------------------------+---------------------------+---------------------+------------------------+--------------------------
> + regression | sc | regression
> | dummy | |
> | foreign_data_user
> regression | s4 | regression
> | foo | oracle |
> | foreign_data_user
> regression | s5 | regression
> | foo | | 15.0
> | regress_test_role
> regression | s6 | regression
> | foo | | 16.0
> | regress_test_indirect
> regression | s8 | regression
> | postgresql | |
> | foreign_data_user
> regression | t1 | regression
> | foo | |
> | regress_test_indirect
> regression | t2 | regression
> | foo | |
> | regress_test_role
> (7 rows)
>
> tested on HEAD
>
>

In what locale does 'sc' sort before 's4'? (And I'd humbly suggest that
whatever locale it is is possibly broken.)

cheers

andrew