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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc-Olaf Jaschke <marc-olaf(dot)jaschke(at)s24(dot)com>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, 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 00:03:41
Message-ID: 9688.1458605021@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Marc-Olaf Jaschke <marc-olaf(dot)jaschke(at)s24(dot)com> writes:
> PostgreSQL 9.5 ignores rows with the following test case:

I can reproduce this in 9.5 and HEAD on RHEL6, but 9.4 works as expected.
I presume that that points the finger at the abbreviated-keys work.

BTW, what I'm seeing in 9.5/HEAD is that all three comparison senses fail:

u8=# set enable_seqscan TO 0;
SET
u8=# select * from test where t < 'eai';
t
---
(0 rows)

u8=# select * from test where t = 'eai';
t
---
(0 rows)

u8=# select * from test where t > 'eai';
t
---
(0 rows)

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2016-03-22 00:26:25 Re: Missing rows with index scan when collation is not "C" (PostgreSQL 9.5)
Previous Message Daniel Golle 2016-03-21 21:38:28 Re: BUG #14033: cross-compilation to ARM fails

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2016-03-22 00:11:46 Re: dealing with extension dependencies that aren't quite 'e'
Previous Message Robert Haas 2016-03-21 23:33:49 Re: Relax requirement for INTO with SELECT in pl/pgsql