On Tue, Jun 18, 2013 at 12:51 PM, Svenne Krap <svenne.li...@krap.dk> wrote:
> > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > On 18-06-2013 21:41, Svenne Krap wrote: > > > > > > > > I will dig futher and get back... > > The regression test was added in 9.2, the earliest interesting commit is > d6d5f67b5b98b1685f9158e9d00a726afb2ae789, > where Tom Lane changes the definition to the current. > I get it back to e2c2c2e8b1df7dfdb01e7, where the ability to have one index with the same column twice appears. The problem is the f1 > 'WA' part of the query. In Danish, apparently 'AA' > 'WA', so two more rows show up. SELECT f1 FROM dupindexcols WHERE f1 > 'WA' and id < 1000 and f1 ~<~ 'YX' except SELECT f1 FROM dupindexcols WHERE f1 ~>~ 'WA' and id < 1000 and f1 ~<~ 'YX'; f1 -------- AANAAA AAMAAA I don't know how important it is to the community for make check to pass under every possible LANG setting, or the best way to go about fixing it if it is important. Cheers, Jeff