Wrong Results from SP-GiST with Collations

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Wrong Results from SP-GiST with Collations
Date: 2018-04-10 16:21:58
Message-ID: CAE2gYzzb6K51VnTq5i5p52z+j9p2duEa-K1T3RrC_GQEynAKEg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Please see:

> # create table t (a text collate "cs_CZ");
> CREATE TABLE
>
> # insert into t values ('c'), ('ch');
> INSERT 0 2
>
> # select * from t where a < 'd';
> a
> ---
> c
> (1 row)
>
> xx2_game=# create index on t using spgist (a);
> CREATE INDEX
>
> xx2_game=# set enable_seqscan = 0;
> SET
>
> xx2_game=# select * from t where a < 'd';
> a
> ----
> c
> ch
> (2 rows)

I assume we don't have any option than removing support for comparison
operators with collations just like btree.

The bug may apply to the other access methods.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2018-04-10 16:38:12 Re: Wrong Results from SP-GiST with Collations
Previous Message Tom Lane 2018-04-10 16:11:08 Re: BUG #15149: Invalid cache id = 42