Skip Menu |

This queue is for tickets about the DBD-SQLite-Amalgamation CPAN distribution.

Report information
The Basics
Id: 117561
Status: open
Priority: 0/
Queue: DBD-SQLite-Amalgamation

People
Owner: Nobody in particular
Requestors: SREZIC [...] cpan.org
Cc: ANDK [...] cpan.org
AdminCc:

Bug Information
Severity: (no value)
Broken in:
  • 3.6.1.2
  • 3.6.16
Fixed in: (no value)



CC: ANDK [...] cpan.org
Subject: Test failures with German locale and perl >= 5.25.2
With perl >= 5.25.2 and a German locale (LC_ALL=de_DE.UTF-8) the t/12create_collation.t test fails: # Failed test 'collate perllocale (Bergere, Bergère, HAT, HOT, berger, bergère, ferme, fête, fétu, fève, hâter, héraut, hétaïre, hétéroclite, hêtre, hôte // Bergère, Bergere, HAT, HOT, bergère, berger, fétu, fève, fête, ferme, hâter, héraut, hétéroclite, hétaïre, hôte, hêtre)' # at t/12create_collation.t line 81. # Structures begin differing at: # $got->[0] = 'Bergere' # $expected->[0] = 'Bergère' # Looks like you failed 1 test of 8. t/12create_collation.t .. Dubious, test returned 1 (wstat 256, 0x100) Failed 1/8 subtests No problem with LC_ALL=C (any perl version) or perl <= 5.25.1 (German or C locale). @ANDK: this looks like a bisect candidate.
CC: ANDK [...] cpan.org, khw [...] cpan.org
Subject: Re: [rt.cpan.org #117561] Test failures with German locale and perl >= 5.25.2
Date: Wed, 07 Sep 2016 06:13:29 +0200
To: "Slaven_Rezic via RT" <bug-DBD-SQLite-Amalgamation [...] rt.cpan.org>
From: Andreas Koenig <andreas.koenig.7os6VVqR [...] franz.ak.mind.de>
Show quoted text
> @ANDK: this looks like a bisect candidate.
a4a439fb9cd74c575855119abb55dc091955bdf4 is the first bad commit commit a4a439fb9cd74c575855119abb55dc091955bdf4 Author: Karl Williamson <khw@cpan.org> Date: Tue May 17 20:50:55 2016 -0600 Do better locale collation in UTF-8 locales @khw: this is about https://rt.cpan.org/Ticket/Display.html?id=117561 -- andreas
On Tue Sep 06 22:13:48 2016, andreas.koenig.7os6VVqR@franz.ak.mind.de wrote: Show quoted text
> > @ANDK: this looks like a bisect candidate.
> > a4a439fb9cd74c575855119abb55dc091955bdf4 is the first bad commit > commit a4a439fb9cd74c575855119abb55dc091955bdf4 > Author: Karl Williamson <khw@cpan.org> > Date: Tue May 17 20:50:55 2016 -0600 > > Do better locale collation in UTF-8 locales > > @khw: this is about https://rt.cpan.org/Ticket/Display.html?id=117561 >
I suspect that the test is wrong, and that the blamed commit actually fixed perl to behave correctly on UTF-8 locales for the first time. I think you will find that strcoll() would sort these words the same on the same locale. Previously perl did not handle this correctly. (And you're using a German locale to sort French words.) My understanding of typical French sort order is that the unaccented letters sort just before the accented versions of each, and that is what happening here. The plain a does come before the accented one.