Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 761AD6309F0 for ; Sun, 11 Jan 2009 12:47:13 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 07935-03 for ; Sun, 11 Jan 2009 12:47:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 7F08D62DBEB for ; Sun, 11 Jan 2009 12:47:10 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id n0BGkUpY021942; Sun, 11 Jan 2009 11:46:30 -0500 (EST) To: Peter Eisentraut cc: pgsql-hackers@postgresql.org, Andrew Dunstan , Heikki Linnakangas Subject: Re: foreign_data test fails with non-C locale In-reply-to: <200901111254.03722.peter_e@gmx.net> References: <49675B3F.20002@enterprisedb.com> <49676B8A.8020707@dunslane.net> <26314.1231518295@sss.pgh.pa.us> <200901111254.03722.peter_e@gmx.net> Comments: In-reply-to Peter Eisentraut message dated "Sun, 11 Jan 2009 12:54:02 +0200" Date: Sun, 11 Jan 2009 11:46:30 -0500 Message-ID: <21941.1231692390@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/804 X-Sequence-Number: 131448 Peter Eisentraut writes: > This called for an extensive test ... :-) > My glibc installation supplies 668 locales (locale -a), which appear to > represent about 225 distinct language/country combinations. (The rest are > encoding variants.) > I ran the regression tests with all of them, and got 95 failures (out of 668). Fascinating data. I assume you did not remove the existing locale-variant expected files? IOW this isn't "all the locale dependencies", but "all the ones we didn't fix previously"? > We could easily get rid of the aa, ch, and v/w failures by adjusting the test > data, since the data is completely coincidental anyway. I propose to do > that, and document these issues so that they can be avoided in future tests. I have no confidence in the ability of some documentation to keep the tests clean. However, if we had buildfarm members testing in locales that exercise each of those cases, it'd be all right. If we try to fix those cases I think we should try to fix Turkish i as well ... but I concur that first requires determining if it's behaving wrong or not. Devrim, or someone? > Also, considering that some of these alternative sorting rules appear to be > controversial even among users of the language (e.g., we have had actual bug > reports that the es_EC rule is wrong, and the sv_SE rule is also obsolete > according to the language regulators), it might be interesting to write a > small test program that can tell users how their current locale behaves in > known corner cases. Considering the number of people who complain about en_US (expecting C sort order instead), I'm not sure you should consider this a corner case. regards, tom lane