pg.ddx.io  pgsql-committers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Alexander Korotkov <akorotkov@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Handle equality operator in contrib/pg_trgm
Date: Fri, 20 Sep 2024 22:19:26 +0200
Message-ID: <a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at> (raw)
In-Reply-To: <E1keAyM-0000qd-Dy@gemulon.postgresql.org>
References: <E1keAyM-0000qd-Dy@gemulon.postgresql.org>

On Sun, 2020-11-15 at 05:53 +0000, Alexander Korotkov wrote:
> Handle equality operator in contrib/pg_trgm
> 
> Obviously, in order to equality operator be satisfiable, target string must
> contain all the trigrams of the search string.  On this base, we implement
> equality operator in GiST/GIN indexes with recheck.
> 
> Discussion: https://postgr.es/m/CAOBaU_YWwtT7tdggtROacjdOdeYHCz-tmSwuC-j-TOG-g97J0w%40mail.gmail.com
> Author: Julien Rouhaud
> Reviewed-by: Tom Lane, Alexander Korotkov, Georgios Kokolatos, Erik Rijkers
> 
> Branch
> ------
> master
> 
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/935f6666502250abde8615bc7805a6e5aa05a066

This causes bad query results with non-deterministic collations, see
https://postgr.es/m/8ef4899c4acfebca45cc6c042a6dc611d25ffab1.camel@cybertec.at

Yours,
Laurenz Albe





view thread (2+ messages)

Message-ID: <a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at>
Permalink:  ../a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at/
Also on:    postgresql.org/message-id/a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-committers@postgresql.org
  Cc: laurenz.albe@cybertec.at, akorotkov@postgresql.org, pgsql-committers@lists.postgresql.org
  Subject: Re: pgsql: Handle equality operator in contrib/pg_trgm
  In-Reply-To: <a0a6a902cdf1112e73c29df0d31458becfbf793d.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox