Re: Git-master regression failure

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Svenne Krap <svenne(dot)lists(at)krap(dot)dk>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Git-master regression failure
Date: 2013-06-18 20:18:31
Message-ID: CAMkU=1z0+4iRp0+6D9K7=2AbjJ4xEeH=oU+8R6VxfGNTP3kHgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 18, 2013 at 12:51 PM, Svenne Krap <svenne(dot)lists(at)krap(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2013-06-18 20:23:43 Re: Git-master regression failure
Previous Message Kevin Grittner 2013-06-18 20:16:16 Re: Git-master regression failure