Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)

From: Peter Geoghegan <pg(at)heroku(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marc-Olaf Jaschke <marc-olaf(dot)jaschke(at)s24(dot)com>, pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)
Date: 2016-03-22 07:53:31
Message-ID: CAM3SWZTn2a7w5gyM0JawZBok6wDtn9k5shFSZx7ZbGTn0k=ibg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Mon, Mar 21, 2016 at 10:16 PM, Peter Geoghegan <pg(at)heroku(dot)com> wrote:
> "eai" -> 100c14 01 090909 01 090909 (11 bytes)
> "e aí" -> 100c14 01 0b0909 01 090909010235 (14 bytes)

> "eai" -> 100c14 01 080808 01 020202 (11 bytes)
> "e aí" -> 100c14 01 080809 01 020202010235 (14 bytes)

Sorry, I have that backwards. The latter output is Tom's de_DE.UTF-8
testcase, showing broken glibc behavior.

--
Peter Geoghegan

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message ivan 2016-03-22 14:42:09 problem in sql - sum()
Previous Message Peter Geoghegan 2016-03-22 05:16:34 Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2016-03-22 08:08:16 Some messages of pg_rewind --debug not getting translated
Previous Message Michael Paquier 2016-03-22 07:37:07 Re: OOM in libpq and infinite loop with getCopyStart()