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.