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
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 |
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 |